Explore BrainMass
Share

Answers to Hypothesis Testing Questions in Excel

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

I am having trouble with some stats problems. Can you assist me?

Thanks in advance

The NPC, Inc. is a large mail order company that ships men's shirts all over the United States and Canada. They ship a large number of packages from their warehouse in Delta, Ohio. Their goal is to have 95 percent of the shipments delivered in 4 days. For many years they have used Brown Truck Inc., but recently there have been complaints about slow and inconsistent delivery. A sample of 10 recent shipments handled by Brown Truck showed a standard deviation in delivery time of 1.25 days. A sample of 16 shipments by Rapid Package Service showed a standard deviation in their delivery time of 0.45 days. At the 0.05 significance level is there more variation in the Brown Truck delivery time?

a. State the null and alternate hypotheses.

H0:
H1:

b. State the decision rule.

c. Compute the value of the test statistic.

d. What is your decision regarding the null hypothesis? Interpret the result.

12. Jim Ray, an avid golfer, keeps records on his scores for 18 holes of golf. When the temperature is above 65 degrees, the standard deviation of his scores is 5.75 for 25 rounds. When the temperature is below 65 degrees, the standard deviation of his scores is 7.35 for a sample of 21 rounds. At the 0.05 significance level, is there more variation in his scores when the temperature is below 65 degrees?

a. State the null and alternate hypotheses.

H0:
H1:

b. State the decision rule.

c. Compute the value of the test statistic.

d. What is your decision regarding the null hypothesis? Interpret the result.

Youngsville Northeast Corry
2.2 2.3 0.9
1.2 1.5 0.8
1.9 1.2 1.1
3.1 1.4 1.2
1.8 2.2 0.7
1.5

13. The County Executive for Monroe County is concerned about the response time for the three fire companies in the county. Samples of the response times (in minutes) for each company follow. At the 0.05 significance level is there a difference in the mean response time?

a. State the null and alternate hypotheses.
H0:
H1:

b. State the decision rule.
c. Compute the value of the test statistic (use the tables).
d. What is your decision regarding the null hypothesis? Interpret the result.

Brand Weeks of Wear
A 3 4 6 3 4
B 2 3 2 5 2
C 5 7 5 4 6

14. A dentist is trying to decide if there is a difference in the number of weeks three different toothbrushes last. Fifteen patients were randomly assigned to three brands of toothbrushes and the number of weeks that the toothbrushes lasted is given. At the 0.05 significance level, is there a difference in the mean length of time the toothbrushes lasted?

a. State the null and alternate hypotheses.
H0:
H1:
b. State the decision rule.
c. Compute the value of the test statistic.

Analysis of Variance
Source DF SS MS
Factor 2 16.93 8.47
Error 12 18.00 1.50
Total 14 34.93
d. What is your decision regarding the null hypothesis? Interpret the result.

© BrainMass Inc. brainmass.com October 24, 2018, 11:31 pm ad1c9bdddf
https://brainmass.com/statistics/hypothesis-testing/196413

Attachments

Solution Summary

This solution provides answers to various hypothesis testing questions.

$2.19
See Also This Related BrainMass Solution

Questions for Hypothesis Testing in Excel

Use a 10% significance level.

Every month a clothing store conducts an inventory and calculates the losses due to theft. The store would like to reduce these losses and is considering two methods. The first is to hire a security guard, and the second is to install cameras. To help decide which method to choose, they hired a security guard for six months. During the next 6 months period, the store installed cameras. The monthly losses were recorded and are listed here. The manager decided that since the cameras were cheaper than the guard, he would install the camera unless there was enough evidence to infer that the guard was better. What should the manger do?

Security guard 355 284 401 398 477 254
Cameras 486 303 270 386 411 435

View Full Posting Details