Finish Part A, B, C, E, and F on the left and show your work

A B D E F G H K . N O P Invoices 103 173 149 193 Time 1.5 2.0 2.1 2.5 2.5 0.5 2.3 0.3 1 1 13.2 2 Part A 3 Value of bo 4 Value of bi 5 Part B 6 Mean Time 7 Part 8 r-square 9 Part E Value of turbin Watson 10 Statistic, D 11 Is the data autocorrelated? 12 Part F 13 Conclusions? ? 169 29 You want to develop a model to predict the amount of time it takes to process invoices. Data are collected from the past 32 working days, and the number of invoices processed and completion time (in hours) are stored are given on the left. (be sure to first determine which are the independent and dependent variables.) Assuming a linear relationship, use the least-squares method to compute the equation of the line, which includes the regression coefficients bo and b1 B. Use the prediction line developed in (a) to predict the mean amount of time it would take to process 150 invoices. C. Determine the coefficient of determination, r squared and interpret its meaning. . D. Plot the residuals against the number of invoices processed and also against time. E. Looking at the chart of invoices vs residuals there appears to be some autocorrelation. Test to see if this is true. F. Based on your results in part e what what conclusions can you reach about the validity of the prediction? 188 19 201 58 110 83 2.7 1.0 1.5 1.2 0.8 0.4 60 25 60 190 233 289 45 70 241 163 120 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 1.8 2.9 3.4 4.1 1.2 1.8 3.8 2.8 2.5 3.3 2.0 1.7 1.7 3.1 2.8 1.0 1.9 2.6 201 135 80 77 222 181 30 61 120 A B D E F G H K . N O P Invoices 103 173 149 193 Time 1.5 2.0 2.1 2.5 2.5 0.5 2.3 0.3 1 1 13.2 2 Part A 3 Value of bo 4 Value of bi 5 Part B 6 Mean Time 7 Part 8 r-square 9 Part E Value of turbin Watson 10 Statistic, D 11 Is the data autocorrelated? 12 Part F 13 Conclusions? ? 169 29 You want to develop a model to predict the amount of time it takes to process invoices. Data are collected from the past 32 working days, and the number of invoices processed and completion time (in hours) are stored are given on the left. (be sure to first determine which are the independent and dependent variables.) Assuming a linear relationship, use the least-squares method to compute the equation of the line, which includes the regression coefficients bo and b1 B. Use the prediction line developed in (a) to predict the mean amount of time it would take to process 150 invoices. C. Determine the coefficient of determination, r squared and interpret its meaning. . D. Plot the residuals against the number of invoices processed and also against time. E. Looking at the chart of invoices vs residuals there appears to be some autocorrelation. Test to see if this is true. F. Based on your results in part e what what conclusions can you reach about the validity of the prediction? 188 19 201 58 110 83 2.7 1.0 1.5 1.2 0.8 0.4 60 25 60 190 233 289 45 70 241 163 120 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 1.8 2.9 3.4 4.1 1.2 1.8 3.8 2.8 2.5 3.3 2.0 1.7 1.7 3.1 2.8 1.0 1.9 2.6 201 135 80 77 222 181 30 61 120