Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. A heating contractor sends a repair person to homes in response to calls about heating problems. The contractor would like to have a way

1. A heating contractor sends a repair person to homes in response to calls about heating problems. The contractor would like to have a way to estimate how long the 32 customer will have to wait before the repair person can begin work. Data on the number of minutes of waiting time (Wait Time) and the backlog of previous calls waiting for service (Backlog) were obtained. The data table is listed. Answer the questions below. You may use MINITAB (or, possibly another program) for answering these questions.

(a) Find the linear regression equation resulting from regression of WaitTime on Backlog. Give an interpretation for the slope and the intercept.

(b) Calculate the predicted value and the 95% prediction interval for the time to respond to a call when the backlog is 6.

(c) Consider a regression for a model with the base-10 logarithm of Wait Time as a response and Backlog as a predictor. Run a linear regression in Minitab for this model. Does this model appear better than the one without taking the logarithm of the Wait Time?

(d) Calculate the predicted value for the log of the Wait Time when the backlog is 6.

(e) Convert your answer to question (d) to a predicted value for the Wait Time when the backlog is 6.

Wait Tim Backlog
220 4
230 1
60 1
280 2
210 2
40 0
470 3
540 4
40 0
60 3
80 2
90 3
50 3
30 0
70 3
20 1
140 1
30 0
70 1
100 3
10 2
40 3
10 1
140 3
120 4
30 2
370 2
90 2
450 3
10 0
100 4
130 1
50 2
40 1
10 1
70 2
360 4
40 2
30 0
180 1
20 2
210 2
40 0
40 0
40 1
60 1
30 0
10 0
30 1
40 1
80 3
60 1
30 3
10 2
280 3
130 2
30 3
70 3
130 1
250 3
100 3
260 4

2. The data below contains driving accuracy (y) and driving distance (x) of various golf players. We use the driving distance here as a predictor, and driving accuracy as a response. Use MINITAB (or another software, if you wish) to answer the questions below.

(a) Find a 95% prediction interval for the driving accuracy if the driving distance is x = 300 yards.

(b) Find a 95% confidence interval for the average value of the driving accuracy if the driving distance is x = 300 yards.

(c) Compare the intervals in parts (a) and (b). Which interval is wider? Is this always the case?

PLAYER DISTANCE ACCURACY INDEX
Woods 316.1 54.6 3.58
Perry 304.7 63.4 3.48
Gutschewski 310.5 57.9 3.27
Wetterich 311.7 56.6 3.18
Hearn 295.2 68.5 2.82
Gronberg 301.4 63.2 2.74
Frazar 301 63.5 2.74
Warren 299.2 64.2 2.55
Glover 302.2 60.7 2.27
MacKenzie 300.2 62.1 2.22
Love III 305.4 57.9 2.21
Garcia 303.5 59.4 2.21
Durant 289.2 70.9 2.2
O'Hair 300.1 61.4 2.02
Singh 301.1 60.2 1.92
Long 298.3 62.4 1.9
Smith 300.8 60.2 1.85
Hend 318.9 45.4 1.89
Hughes 291.3 67.5 1.76
Stadler 300.1 60.4 1.76
Allenby 297.7 62.3 1.75
Mayfair 288.2 69.8 1.71
Appleby 300.6 59.3 1.58
Snyder III 291.8 66.3 1.56
Purdy 295.2 63.4 1.52
Brigman 295.5 63.1 1.5
Bryant 283.2 73 1.49
Rollins 294.4 63.7 1.43
Jobe 302.3 57.3 1.42
Brehaut 286.6 69.9 1.4
Ogilvy 298 60.7 1.4
Henry 297.6 61 1.4
Rose 294.1 63.7 1.37
Westwood 296.8 61.5 1.36
Johnson 290 66.9 1.34
Senden 291 66 1.31
Mickelson 300 58.7 1.3
Watney 298.9 59.4 1.26
Trahan 295.8 61.8 1.23
Pappas 309.4 50.6 1.17

3. The file below has the following columns that are relevant to this exercise: SalesPerSF: Sales per square foot of stores operated by a retail chain, 33 Income: the median household income in the surrounding community (dollars), Population000: and the size of the community (in thousands). Market: This is a qualitative variable. There are 3 types of geographic locations: urban, suburban, and rural. Two dummy variables have been set up, UrbanDummy and SuburbanDummy. Rural is selected as the base level. Disregard the other columns in the file.

(a) Run a regression using SalesPerSF as the dependent variable, and Income, Population000, and the two dummy variables as predictors. Which of the coefficients are significantly different from zero?

(b) Predict the sales per square foot for a store located in a suburban community with median household income $71,000, and population size equal to 500,000 people. Write a 95% prediction interval and a 95% confidence interval. Explain the difference between the two intervals.

(c) Interpret all four coefficients in the estimated regression equation.

SalesPerSF Income Population000 Market UrbanDummy SuburbanDummy UrbanTimesIncome SuburbanTimesIncome
544.3 89000 503 Urban 1 0 89000 0
481.2 78000 463 Urban 1 0 78000 0
527.5 71000 597 Urban 1 0 71000 0
550.5 64000 452 Urban 1 0 64000 0
561.1 69000 684 Urban 1 0 69000 0
491.1 59000 610 Urban 1 0 59000 0
691.7 76000 699 Urban 1 0 76000 0
483.5 59000 663 Urban 1 0 59000 0
572.6 64000 760 Urban 1 0 64000 0
582 76000 569 Urban 1 0 76000 0
403.3 61000 685 Urban 1 0 61000 0
612.8 73000 872 Urban 1 0 73000 0
489.1 68000 712 Urban 1 0 68000 0
481 84000 514 Urban 1 0 84000 0
441.5 78000 326 Urban 1 0 78000 0
573.8 76000 769 Urban 1 0 76000 0
467.9 78000 421 Urban 1 0 78000 0
607.6 72000 499 Urban 1 0 72000 0
508.9 67000 672 Urban 1 0 67000 0
587.4 71000 1077 Urban 1 0 71000 0
393.4 65000 710 Urban 1 0 65000 0
564.2 52000 592 Urban 1 0 52000 0
588.3 72000 829 Urban 1 0 72000 0
569.4 73000 650 Urban 1 0 73000 0
641.9 88000 755 Urban 1 0 88000 0
646.4 78000 531 Urban 1 0 78000 0
490.1 67000 559 Urban 1 0 67000 0
616.5 69000 726 Urban 1 0 69000 0
467.1 61000 581 Urban 1 0 61000 0
630.2 79000 531 Urban 1 0 79000 0
532.9 75000 470 Urban 1 0 75000 0
353.2 52000 551 Urban 1 0 52000 0
580.2 71000 482 Urban 1 0 71000 0
379.3 86000 849 Suburban 0 1 0 86000
495.8 84000 796 Suburban 0 1 0 84000
468.4 86000 713 Suburban 0 1 0 86000
362.9 80000 578 Suburban 0 1 0 80000
355.8 73000 798 Suburban 0 1 0 73000
455.9 74000 786 Suburban 0 1 0 74000
382 84000 740 Suburban 0 1 0 84000
476.2 87000 850 Suburban 0 1 0 87000
376.8 85000 828 Suburban 0 1 0 85000
341.4 77000 729 Suburban 0 1 0 77000
428 70000 926 Suburban 0 1 0 70000
465.5 90000 641 Suburban 0 1 0 90000
475.7 80000 953 Suburban 0 1 0 80000
442 74000 862 Suburban 0 1 0 74000
469.3 86000 1224 Suburban 0 1 0 86000
555.2 73000 992 Suburban 0 1 0 73000
401.7 71000 626 Suburban 0 1 0 71000
488.8 93000 947 Suburban 0 1 0 93000
512 71000 1075 Suburban 0 1 0 71000
437.9 95000 884 Suburban 0 1 0 95000
417.5 76000 1034 Suburban 0 1 0 76000
352.7 75000 827 Suburban 0 1 0 75000
416.7 73000 985 Suburban 0 1 0 73000
283.5 64000 635 Suburban 0 1 0 64000
454 92000 424 Suburban 0 1 0 92000
466.6 78000 923 Suburban 0 1 0 78000
461.1 79000 793 Suburban 0 1 0 79000
376 63000 612 Rural 0 0 0 0
162.8 50000 560 Rural 0 0 0 0
458.3 64000 452 Rural 0 0 0 0
325.7 58000 611 Rural 0 0 0 0
313.1 62000 433 Rural 0 0 0 0
305.1 54000 705 Rural 0 0 0 0
276.6 65000 658 Rural 0 0 0 0
310.5 65000 438 Rural 0 0 0 0
272.7 59000 434 Rural 0 0 0 0
425.6 70000 552 Rural 0 0 0 0
468.4 72000 656 Rural 0 0 0 0
209.4 62000 410 Rural 0 0 0 0
126.9 55000 321 Rural 0 0 0 0
325.9 74000 270 Rural 0 0 0 0
442.9 66000 738 Rural 0 0 0 0
458.2 69000 548 Rural 0 0 0 0
409.9 60000 774 Rural 0 0 0 0
349.2 56000 646 Rural 0 0 0 0
471.4 67000 831 Rural 0 0 0 0
476.4 56000 947 Rural 0 0 0 0
407.5 63000 945 Rural 0 0 0 0
375.1 66000 323 Rural 0 0 0 0
319.8 66000 260 Rural 0 0 0 0
287.2 56000 401 Rural 0 0 0 0
518.1 63000 628 Rural 0 0 0 0
213.8 63000 222 Rural 0 0 0 0
290.9 65000 395 Rural 0 0 0 0

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Transportation A Global Supply Chain Perspective

Authors: John J. Coyle, Robert A. Novak, Brian Gibson, Edward J. Bard

8th edition

9781305445352, 1133592961, 130544535X, 978-1133592969

More Books

Students also viewed these Mathematics questions