1. Late assignments receive a grade of 0. Failure to submit this assignment leads to an FND in the course.
2. You must use EXCEL in the questions where indicated for this assignment. Copy and paste the tables into EXCEL from the text below. You must hand in all EXCEL output where indicated. .
3. The assignment otherwise is hand written. Please label the Excel outputs with the question numbers.
4. Students may work together on the assignment, but each student MUST submit the assignment independently.
5. Keep a copy of this assignment to study from, solutions will be posted.
6. All hypothesis tests MUST use the five steps. Formulae are necessary in all cases unless otherwise noted. For this assignment ONLY you can follow these examples to keep the document smaller and save time!! The conclusions MUST be complete IN CONTEXT as always.

F-test:

1. Ho: regression is not significant, Ha: regression is significant

2. ?.05, one-tailed. F?,(k, n-k-1) = F0.05,(2,7) = 6.542

3. Reject Ho if F0 >F?

4. F = MSR/MSE = 43.3648

5. Since F0 > F? (43.3648> 6.542), reject Ho. The regression equation is significant; the relationship between apples and oranges is significant.

OR if using p-values

P-value approach

1. Ho: regression is not significant, Ha: regression is significant

2. ?.05, one-tailed

3. Reject Ho if p-value < ? = 0.05

4. p-value = 0.0001

5. Since p-value = 0.0001 < ? = 0.05, reject Ho. The regression equation is significant; the relationship between apples and oranges is significant.

1. (16 +3 for Excel work) A company is reviewing the performance of two different suppliers of toner ink as their intention is to compare them and possible switch to the alternate one. Using the following data for hours of toner use before empty and alpha = 0.05 in all cases answer the following.

 CURRENT SUPPLIER A ALTERNATE SUPPLIER B 486 489 490 489 491 491 491 492 494 492 494 492 496 492 498 493 498 493 498 494 502 495 504 496 505 497 506 497 507 497 508 498 510 499 514 502 515 503 527 505

a. (5) Determine if the standard deviation of the Alternate Supplier B is significantly less than 5. Use alpha = 0.05. (No EXCEL)

b. (3) Determine if the variation of the hours of toner use of Current Supplier A is greater than that of Alternate Supplier B. Use EXCEL, include printout of result and DO NOT USE p-values in test write up.

c. (3) Determine if there is any difference in the variation of the hours of toner use between the two suppliers. Use EXCEL, include printout of result and DO NOT USE p-values in test write up.

d. (3) Using the findings of part (c), test to determine if Current Supplier A has higher average hours of toner use than Alternate Supplier B. Use EXCEL, include printout of result and use p-values in test.

e. (2) What is your recommendation to the company with respect to the supplier to select? Explain.