USING EXCEL FORMULAS SOLVE THE PROBLEM. MUST USE EXCEL
CALCULATIONS AND FORMULAS.!!!
Find the data for the...
90.2K
Verified Solution
Link Copied!
Question
Statistics
USING EXCEL FORMULAS SOLVE THE PROBLEM. MUST USE EXCELCALCULATIONS AND FORMULAS.!!!
Find the data for the problem in the first worksheet namedLightbulbLife of the data table down below It gives the data on thelifetime in hours of a sample of 50 lightbulbs. The companymanufacturing these bulbs wants to know whether it can claim thatits lightbulbs typically last more than 1000 burning hours. So itdid a study.
Identify the null and the alternate hypotheses for thisstudy.
Can this lightbulb manufacturer claim at a significance levelof 5% that its lightbulbs typically last more than 1000 hours? Whatabout at 1%? Test your hypothesis using both, the critical valueapproach and the p-value approach. Clearly state yourconclusions.
Under what situation would a Type-I error occur? What would bethe consequences of a Type-I error?
Under what situation would a Type-II error occur? What would bethe consequences of a Type-II error?
lightbulb
Lifetime
1
840.08
2
960
3
953.38
4
981.14
5
938.66
6
1051.14
7
907.84
8
1000.1
9
1073.2
10
1150.66
11
1010.57
12
791.59
13
896.24
14
955.35
15
937.94
16
1113.18
17
1108.81
18
773.62
19
1038.43
20
1126.55
21
950.23
22
1038.19
23
1136.67
24
1031.55
25
1074.28
26
976.9
27
1046.3
28
986.54
29
1014.83
30
920.73
31
1083.41
32
873.59
33
902.92
34
1049.17
35
998.58
36
1010.89
37
1028.71
38
1049.92
39
1080.95
40
1026.41
41
958.95
42
985.17
43
988.49
44
1012.99
45
1070.82
46
1063.13
47
948.57
48
1156.42
49
973.79
50
845.85
Answer & Explanation
Solved by verified expert
4.2 Ratings (683 Votes)
The Calculations for the mean and standard deviation are givenafter the TestRight Tailed ttest Single MeanGiven 1000 hours 99787 hours s 51149 hours n 50 005TheHypothesisThe Null Hypothesis H0 1000 The mean lifetime of a bulb is equal to 1000 burninghoursThe Alternative Hypothesis Ha 1000 The mean lifetime of a bulb is greater than 1000burning hoursThis is a Right tailed testThe TestStatistic Since the population standard deviationis unknown we use the students t testThe test statistic is given by the equationt observed 003The ExcelCalculationsSingle Mean t Right Tailx199787100051149n50df n 149ax1213bsqrtn7071067812cssqrtn723356095ztac00294tround003The P ValueApproachThe pValue The p value Right tailed for t
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: Zin AI - Your personal assistant for all your inquiries!
