• Enter the data in Excel and find the regression coefficients by running the regression function in Excel (
• b. Compute and verify the completion time of individual filling out the From ST 1040AVG for the fifth time
• c. Find the 95% Prediction interval

The State Department of Taxation wishes to investigate the effect of experience, x, on the amount of time, y, required to fill out Form ST 1040AVG, the state income-averaging form. In order to do this, nine people whose financial status makes income averaging advantageous are chosen at random. Each is asked to fill out Form ST 1040AVG and to report (1) the time y (in hours) required to complete the form and (2) the number of times x (including this one) that he or she has filled out this form. The following data are obtained: 4.7 3.7 2.8 8.9 Completion time, y (in Hours) 8.0 Experience, 1 5.8 2 8 4 4 16 1 2.0 12 1.9 5 3 3.3 3