1. According to this week's lecture, in Regression, we test the following:

Ho: b-sub-1 = 0

Ha: b-sub-1 not equal to 0 (or > 0 or

WHY would it be useful to show that b-sub-1 is NOT equal to 0 (or > 0 or

2. In the Excel file "Misc Data" in the Weekly Content folder, in columns O and P is data on the amount of overhead needed to be spent for a company to yield a certain level of production. Calculate the correlation coefficient and the regression line. What can you conclude? How much production would be yielded from 60.00 of overhead?

A B C D E F G H J K L M N O P Body temperature Programmer errors Rainfall and Wheat Regression: Production Level related to overhead 18-20 21-29 130+ A B C D Rainfal Yield of Wheat Month Overhead Production (Bushels per ($1,000s) Level (1,000's of 98.00 99.60 98.60 14.00 3.00 17.00 16.00 12.90 62.50 1.00 41.40 16.90 98.40 98.20 98.60 16.00 5.00 20.00 18.00 7.20 28.70 2.00 35.00 15.60 97.70 99.00 97.00 18.00 12.00 22.00 20.00 11.30 52.20 3.00 38.30 17.40 98.50 98.20 97.50 14.00 8.00 24.00 17.00 18.60 80.60 4.00 29.50 11.60 97.10 97.90 97.30 22.00 7.00 26.00 21.00 8.80 41.60 5.00 39.60 17.70 9.00 6.00 18.00 10.30 44.50 6.00 37.40 17.60 6.00 9.00 15.90 71.30 7.00 37.50 16.30 4.00 11.00 13.10 54.40 8.00 37.00 15.50 7.00 9.00 47.90 23.40 16.00 10.00 55.60 28.40 11.00 53.10 27.10 12.00 40.60 19.20