|
|||||
|
|
|
|
|
|
To complete this assignment successfully, you should:
§ Hypothesis Testing §
Assignments
Send
to your instructor a single Excel file (including written answers) as e-mail an
attachment using WebMail addressed
to BA501@mail.cba.nau.edu and put "BA501
(last name) Assignment name and number" in the e-mail subject.
Put the different exercise outputs on separate sheets in the Excel file. If you
have any questions on this home work, please e-mail
me with questions. Here is the Excel
worksheet for this assignment. Use "save as" to save it to your computer
or to a floppy.
Exercise 1
Use Excel to solve this problem. Perform the hypothesis test for the mean of a normally distributed population, using the following information:
Data: 7.37, 7.36, 7.38, 7.35, 7.39, 7.34, 7.4, 7.33, 7.41, 7.32, 7.42, 7.31,7.43, 7.3, 7.44, 7.29, 7.45, 6.44, 8.3, 6.54, 8.2, 6.64, 8.1, 5.88, 8.86
Ho: m ³ 8.18
Ha: m < 8.18
a = 0.10
(cick
me)
Exercise 2
A university professor contends that students should study more than 30 hours a week to be make passing grades taking a 15 hour load. A random sample of 64 students who had 15 hour loads yielded a sample mean of 30.5 hours per week spent studying with a standard deviation of 2.1. Use Excel to solve these problems.
(a) Find the 95% confidence interval for the mean time a student spends per week studying. Give the three interpretations of the confidence interval.
(cick me)
(b) Is there sufficient evidence to indicate that the mean time that a student spends per week studying is greater than 30 hours? Use a 0.05 significance level.
Exercise 3
Marketing planning problems may require special computer programs that to help solve. For 36 different situations involving various marketing planning problems, the amount of time spent by a manager interacting with a particular special computer program is given below in units of hours. Use Excel to solve this problem.
1.3 1.5 1.9 1.7 0.8 1.2 1.4 0.7 0.9 1.3 1.2 1.6 0.8 0.7 1.1 1.4 0.8 1.1 1.4 1.2 1.2 1.8 1.3 1.2 0.5 0.2 1.7 0.8 1.8 0.8 1.1 0.8 0.9 1.4 0.9 1.2
(c) How does sample size indicate the use of the confidence interval with the normal distribution instead of the t distribution in part (a)?
(cick me)
Exercise 4
A college entrance examination is believed to take 5 hours to finish. A random sample of 64 students taking the exam finished in an average of 4.71 hours with a sample standard deviation of 0.705 hours. Use the p-value criteria to determine if there is sufficient evidence to support the hypothesis that the mean time to finish differs from 5 hours.
(cick me)