(Solution Library) The manager of the purchasing department of a large banking organization would like to develop a model to predict the amount of time it would
Question: The manager of the purchasing department of a large banking organization would like to develop a model to predict the amount of time it would take to process invoices. Data were collected from a sample of 30 days with the following results:
| Day |
Number
of invoices processed |
Amount
of Time (hours) |
Day |
Number
of invoices processed |
Amount
of Time (hours) |
| 1 | 149 | 2.1 | 16 | 169 | 2.5 |
| 2 | 60 | 1.8 | 17 | 190 | 2.9 |
| 3 | 188 | 2.3 | 18 | 233 | 3.4 |
| 4 | 19 | 0.3 | 19 | 289 | 4.1 |
| 5 | 201 | 2.7 | 20 | 45 | 1.2 |
| 6 | 58 | 1.0 | 21 | 193 | 2.5 |
| 7 | 77 | 1.7 | 22 | 70 | 1.8 |
| 8 | 222 | 3.1 | 23 | 241 | 3.8 |
| 9 | 181 | 2.8 | 24 | 103 | 1.5 |
| 10 | 30 | 1.0 | 25 | 163 | 2.8 |
| 11 | 110 | 1.5 | 26 | 120 | 2.5 |
| 12 | 83 | 1.2 | 27 | 201 | 3.3 |
| 13 | 60 | 0.8 | 28 | 135 | 2.0 |
| 14 | 25 | 0.4 | 29 | 80 | 1.7 |
| 15 | 173 | 2.0 | 30 | 29 | 0.5 |
- Using the statistical package of your choice, run a linear regression and write the equation of the least squares line.
- Interpret the estimated slope.
- Find SSE, s 2 , and s.
- Obtain a point estimate of the mean amount of processing time required on all days in which 150 invoices are to be processed.
- Test the overall significance of the model at the 0.05 level.
f) Calculate a 95 percent confidence interval for 1 . Interpret this interval.
- Find a 95 percent confidence interval for the mean amount of processing time required on all days in which 150 invoices are to be processed.
- Find a 95 percent prediction interval for the processing time required on an individual day in which 150 invoices are to be processed.
- Find the total variation, the unexplained variation, and the explained variation.
- Find and interpret r 2 , the simple coefficient of determination.
- Find r, the simple correlation coefficient, and discuss why its sign is positive or negative.
Price: $2.99
Solution: The downloadable solution consists of 4 pages
Deliverable: Word Document 