NEEDS TO BE SOLVED WITH A TEMPLATE FOR HYPOTHESIS TESTING IN EXCEL A company can choose between...

50.1K

Verified Solution

Question

Basic Math

NEEDS TO BE SOLVED WITH A TEMPLATE FOR HYPOTHESIS TESTING INEXCEL
A company can choose between two brands of light bulbs for anoffice complex and wants to know if one brand lasts longer thananother brand. Test results for the two brands are shown in thetable below. Is there persuasive evidence for company officials toconclude at Î± = 0.05 that there is a difference in the length oflife of the lightbulbs?
n Life of lightbulbs (hours) (x-bar) St. Dev. (Ïƒ)
Brand A 49 1055 20
Brand B 64 1045 15
a. Give the null andalternative hypotheses for this test in symbolic form.
H₀:
H₁:
b. Determine thevalue of the test statistic.
c. Determine theappropriate critical value(s).
d Determine theP-value.
e. Based upon your work above, should you \"Reject the null hypothesis\"or \"Fail to reject the null hypothesis?\" Explain yourreasoning.
f. Is theresufficient statistical evidence to presade the company officilasthat there is a difference in the length of the life of thelightbulbs? Explain your reasoning.

Answer & Explanation Solved by verified expert

4.2 Ratings (523 Votes)

SolutionaHoHaHa is claimSolutionbuse templatehttpswwwmoresteamcom university downloads calculatorsIn sheet 6Two means Z testTwo Means ZTestReturn To MapInstructions1 To obtain the critical values cutoff values for yourtestCurveLegend enter the desired significance See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

	n	Life of lightbulbs (hours) (x-bar)	St. Dev. (Ïƒ)
Brand A	49	1055	20
Brand B	64	1045	15

a.	Give the null andalternative hypotheses for this test in symbolic form.
		H₀:
		H₁:

b.	Determine thevalue of the test statistic.



c.	Determine theappropriate critical value(s).



d	Determine theP-value.



e.	Based upon your work above, should you \"Reject the null hypothesis\"or \"Fail to reject the null hypothesis?\" Explain yourreasoning.



f.	Is theresufficient statistical evidence to presade the company officilasthat there is a difference in the length of the life of thelightbulbs? Explain your reasoning.