Multiple Regression & Variety of Characteristics Worksheet

Price ($1000)TypeMileageVolume (litres)CylindersCruise ControlSedanCoupeConvertibleCompact
70.76Convertible5834.6810010
68.57Convertible64204.6810010
69.13Convertible78924.6810010
66.37Convertible120214.6810010
65.28Convertible156004.6810010
63.91Convertible182004.6810010
60.57Convertible231934.6810010
57.15Convertible292604.6810010
55.64Convertible318054.6810010
52.00Convertible426914.6810010
46.73Convertible36256810010
47.07Convertible52396810010
44.75Convertible121156810010
42.77Convertible145466810010
41.37Convertible200006810010
39.55Convertible238266810010
39.69Convertible251696810010
38.82Convertible259606810010
36.97Convertible305026810010
37.29Convertible320396810010
35.62Convertible103402410010
34.82Convertible122512410010
34.36Convertible177112410010
32.74Convertible191122410010
33.54Convertible209252410010
31.97Convertible212082410010
33.29Convertible216612410010
32.08Convertible235532410010
31.97Convertible245592410010
27.67Convertible351572410010
37.09Convertible38282410010
33.38Convertible173812410010
33.36Convertible175902410010
33.59Convertible189302410010
30.73Convertible224792410010
30.32Convertible236352410010
30.17Convertible250492410010
30.25Convertible275582410010
29.14Convertible316552410010
29.61Convertible324772410010
38.32Convertible120902410010
38.17Convertible131622410010
37.38Convertible160882410010
36.34Convertible181952410010
35.58Convertible211672410010
35.30Convertible212932410010
34.39Convertible240312410010
33.98Convertible254202410010
33.25Convertible270512410010
28.78Convertible489912410010
13.01Coupe73722.2410100
13.04Coupe136072.2400100
12.05Coupe191362.2400100
12.47Coupe197122.2400100
11.54Coupe224052.2400100
11.73Coupe231032.2400100
12.21Coupe235122.2410100
11.20Coupe273642.2410100
10.79Coupe314362.2410100
11.15Coupe344472.2410100
14.58Coupe11602.2410100
13.68Coupe102102.2410100
13.45Coupe177412.2400100
12.33Coupe193472.2400100
12.27Coupe196122.2410100
12.63Coupe225712.2410100
12.43Coupe227712.2400100
12.32Coupe245682.2410100
12.55Coupe258162.2400100
12.23Coupe302972.2410100
15.05Coupe46522.2410100
14.40Coupe51892.2400100
14.64Coupe62242.2400100
13.46Coupe142312.2410100
13.68Coupe179712.2410100
12.51Coupe197152.2410100
13.14Coupe198982.2410100
13.59Coupe206822.2410100
12.73Coupe213862.2410100
12.23Coupe284082.2400100
14.02Coupe137762.2400100
12.81Coupe194612.2410100
13.14Coupe217962.2410100
13.11Coupe219102.2400100
12.85Coupe223822.2410100
12.57Coupe224792.2400100
12.90Coupe232002.2410100
11.96Coupe273942.2410100
12.71Coupe275212.2410100
12.49Coupe284922.2400100
15.64Coupe11692.2400100
15.75Coupe60482.2400100
14.62Coupe157682.2410100
14.19Coupe203742.2400100
13.70Coupe258452.2410100
13.31Coupe261432.2410100
13.53Coupe272492.2410100
13.02Coupe279422.2410100
12.68Coupe298912.2410100
12.55Coupe328442.2410100
39.88Coupe70546810100
39.71Coupe89676810100
38.99Coupe94106810100
39.09Coupe107176810100
39.37Coupe116196810100
35.26Coupe213506810100
35.58Coupe227406810100
34.30Coupe242596810100
34.74Coupe257476810100
31.19Coupe341916810100
18.80Coupe58273.8610100
18.91Coupe83453.8610100
19.18Coupe104143.8610100
18.04Coupe116473.8610100
17.69Coupe158983.8610100
17.52Coupe186023.8610100
16.36Coupe234913.8610100
16.35Coupe259313.8610100
15.80Coupe267003.8610100
15.50Coupe333453.8610100
21.75Coupe70653.8610100
21.73Coupe134573.8610100
22.38Coupe147883.8610100
20.54Coupe169503.8610100
21.23Coupe173373.8610100
20.68Coupe180213.8610100
20.84Coupe221523.8610100
20.02Coupe227293.8610100
18.88Coupe272183.8610100
17.59Coupe390493.8610100
23.57Coupe124663.8610100
23.53Coupe149483.8610100
22.11Coupe219923.8610100
22.47Coupe226263.8610100
20.62Coupe240673.8610100
20.05Coupe246653.8610100
21.53Coupe250203.8610100
20.38Coupe252403.8610100
21.02Coupe255503.8610100
20.22Coupe262233.8610100
17.36Coupe8813.4600100
17.68Coupe51313.4600100
17.14Coupe67613.4610100
17.20Coupe93803.4600100
16.79Coupe120713.4610100
15.60Coupe183153.4600100
15.25Coupe209173.4610100
15.59Coupe224143.4600100
15.06Coupe226413.4610100
14.70Coupe233353.4600100
32.42Coupe91855.7810100
32.22Coupe109155.7810100
31.02Coupe136785.7810100
29.60Coupe161935.7810100
29.66Coupe214185.7810100
27.43Coupe238865.7810100
27.37Coupe249605.7810100
27.55Coupe261265.7810100
28.50Coupe271995.7810100
25.53Coupe364805.7810100
13.16Coupe131452.2400100
12.83Coupe178302.2410100
12.83Coupe190812.2410100
12.88Coupe192252.2410100
12.83Coupe206182.2410100
12.46Coupe218912.2410100
12.47Coupe239312.2400100
12.26Coupe243182.2410100
11.90Coupe252852.2400100
12.21Coupe260972.2400100
16.92Coupe28792.2410100
15.64Coupe85072.2410100
16.26Coupe105552.2400100
15.40Coupe129202.2410100
14.88Coupe143762.2400100
15.28Coupe169512.2400100
14.70Coupe176562.2410100
15.03Coupe194552.2400100
13.99Coupe210202.2400100
14.77Coupe222552.2410100
13.72Coupe236452.2400100
13.87Coupe243492.2410100
13.52Coupe259812.2410100
13.83Coupe260342.2400100
13.81Coupe262362.2400100
14.08Coupe267882.2400100
14.41Coupe269862.2410100
13.60Coupe272312.2400100
13.03Coupe301082.2410100
11.54Coupe389582.2400100
12.15Compact100111.6400001
12.16Compact121011.6400001
11.47Compact196991.6400001
11.02Compact201001.6400001
11.10Compact203341.6410001
10.39Compact222251.6400001
11.14Compact224841.6400001
11.05Compact245681.6410001
10.78Compact279061.6400001
9.93Compact296801.6400001
11.03Compact201561.6400001
11.34Compact201861.6410001
11.39Compact214211.6400001
11.25Compact214271.6410001
10.92Compact231191.6400001
11.18Compact231211.6400001
11.39Compact251071.6400001
11.07Compact254761.6400001
11.01Compact257461.6410001
11.12Compact300561.6410001
10.81Compact2661.6410001
11.17Compact47161.6410001
10.90Compact66991.6400001
10.11Compact142001.6410001
10.35Compact145211.6400001
10.29Compact165211.6410001
9.72Compact208361.6410001
9.51Compact221691.6400001
9.79Compact229861.6400001
9.22Compact299921.6410001
18.96Compact59363.5600001
18.95Compact86873.5600001
17.89Compact170203.5600001
17.80Compact193863.5610001
16.72Compact197403.5610001
16.74Compact218293.5600001
16.83Compact234603.5600001
16.54Compact245833.5600001
16.14Compact265323.5610001
14.91Compact339063.5600001
19.47Compact66083.5610001
18.01Compact151903.5600001
18.27Compact163353.5600001
18.31Compact174413.5600001
17.55Compact184513.5600001
18.00Compact187713.5600001
17.66Compact194903.5610001
17.12Compact244613.5600001
16.99Compact249053.5610001
16.80Compact258743.5610001
18.97Compact56323.5600001
18.32Compact73973.5610001
19.58Compact76453.5600001
18.17Compact147543.5600001
17.99Compact174883.5600001
17.17Compact187213.5600001
16.46Compact202003.5600001
16.27Compact214523.5600001
16.86Compact228413.5610001
16.03Compact228893.5600001
17.31Sedan82213.1611000
17.54Sedan91353.1611000
16.22Sedan131963.1611000
16.34Sedan163423.1611000
16.34Sedan198323.1611000
15.71Sedan222363.1611000
15.23Sedan225763.1611000
15.05Sedan229643.1611000
14.86Sedan240213.1611000
15.30Sedan273253.1611000
21.34Sedan102373.6611000
20.54Sedan150663.6611000
20.51Sedan166333.6611000
19.92Sedan198003.6611000
19.77Sedan233593.6611000
19.34Sedan237653.6611000
19.11Sedan240083.6611000
18.54Sedan260343.6611000
17.81Sedan328963.6611000
17.97Sedan346653.6611000
22.36Sedan89703.6611000
23.79Sedan105773.6611000
22.93Sedan143633.6611000
21.90Sedan165083.6611000
21.27Sedan189083.6611000
21.46Sedan194673.6611000
21.18Sedan213943.6611000
20.41Sedan225963.6611000
21.06Sedan244693.6611000
19.56Sedan252453.6611000
23.45Sedan157553.8611000
23.55Sedan162353.8611000
23.02Sedan181473.8611000
22.23Sedan221023.8611000
22.63Sedan236123.8611000
21.80Sedan244393.8611000
21.34Sedan252123.8611000
21.68Sedan267793.8611000
20.99Sedan270963.8611000
20.90Sedan296493.8611000
20.70Sedan29923.8611000
20.10Sedan100363.8611000
18.15Sedan183393.8611000
17.94Sedan195923.8611000
19.03Sedan217973.8611000
18.35Sedan238523.8611000
17.75Sedan250403.8611000
17.77Sedan250523.8611000
17.39Sedan254643.8611000
17.65Sedan278303.8611000
21.91Sedan173533.8611000
21.96Sedan177873.8611000
21.65Sedan195623.8611000
21.58Sedan201373.8611000
20.95Sedan201583.8611000
21.56Sedan237673.8611000
19.98Sedan243233.8611000
19.43Sedan278393.8611000
19.19Sedan291873.8611000
19.64Sedan313243.8611000
25.59Sedan23083.8611000
25.10Sedan100143.8611000
23.42Sedan189103.8611000
22.66Sedan201053.8611000
23.49Sedan204533.8611000
22.44Sedan222873.8611000
21.88Sedan232373.8611000
23.08Sedan237983.8611000
21.70Sedan254893.8611000
21.83Sedan255643.8611000
26.83Sedan46953.8611000
26.06Sedan97953.8611000
26.78Sedan120523.8611000
26.30Sedan130503.8611000
26.19Sedan173353.8611000
25.51Sedan174803.8611000
23.35Sedan240273.8611000
23.41Sedan253873.8611000
23.16Sedan258693.8611000
21.54Sedan371283.8611000
51.15Sedan22025.7811000
49.25Sedan66855.7811000
46.75Sedan153435.7811000
44.13Sedan213415.7811000
44.08Sedan213675.7811000
43.89Sedan233715.7811000
44.30Sedan237515.7811000
42.68Sedan240525.7811000
43.37Sedan251995.7811000
40.62Sedan300825.7811000
33.42Sedan65982.8611000
30.96Sedan106252.8611000
31.43Sedan110132.8611000
30.78Sedan149372.8611000
30.65Sedan170942.8611000
30.79Sedan178702.8611000
30.39Sedan184492.8611000
28.82Sedan210392.8611000
29.28Sedan210562.8611000
28.04Sedan274842.8611000
39.80Sedan140954.6811000
40.34Sedan147434.6811000
39.31Sedan160414.6811000
38.60Sedan171384.6811000
38.45Sedan186614.6811000
36.08Sedan219664.6811000
35.87Sedan244154.6811000
35.34Sedan251634.6811000
36.15Sedan253394.6811000
34.69Sedan254214.6811000
42.82Sedan54994.6811000
41.38Sedan81254.6811000
40.86Sedan127914.6811000
41.42Sedan144524.6811000
37.51Sedan215934.6811000
37.22Sedan222114.6811000
36.33Sedan251534.6811000
36.25Sedan262504.6811000
32.95Sedan360744.6811000
32.54Sedan418294.6811000
35.72Sedan64474.6811000
35.65Sedan105554.6811000
35.13Sedan119754.6811000
35.17Sedan134494.6811000
32.50Sedan175084.6811000
33.22Sedan186614.6811000
32.51Sedan209104.6811000
31.13Sedan231244.6811000
31.18Sedan262224.6811000
31.06Sedan275444.6811000
42.74Sedan28463.6611000
40.97Sedan74763.6611000
38.80Sedan139733.6611000
38.30Sedan167543.6611000
37.19Sedan191003.6611000
36.21Sedan217783.6611000
36.63Sedan220423.6611000
35.90Sedan230563.6611000
34.97Sedan257963.6611000
32.04Sedan353263.6611000
48.31Sedan7884.6811000
48.37Sedan26164.6811000
45.06Sedan138294.6811000
44.21Sedan151044.6811000
42.38Sedan185814.6811000
41.67Sedan205754.6811000
41.52Sedan238614.6811000
41.05Sedan257174.6811000
38.21Sedan313034.6811000
39.07Sedan315874.6811000
12.65Sedan36291.6401000
12.31Sedan41421.6401000
11.32Sedan111561.6401000
12.41Sedan119811.6411000
11.56Sedan134041.6411000
11.70Sedan152531.6411000
11.22Sedan199451.6401000
10.14Sedan239631.6411000
10.49Sedan309481.6401000
9.95Sedan373451.6401000
11.92Sedan72781.6401000
12.41Sedan102131.6401000
11.30Sedan146271.6401000
11.62Sedan190141.6401000
10.81Sedan210131.6411000
11.17Sedan223801.6401000
10.77Sedan250651.6401000
10.87Sedan258691.6401000
10.92Sedan277761.6411000
9.92Sedan346211.6401000
10.97Sedan70911.6411000
10.32Sedan144381.6401000
9.65Sedan191831.6401000
9.56Sedan192731.6411000
9.67Sedan195651.6401000
9.48Sedan248421.6411000
8.64Sedan252161.6401000
9.04Sedan261911.6401000
8.87Sedan329141.6411000
8.77Sedan352991.6401000
14.89Sedan24642.2401000
14.20Sedan113222.2411000
14.68Sedan114882.2411000
13.17Sedan146302.2401000
13.47Sedan189102.2411000
12.57Sedan250482.2411000
12.38Sedan250692.2411000
13.23Sedan258622.2401000
11.08Sedan368552.2401000
11.33Sedan399462.2411000
14.22Sedan84272.2401000
14.27Sedan86152.2401000
14.26Sedan169582.2401000
13.76Sedan180402.2411000
14.28Sedan185332.2411000
13.69Sedan187662.2411000
13.31Sedan200432.2401000
14.15Sedan205122.2411000
12.94Sedan216842.2401000
12.85Sedan275602.2411000
14.06Sedan49222.2401000
13.07Sedan143112.2401000
11.70Sedan198162.2411000
12.26Sedan214922.2411000
11.57Sedan215252.2401000
11.54Sedan241632.2401000
12.24Sedan250142.2411000
11.67Sedan257272.2411000
11.46Sedan294102.2411000
10.55Sedan388662.2411000
15.55Sedan76952.2401000
15.05Sedan123052.2411000
13.54Sedan173432.2401000
14.08Sedan174452.2401000
12.98Sedan203092.2411000
13.44Sedan205302.2401000
13.16Sedan211452.2411000
14.22Sedan230692.2411000
12.38Sedan311992.2411000
11.58Sedan365662.2401000
15.00Sedan88802.2401000
14.85Sedan129802.2401000
15.13Sedan138282.2411000
15.00Sedan145042.2401000
14.59Sedan187902.2401000
14.30Sedan211282.2401000
13.69Sedan216112.2411000
13.74Sedan237482.2401000
13.55Sedan274312.2401000
12.74Sedan348152.2401000
16.12Sedan8652.2411000
16.43Sedan98822.2401000
15.08Sedan148242.2411000
15.16Sedan171582.2411000
14.90Sedan182102.2411000
14.51Sedan189102.2401000
14.42Sedan198182.2401000
14.19Sedan211812.2411000
14.40Sedan215272.2401000
14.18Sedan216272.2401000
14.43Sedan61142.2411000
14.70Sedan67092.2411000
14.58Sedan71152.2411000
14.19Sedan95612.2401000
14.07Sedan152332.2401000
13.99Sedan172702.2401000
13.83Sedan175942.2401000
13.16Sedan227402.2411000
12.50Sedan262042.2401000
12.68Sedan286832.2401000
21.76Sedan18533.8611000
19.53Sedan141153.8611000
19.08Sedan181983.8611000
19.41Sedan187953.8611000
18.53Sedan198743.8611000
18.91Sedan215123.8611000
17.84Sedan254533.8611000
17.79Sedan269803.8611000
17.29Sedan293683.8611000
18.08Sedan294203.8611000
20.02Sedan17873.8611000
18.84Sedan82113.8611000
18.73Sedan140543.8611000
16.81Sedan194983.8611000
17.15Sedan215673.8611000
16.64Sedan223833.8611000
15.95Sedan260703.8611000
16.51Sedan274603.8611000
15.83Sedan312023.8611000
15.55Sedan333573.8611000
25.95Sedan6363.8611000
27.71Sedan53793.8611000
25.10Sedan144613.8611000
24.81Sedan161113.8611000
23.35Sedan229643.8611000
22.89Sedan262723.8611000
22.06Sedan273843.8611000
23.15Sedan279403.8611000
22.12Sedan282423.8611000
20.29Sedan338923.8611000
19.16Sedan14803.5611000
18.80Sedan79613.5601000
17.46Sedan151443.5611000
17.16Sedan214173.5601000
16.47Sedan216753.5611000
16.99Sedan236213.5601000
16.30Sedan256973.5611000
15.62Sedan274763.5601000
15.14Sedan324623.5601000
15.23Sedan325353.5601000
19.45Sedan9323.5601000
17.12Sedan182773.5611000
17.32Sedan195933.5611000
16.86Sedan198833.5611000
17.31Sedan214203.5611000
16.40Sedan231333.5611000
16.54Sedan242183.5611000
16.34Sedan253943.5601000
16.71Sedan263283.5611000
16.30Sedan282393.5601000
17.09Sedan87323.5601000
17.46Sedan113933.5611000
17.22Sedan145793.5611000
17.16Sedan159033.5601000
16.51Sedan174513.5601000
16.75Sedan185623.5611000
16.65Sedan201543.5601000
15.62Sedan212723.5611000
15.66Sedan257873.5611000
15.68Sedan259563.5601000
25.45Sedan118924.6811000
23.45Sedan172734.6811000
23.58Sedan191484.6811000
22.53Sedan195214.6811000
21.98Sedan204724.6811000
22.23Sedan219294.6811000
22.19Sedan256514.6811000
21.77Sedan257944.6811000
21.40Sedan271684.6811000
21.20Sedan311974.6811000
19.68Sedan115543.8611000
18.68Sedan164963.8611000
20.32Sedan175833.8611000
20.13Sedan184193.8611000
19.75Sedan205103.8611000
17.84Sedan211213.8611000
18.86Sedan224233.8611000
18.57Sedan247473.8611000
18.06Sedan275743.8611000
17.77Sedan283853.8611000
23.20Sedan22953.8611000
23.10Sedan56533.8611000
22.46Sedan89283.8611000
21.61Sedan110693.8611000
22.00Sedan155163.8611000
20.83Sedan194193.8611000
20.11Sedan228913.8611000
19.12Sedan262523.8611000
19.69Sedan270773.8611000
19.34Sedan279663.8611000
21.90Sedan45373.5611000
22.74Sedan56903.5611000
22.10Sedan90493.5611000
22.31Sedan112213.5611000
21.88Sedan123133.5611000
20.63Sedan207703.5611000
19.54Sedan226283.5611000
19.20Sedan264773.5611000
18.16Sedan283543.5611000
18.53Sedan300633.5611000
21.38Sedan72873.5611000
20.45Sedan103383.5611000
20.68Sedan112043.5611000
19.29Sedan195393.5611000
18.55Sedan208703.5611000
18.04Sedan217023.5611000
18.62Sedan255163.5611000
17.02Sedan304043.5611000
16.22Sedan356243.5611000
15.79Sedan415663.5611000
15.98Sedan39462.2411000
16.38Sedan41882.2411000
15.33Sedan43182.2401000
15.85Sedan53502.2401000
15.60Sedan57882.2411000
14.84Sedan124202.2401000
15.08Sedan132622.2401000
13.96Sedan196022.2401000
13.03Sedan239762.2401000
13.16Sedan245422.2401000
18.25Sedan165543.8611000
17.10Sedan187203.8611000
17.16Sedan208293.8611000
16.39Sedan213043.8611000
15.79Sedan252953.8611000
16.57Sedan257773.8611000
17.00Sedan258303.8611000
16.28Sedan265113.8611000
15.46Sedan299253.8611000
14.96Sedan314713.8611000
21.23Sedan112293.8611000
22.10Sedan123143.8611000
21.30Sedan127723.8611000
21.28Sedan174173.8611000
19.65Sedan211323.8611000
20.17Sedan212113.8611000
18.70Sedan249923.8611000
19.42Sedan255573.8611000
19.96Sedan260283.8611000
19.45Sedan277213.8611000
19.82Sedan15923.8611000
19.57Sedan21893.8611000
16.85Sedan179593.8611000
16.52Sedan207513.8611000
15.98Sedan219743.8611000
16.26Sedan226373.8611000
15.72Sedan239893.8611000
15.97Sedan255983.8611000
16.04Sedan278003.8611000
15.76Sedan293253.8611000
29.25Sedan39072411000
26.34Sedan160682411000
26.78Sedan166882411000
25.30Sedan195692411000
24.90Sedan212662411000
26.00Sedan214332411000
24.80Sedan263452411000
24.06Sedan276742411000
23.25Sedan276862411000
22.24Sedan503872411000
26.84Sedan100032411000
27.83Sedan100142411000
27.28Sedan142812411000
27.06Sedan173192411000
25.62Sedan202082411000
25.79Sedan211602411000
25.15Sedan222722411000
24.85Sedan228142411000
24.17Sedan270152411000
23.73Sedan276002411000
32.20Sedan38672411000
32.05Sedan51442411000
30.27Sedan108002411000
30.35Sedan112732411000
30.12Sedan145682411000
26.79Sedan221892411000
28.29Sedan223282411000
27.11Sedan225982411000
27.26Sedan264002411000
25.27Sedan341752411000
35.03Sedan16762.3411000
32.75Sedan79242.3411000
33.18Sedan97952.3411000
31.00Sedan150872.3411000
30.08Sedan220522.3411000
29.84Sedan231432.3411000
28.43Sedan252472.3411000
28.05Sedan262762.3411000
28.50Sedan285982.3411000
24.91Sedan387172.3411000
30.80Sedan80172.3411000
28.42Sedan146132.3411000
28.19Sedan198542.3411000
28.20Sedan220212.3411000
26.65Sedan225902.3411000
27.61Sedan228812.3411000
26.70Sedan230552.3411000
27.24Sedan232042.3411000
27.70Sedan247382.3411000
24.41Sedan313442.3411000
14.74Sedan17372.2401000
15.11Sedan23922.2411000
14.20Sedan118362.2401000
15.19Sedan124122.2401000
14.12Sedan128782.2411000
13.17Sedan133182.2401000
13.26Sedan149382.2411000
12.79Sedan161632.2401000
12.29Sedan171392.2411000
14.00Sedan182572.2401000
14.57Sedan185112.2401000
13.12Sedan191012.2401000
13.49Sedan195002.2411000
12.04Sedan198532.2401000
12.16Sedan217702.2401000
12.33Sedan218772.2401000
12.10Sedan227582.2411000
12.12Sedan228262.2401000
11.68Sedan233882.2401000
13.22Sedan240692.2401000
12.41Sedan246642.2401000
12.28Sedan247402.2411000
12.59Sedan263282.2401000
12.11Sedan282982.2401000
11.87Sedan283982.2401000
12.97Sedan297072.2401000
10.56Sedan324582.2401000
11.41Sedan326192.2411000
11.50Sedan339622.2401000
11.52Sedan349982.2401000
18.17Sedan58263611000
18.49Sedan77553611000
17.32Sedan101023611000
17.98Sedan109863611000
16.43Sedan142423611000
16.51Sedan162293611000
16.18Sedan190953611000
15.73Sedan204843611000
15.12Sedan259793611000
13.59Sedan356623611000
16.39SUV180961.8410000
16.03SUV183911.8400000
16.11SUV194651.8410000
16.55SUV195311.8410000
17.33SUV198941.8410000
16.08SUV227791.8400000
15.30SUV230621.8400000
15.51SUV242391.8410000
15.17SUV278871.8400000
14.55SUV333741.8400000
17.80SUV123031.8410000
16.35SUV160781.8400000
15.98SUV170531.8400000
15.57SUV182061.8400000
15.59SUV213071.8400000
15.73SUV213911.8400000
15.80SUV214611.8400000
15.09SUV274381.8400000
14.40SUV314241.8400000
14.87SUV317911.8410000
16.93SUV29731.8400000
17.42SUV44631.8410000
16.38SUV87541.8400000
16.71SUV91501.8400000
17.21SUV126101.8410000
15.82SUV143041.8400000
14.40SUV216881.8400000
15.62SUV232171.8410000
14.91SUV233231.8400000
14.85SUV242701.8400000
31.85SUV169562.3410000
32.65SUV169752.3410000
29.96SUV200152.3410000
31.55SUV201032.3410000
29.91SUV221052.3410000
30.58SUV222982.3410000
30.27SUV234262.3410000
28.68SUV253802.3410000
28.83SUV265032.3410000
26.96SUV317732.3410000
33.01SUV64092.3410000
30.66SUV142782.3410000
30.44SUV150502.3410000
30.32SUV162252.3410000
31.15SUV173172.3410000
31.08SUV181872.3410000
31.16SUV188052.3410000
29.11SUV219602.3410000
25.85SUV365572.3410000
24.90SUV407192.3410000
30.96SUV176732.3410000
29.99SUV184642.3410000
29.91SUV198302.3410000
28.33SUV206852.3410000
29.20SUV209072.3410000
29.32SUV215452.3410000
29.48SUV218222.3410000
26.79SUV253572.3410000
27.79SUV267862.3410000
26.01SUV342692.3410000
27.28SUV48362.5410000
25.96SUV174312.5410000
23.27SUV216162.5410000
23.33SUV252182.5410000

Multiple regression

Data for this exercise set can be found in the worksheet “Week 7 – Data.xlsx”.

Q1. A researcher wants to determine car prices based on a variety of characteristics such as mileage, model, engine size (number of cylinders and volume (or displacement, in litres)), cruise control etc. The data were collected from Kelly Blue Book for several hundred 2005 used General Motors (GM) cars. (Data are in the Excel file “Week 7 – Data.xlsx”, worksheet “Question 1”.)

  1. Using Minitab, determine the estimated regression equation that can be used to predict the price (in $1000s) given the Mileage, Volume, Cylinders, and CruiseControl. Cruise control is an indicator variable, which is 1 if the car has cruise control, and 0 if itdoes not.
  • Use Minitab to perform the F-test to determine the overall significance of the relationship. What is your conclusion at the 0.05 level of significance?
  • Use Minitab to perform t-tests to determine the significance of each predictor variable. What is your conclusion at the 0.05 level of significance?
  • Remove any predictor variables that are not significant from the estimated regression equation and fit the smaller model. What is your estimated regression equation now? Use R-squared and R-squared (adjusted) to compare this model to the model in part a.
  • The data file also contains indicator variables (“dummy variables”) to account for the vehicle type (Sedan, Coupe, Convertible, and Compact). Why is there no indicator variable for SUV? Add these four indicator variables to the model in part d. Use Minitab to develop the multiple linear regression equation. Make sure to select the option

“Sequential sums of squares” when fitting the model. Compare this model to the model in part d. based on R-squared and R-squared (adjusted).

  • Carefully interpret the coefficient of the predictor Sedan.
  • Do the indicator variables for car type (collectively) add value to the model? (Perform a partial F-test, using a 0.05 level of significance.)

Q2. (Continues Q1 in Week 3) In week 3 you saw a data set that studied the participation rate of 17–24-year-olds in institutions of post-secondary education (universities and colleges). Additionally, the region of the country (Maritimes, Quebec, Ontario, West) was recorded. At the time you developed a one-way analysis of variance to study regional differences.

  1. Using Minitab, develop indicator variables to account for the regions. You can do this very conveniently with the menu selection Calc > Make Indicator Variables.
  • Develop a multiple linear regression equation that can be used to predict the percentage of 17–24-year-olds who are attending college given the indicator variables you developed in part a. (Your model should only have three predictors; omit the indicator variable for the West.)
  • Is the overall model useful to predict participation rates? (Use   =0.05.)
  • Carefully interpret the least-squares coefficients returned by Excel, including the intercept.
  • Perform t-tests to determine the significance of each indicator variable. What is your conclusion at the 0.05 level of significance? Carefully interpret your findings.

Do you have a similar assignment and would want someone to complete it for you? Click on the ORDER NOW option to get instant services at EssayBell.com

Do you have a similar assignment and would want someone to complete it for you? Click on the ORDER NOW option to get instant services at EssayBell.com. We assure you of a well written and plagiarism free papers delivered within your specified deadline.