252cp403 12/03/03 (Open this document in 'Page Layout' view!)
Last Computer Problem
This problem is problem 14.37 in the 9th edition of the textbook. The data are on the next two pages. As far as I can see, the problem is identical to Problem 15.10 in the 8th edition, but you should use the 9th edition data which can be downloaded from the website at http://courses.wcupa.edu/rbove/eco252/Colleges2002.MTP or the disk for the 9th edition. To download from the website enter Minitab, use the file pull-down menu, pick ‘open worksheet’ and copy the URL into ‘File name.’ If you can save the worksheet on the computer on which you are working.
Read through the document 252soln K1 and use the analysis there to help you with this problem. In particular Exercise 14.35 is almost identical to this problem and my description is very similar. Once you get the data loaded, you need a column for the interaction variable and two columns for the input to the prediction interval.
252cp403 12/03/03
Contents of C1
1
Row School
1 UniversityofArizona
2 BallStateUniversity
3 Cal.StateUniv.-Fresno
4 ClemsonUniversity
5 James Madison University
6 University of SouthFlorida
7 FloridaStateUniversity
8 GeorgeMasonUniversity
9 GeorgiaInstitute ofTechnology
10 MontclairStateUniversity
11 NorthCarolinaStateUniv.
12 UniversityofOregon
13 PurdueUniversity
14 SanDiegoStateUniversity
15 SlipperyRockUniv.ofPenn.
16 SUNY-Binghamton
17 TexasA&MUniversity
18 Univ.ofGeorgia
19 Univ.ofHawaii-Manoa
20 Univ.ofHouston
21 Univ.ofMaryland
22 Univ.ofMass.-Amherst
23 Univ.ofNevada-LasVegas
24 Univ.ofNewHampshire
25 Univ.ofNorthCarolina-C.H.
26 Univ.ofTexas-Austin
27 Univ.ofVermont
28 VirginiaCommonwealthUniv.
29 VirginiaTech
30 WestVirginiaUniversity
31 AmherstCollege
32 BabsonCollege
33 BostonCollege
34 BostonUniversity
35 BowdoinCollege
36 BryantCollege
37 BucknellUniversity
38 CanisiusCollege
39 CarnegieMellonUniversity
40 CaseWesternReserveUniv.
41 ClarkUniversity
42 DrewUniversity
43 GrinnellCollege
44 ColgateUniversity
45 CollegeofHolyCross
46 EmoryUniversity
47 FordhamUniversity
48 Franklin&MarshallCollege
49 GeorgeWashingtonUniversity
50 GeorgetownUniversity
51 GettysburgCollege
52 HarvardUniversity
53 IonaCollege
54 LafayetteCollege
55 LehighUniversity
56 HofstraUniversity
57 NewYorkUniversity
58 NiagaraUniversity
59 NorthwesternUniversity
60 ProvidenceCollege
61 RiceUniversity
62 Pace University
63 SeattleUniversity
64 SetonHallUniversity
65 SienaCollege
66 SouthernMethodistUniversity
67 St.BonaventureUniversity
68 StanfordUniversity
69 SyracuseUniversity
70 TulaneUniversity
71 Univ.ofChicago
72 Univ.ofMiami
73 Univ.ofNotreDame
74 Univ.ofPennsylvania
75 Univ.ofPortland
76 Univ.ofScranton
77 VanderbiltUniversity
78 VillanovaUniversity
79 WakeForestUniversity
80 Yale University
1
Row C2 C3 C4 C5 C6 C7
Type First Third Room Annual Average
of quartile quartile and Total Indebted-
School SAT SAT Board Cost ness
1 0 990 1230 6124 10356 17772
2 0 935 1152 5646 12480 15700
3 0 800 1070 6302 9476 14004
4 0 1090 1280 4454 12932 13970
5 0 1080 1250 5568 11472 12474
6 0 940 1150 5600 10410 16715
7 0 1060 1270 6450 10316 14737
8 0 970 1170 5560 13716 14110
9 0 1250 1420 5800 13986 16958
10 0 900 1110 7568 8525 15464
11 0 1070 1280 5796 15111 15999
12 0 1000 1230 6252 14890 19916
13 0 1020 1250 6340 16260 15486
14 0 920 1140 8307 7210 13000
15 0 850 1060 4298 11650 21100
16 0 1120 1310 6102 9451 13957
17 0 1070 1290 6030 11288 14418
18 0 1110 1300 5504 12792 13550
252cp403 12/03/03
Row C2 C3 C4 C5 C6 C7
Type First Third Room Annual Average
of quartile quartile and Total Indebted-
School SAT SAT Board Cost ness
19 0 980 1180 5359 9829 13164
20 0 920 1150 5538 9888 12988
21 0 1150 1350 7101 14434 14076
22 0 1010 1230 5115 14655 15526
23 0 880 1130 6140 9831 12000
24 0 1010 1210 5882 17830 19515
25 0 1150 1370 6216 15140 11156
26 0 1090 1330 5975 10790 17200
27 0 1040 1230 6378 21484 22425
28 0 920 1150 5750 14888 21994
29 0 1080 1290 5374 13552 17014
30 0 930 1125 5572 9710 18273
31 1 1320 1510 7380 28310 12270
32 1 1170 1330 9676 26000 23000
33 1 1220 1390 9574 25862 17517
34 1 1210 1370 8978 27414 17808
35 1 1280 1440 7305 28685 14682
36 1 1000 1180 7776 19776 20479
37 1 1200 1370 6052 27531 15000
38 1 980 1190 7540 18840 19782
39 1 1280 1470 7534 27116 18280
40 1 1240 1440 6750 22680 21902
41 1 1060 1270 4950 25865 17650
42 1 1100 1320 7288 26346 13064
43 1 1250 1440 6330 25865 17650
44 1 1240 1400 6775 23530 13324
45 1 1140 1320 8000 28355 12822
46 1 1300 1460 8498 26440 16063
47 1 1070 1260 9177 26932 18350
48 1 1170 1370 6580 23463 17152
49 1 1150 1330 9110 27280 17774
50 1 1290 1450 9672 27820 24894
51 1 1150 1310 6640 27120 14800
52 1 1380 1570 8502 27448 13360
53 1 900 1100 9698 17886 17096
54 1 1160 1330 8069 26142 15393
55 1 1200 1370 7530 26180 18469
56 1 1010 1190 7530 15722 14624
57 1 1230 1420 10430 26646 20079
58 1 940 1130 7300 16550 17606
59 1 1300 1480 8446 27228 13253
60 1 1090 1260 8120 20840 19625
61 1 1320 1520 7480 17526 12525
62 1 960 1150 7590 18208 19402
63 1 1040 1250 6627 18855 22695
64 1 960 1160 8302 20830 19406
65 1 1020 1200 7030 16945 15500
66 1 1060 1270 7954 21942 19792
67 1 950 1150 6200 16845 16843
68 1 1360 1550 8680 27204 17185
69 1 1110 1300 9510 23424 18925
70 1 1240 1410 7392 28310 19873
71 1 1300 1490 8728 27825 12787
72 1 1090 1290 8060 24810 12246
73 1 1260 1450 6510 25852 22270
74 1 1310 1490 8244 27988 21556
75 1 1040 1250 6250 20620 18595
76 1 1000 1210 8772 20448 14900
77 1 1230 1400 9060 27087 21015
78 1 1150 1320 8330 23751 20874
79 1 1230 1380 7190 24750 20339
80 1 1360 1540 8240 27130 18786
1