| 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 | ||