Answered step by step
Verified Expert Solution
Question
1 Approved Answer
11018.04 10121.56 10658.53 11688.59 11465.91 10325.32 11729.78 11868.26 12027.26 10699.26 10388.49 11101.46 10981.06 11750.64 10759.1 11828.09 10099.31 13082.95 11626.65 10093.53 10528.95 11204.07 11076.81 12658.6 10367.67
11018.04 10121.56 10658.53 11688.59 11465.91 10325.32 11729.78 11868.26 12027.26 10699.26 10388.49 11101.46 10981.06 11750.64 10759.1 11828.09 10099.31 13082.95 11626.65 10093.53 10528.95 11204.07 11076.81 12658.6 10367.67 12242.37 10717.98 10810.8 10219.22 9851.298 11716.24 8186.599 9825.343 9663.827 8247.096 9146.513 10425.09 9614.723 10673.59 11619.61 12171.41 10863.2 13367.7 9959.588 11183.46
Use Sheet 8 of the Excel file to answer the following questions. A power company is installing utility poles that are supposed to have a height of 40 feet. The foreman checks a random sample of ED poles to determine ifthe mean height is 40 feet at a significance level of 0.05. Create a histogram, and calculate E, the fstatistic, and the p-value. From the histogram, can normality be assumed? PiCk V E = EX: 1 .234 t = p = Since the pualue is Pick V than the signicanoe level 0.05, the null hypothesis Pick V - Pick 9 evidence exists that the mean height differs from 40 feet
11018.04 |
10121.56 |
10658.53 |
11688.59 |
11465.91 |
10325.32 |
11729.78 |
11868.26 |
12027.26 |
10699.26 |
10388.49 |
11101.46 |
10981.06 |
11750.64 |
10759.1 |
11828.09 |
10099.31 |
13082.95 |
11626.65 |
10093.53 |
10528.95 |
11204.07 |
11076.81 |
12658.6 |
10367.67 |
12242.37 |
10717.98 |
10810.8 |
10219.22 |
9851.298 |
11716.24 |
8186.599 |
9825.343 |
9663.827 |
8247.096 |
9146.513 |
10425.09 |
9614.723 |
10673.59 |
11619.61 |
12171.41 |
10863.2 |
13367.7 |
9959.588 |
11183.46 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started