Reference no: EM132353988
Business Statistics Assignment -
Instructions: Answer each question in two different ways - first by calculating the value of the test statistic (for 1 and 3) or the lower and upper confidence levels (LCL and UCL, for 2), and second by using Excel. The solution to each question should include the following: the appropriate calculations (showing all work), the Excel printout, and the blanks filled in. Submit your solutions as an email with all files as attachments.
1. A diet doctor claims that the average North American is more than 20 pounds overweight. To test his claim, a random sample of 20 North Americans was weighed, and the difference between their actual and ideal weights was calculated. The data is listed below:
16 23 18 41 22 18 23 19 22 15 18 35 16 15 17 19 23 15 16 26
The sample statistics are: x- = 20.85, s = 6.76.
Can we infer, at the 5% significance level, that the doctor's claim is true? Assume the required conditions are satisfied.
H0:
H1:
Conclusion: Reject H0 Accept H0
Reason for conclusion:
2. The weights of a random sample of jam jars that are supposed to weigh 100 grams are listed below: The data are listed below:
105.2 103.5 98.6 100.3 99.1 97.8 101.2 96.0
The sample statistics are: x- = 100.213, s = 3.025.
Estimate the variance of the entire population of jam jar weights with 95% confidence. Assume the required conditions are satisfied.
LCL = ___________________ UCL = ___________________
3. In 2014 an airline had 92% of all flights on time. After taking a random sample of 278 flights from 2015-present it was found that 259 were on time. Can we infer, at the 5% significance level, that their on-time performance has improved since 2014? Assume that the required conditions are satisfied.
H0:
H1:
Conclusion: Reject H0 Accept H0
Reason for conclusion:
Note - Only need the excel part completed, excel work to be completed for all three questions.