bus mangment project
Kanderi94
ms1023_fall_2015_excelproject_3_1.xlsxQ1
| Men | Women |
| $107.48 | $125.98 |
| $143.61 | $45.53 |
| $90.19 | $56.35 |
| $125.53 | $80.62 |
| $70.79 | $46.37 |
| $83.00 | $44.34 |
| $129.63 | $75.21 |
| $154.22 | $68.48 |
| $93.80 | $85.84 |
| $110.42 | $126.11 |
Some studies have shown that in the United States, men spend more than women buying gifts and cards on Valentine’s Day. Suppose a researcher wants to test this hypothesis by randomly sampling 10 men and 10 women with comparable demographic characteristics from various large cities across the United States to be in a study. Each study participant is asked to keep a log beginning one month before Valentine’s Day and record all purchases made for Valentine’s Day during that one-month period. The resulting data are shown below. Use these data and a 1% level of significance to test to determine if, on average, men actually do spend significantly more than women on Valentine’s Day. Assume that such spending is normally distributed in the population and that the population variances are equal. Solve this question using Excel. State the null & alternative hypotheses clearly. Interpret the Excel output and state your conclusion clearly. Provide all your results and comments on this sheet. Specifically, type in your answers in the spaces provided below: Are the samples related (i.e. dependent) or independent? Null Hypothesis: Alternative Hypothesis: Interpretation of Excel output: Full conclusion:
Q2
| WORKER | WEDNESDAY OUTPUT | FRIDAY OUTPUT |
| 1 | 71 | 53 |
| 2 | 56 | 47 |
| 3 | 75 | 52 |
| 4 | 68 | 55 |
| 5 | 74 | 58 |
In manufacturing, does worker productivity drop on Friday? In an effort to determine whether it does, a company’s personnel analyst randomly selects from a manufacturing plant five workers who make the same part. He measures their output on Wednesday and again on Friday and obtains the following results. The analyst uses alpha = 0.05 and assumes the difference in productivity is normally distributed. Do the samples provide enough evidence to show that productivity drops on Friday? Solve this question using Excel. State the null & alternative hypotheses clearly. Interpret the Excel output and state your conclusion clearly. Provide all your results and comments on this sheet. Specifically, type in your answers in the spaces provided below: Are the samples related (i.e. dependent) or independent? Null Hypothesis: Alternative Hypothesis: Interpretation of Excel output: Full conclusion:
