Images | Horsepower |
---|---|
![]() |
275 |
![]() |
300 |
![]() |
350 |
![]() |
365 |
![]() |
400 |
![]() |
525 |
![]() |
650 |
![]() |
760 |
![]() |
1050 |
![]() |
1775 |
Use the horsepower data to perform the following calculations:
Bins (x) | Frequency (f) | P(x) |
---|---|---|
_______ | _______ | _______ |
_______ | _______ | _______ |
_______ | _______ | _______ |
_______ | _______ | _______ | Sum: | _______________ | _______________ |
Confidence interval statistics | |||
---|---|---|---|
Degrees of freedom | df | = n-1 | =COUNT(data)-1 |
Find a zc value from a confidence level c | zc | =ABS(NORMSINV((1-c)/2)) | |
Find a tc value from a confidence level c | tc | =TINV(1-c,df) | |
Calculate an error tolerance E of a mean for any n using sx. | E | ![]() |
=tc*sx/SQRT(n) |
Calculate a confidence interval for a population mean µ from a sample mean x and an error tolerance E | x-E≤ µ ≤x+E |