Exercise 5.8 (Static) METHODS AND APPLICATIONS A Toyota dealer wished to predict the sales prices of used Toyota Corolla

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

Exercise 5.8 (Static) METHODS AND APPLICATIONS A Toyota dealer wished to predict the sales prices of used Toyota Corolla

Post by answerhappygod »

Exercise 5 8 Static Methods And Applications A Toyota Dealer Wished To Predict The Sales Prices Of Used Toyota Corolla 1
Exercise 5 8 Static Methods And Applications A Toyota Dealer Wished To Predict The Sales Prices Of Used Toyota Corolla 1 (126.33 KiB) Viewed 12 times
Exercise 5.8 (Static) METHODS AND APPLICATIONS A Toyota dealer wished to predict the sales prices of used Toyota Corollas and gathered 1,436 observations concerning sales prices of used Corollas and the values of 36 predictor variables. Sixty percent of the observations (actually 862 observations) were randomly selected as the training data set, and the remaining 40 percent of the observations (574 observations) were used as the validation data set. A portion of the data, as well as part of a JMP regression tree analysis of the data, are shown in Figures 5.24 and 5.25. The default minimum split size of 5 was used. a. Using the information given in Figures 5.24 and 5.25, find the prediction of the sales price of used Toyota Corolla 1437, which has just been obtained by the Toyota dealer and has not yet been sold. Prediction of the sales price b-1. Redo the regression trees analysis and part a using a specified minimum split size of 20. Find the prediction of the sales price of used Toyota Corolla 1437, which has just been obtained by the Toyota dealer and has not yet been sold. Prediction of the sales price The prediction using a minimum split size of 20 is the default minimum split size of 5.
Model Price Age_08_04 Mfg Month Mfg_Year KM Fuel Type HP Met Color 13500 10 2002 46986 Diesel 90 1 1 TOYOTA Corolla 2.0 D4D HATCHB TERRA 2/3-Doors 2 TOYOTA Corolla 2.0 D4D HATCHB TERRA 2/3-Doors 13750 10 2002 72937 2002 41711 3 TOYOTA Corolla 2.0 D4D HATCHB TERRA 2/3-Doors 8 TOYOTA Corolla 2.0 D4D 90 3DR TERRA 2/3-Doors 9 TOYOTA Corolla 1800 T SPORT VVTI 2/3-Doors 10 TOYOTA Corolla 1.9 D HATCHB TERRA 2/3-Doors 1437 TOYOTA Corolla 2.0 D4D 90 3DR TERRA 2/3-Doors 16900 13950 18600 21500 2002 75889 2002 19700 2002 71138 2002 94612 12950 1 Blue 2 Silver 3 Blue 8 Grey 9 Red 10 Blue 1437 Grey 1 3 8 9 10 1437 1 2 3 8 9 10 1437 1 1 1 1 1437 1 1 1 Power Steering Color Automatic CC Doors Cylinders Gears Quarterly_Tax Weight Mfg Guarantee BOVAG Guarantee Guarantee_Perlod 0 2000 210 1165 0 2000 210 1165 0 2000 210 1165 0 2000 3 0 1800 3 0 1900 3 0 2000 3 Analysis of These Data 1 1 ABS Airbag 1 Airbag 2 Airco 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 3 3 3 1 0 0 1 1 0 1 1 RSquare Training 0.933 938.52912 862 Validation 0.853 1387.5365 574 0 0 0 0 4 0 4 4 4 4 0 0 4 0 1 0 1 1 1 1 5 5 5 5 5 5 0 0 0 0 0 0 1 RMSE N Number of Splits 23 23 24 30 27 23 27 0 0 0 0 0 0 0 210 1245 100 1185 185 1105 210 1245 Validation Price Residual Price Predicted Leaf Number 43 AICC 47 14349.9 1 1 1 1 9 3 1 1 1 0 0 1 1 6 10 6 Automatic_alrco Boardcomputer CD Player Central Lock Powered Windows 0 1 1 1 0 0 1 1 0 1 0 1 1 1 Radio Mistlamps Sport Model Backseat_Divider Metallic Rim Radio_cassette Tow_Bar Validation 0 Validation O Validation 0 0 1 1 0 0 0 0 0 0 0 Diesel 90 Diesel 90 Diesel 90 Petrol 192 Diesel 69 Diesel 90 0 0 1 0 0 Leaf Label 0 0 1 1 1 0 1 1 1 1 0 1 0 0 1 1 1 0 0 1 3 3 3 3 3 0 0 3 3 1 0 0 1 1 0 1 Training Training 0 Training 0 Validation 0 Training Age_08_04<33&Weight=1125&Metallic Rim<1&Mfg Year<2003&Doors<5
FIGURE 5.25 The First 10 Leafs and the Last 10 Leafs of the 48-Leaf Corolla Price Regression Tree Leaf Report Leaf Label Age_08_04>=33&Age_08_04>=57&Age_08_04>=69&KM>=145996&ABS<1 Age_08_04>=33&Age_08_04>=57&Age_08_04>=69&KM>=145996&ABS>=1&Fuel Type(Petrol) Age_08_04>=33&Age_08_04>=57&Age_08_04>=69&KM>=145996&ABS>=1&Fuel Type(Diesel) Age_08_04>=33&Age_08_04>=57&Age_08_04>=69&KM<145996&Quarterly_Tax<85&Mfg_Guarantee<1 Age_08_04>=33&Age_08_04>=57&Age_08_04>=69&KM<145996&Quarterly_T _Tax<85&Mfg_Guarantee>=1&Doors<5 Age_08_04>=33&Age_08_04>=57&Age_08_04>=69&KM<145996&Quarterly_Tax<85&Mfg_Guarantee>=1&Doors>=5 Age_08_04>=33&Age_08_04>=57&Age_08_04>=69&KM<145996&Quarterly_Tax=85&Tow_Bar>=1 Age_08_04>=33&Age_08_04>=57&Age_08_04>=69&KM<145996&Quarterly_Tax=85&Tow_Bar<&BOVAG_Guarantee<1 Age_08_04>=33&Age_08_04>=57&Age_08_04>=69&KM<145996&Quarterly_Tax>=85&Tow_Bar<1&BOVAG_Guarantee>= 1 Age_08_04>=33&Age_08_04>=57&Age_08_04<69&KM>=135337&HP<110 ⠀ Age_08_04<33&Weight<1125&Age_08_04>=19&Central_Lock< 1 Age_08_04<33&Weight<1125&Age_08_04>=19&Central Lock=1&Weight<1115 Age_08_04<33&Weight<1125&Age_08_04>=19&Central Lock=1&Weight>=1115 Age_08_04<33&Weight<1125&Age_08_04<19 Age_08_04<33&Weight>=1125&Metallic_Rim<1&Mfg_Year<2003&Doors<5 Age_08_04<33&Weight>=1125&Metallic_Rim<1&Mfg_Year<2003&Doors>=5 Age_08_04<33&Weight>=1125&Metallic_Rim<1&Mfg_Year>=2003&Quarterly_Tax<234 Age_08_04<33&Weight>=1125&Metallic_Rim<1&Mfg_Year>=2003&Quarterly_Tax>=234 Age_08_04<33&Weight>=1125&Metallic_Rim>=1&Mfg_Month>=4 Age_08_04<33&Weight>=1125&Metallic_Rim>=1&Mfg_Month<4 Mean 5811.25 6200 7050 7687.84884 7993.71429 8840 8112.47368 7607 8720.51282 7166.77778 : 14390.8333 15989.5833 17504.375 18286.4 16270 17934.5385 19468.75 21810 21228.125 22982.2222
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply