(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
  1. Using the statistical package of your choice, run a linear regression and write the equation of the least squares line.
  2. Interpret the estimated slope.
  3. Find SSE, s 2 , and s.
  4. Obtain a point estimate of the mean amount of processing time required on all days in which 150 invoices are to be processed.
  5. Test the overall significance of the model at the 0.05 level.

f) Calculate a 95 percent confidence interval for 1 . Interpret this interval.

  1. 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.
  2. Find a 95 percent prediction interval for the processing time required on an individual day in which 150 invoices are to be processed.
  3. Find the total variation, the unexplained variation, and the explained variation.
  4. Find and interpret r 2 , the simple coefficient of determination.
  5. 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

log in to your account

Don't have a membership account?
REGISTER

reset password

Back to
log in

sign up

Back to
log in