Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribedimage text in transcribed

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. greater than less than FIGURE 5.24 The JMP Output of a Portion of the Used Toyota Corolla Sales Price Data and of Part of a Regression Tree Analysis of These Data Model Price Age_08_04 Mfg_Month Mfg_Year KM Fuel_Type HP Met_Color 1 TOYOTA Corolla 2.0 D4D HATCHB TERRA 2/3-Doors 13500 3 23 10 2002 46986 Diesel 90 1 2 TOYOTA Corolla 20 D4D HATCHB TERRA 2/3-Doors 13750 2 23 10 2002 72937 Diesel 90 1 3 TOYOTA Corolla 2.0 D4D HATCHB TERRA 2/3-Doors 13950 / 24 9 2002 41711 Dlesel 90 1 8 TOYOTA Corolla 2.0 D4D 90 3DR TERRA 2/3-Doors 18600 30 3 2002 75889 Diesel 90 1 9 TOYOTA Corolla 1800 T SPORT WTI 2/3-Doors 21500 27 6 2002 19700 Petrol 192 0 10 TOYOTA Corolla 1.9 D HATCHB TERRA 2/3-Doors 12950 23 10 2002 71138 Diesel 69 0 0 1437 TOYOTA Corolla 2.0 D4D 90 3DR TERRA 2/3-Doors 16900 27 6 2002 94612 Diesel 90 1 0 5 3 4 5 1 1 Color Automatic CC Doors Cylinders Gears Quarterly_Tax Weight Mfg_Guarantee BOVAG_Guarantee Guarantee_Period 1 Blue O 2000 3 4 5 210 1165 0 1 3 2 Silver 0 2000 3 4 5 210 1165 o 1 3 Blue 0 O 2000 3 210 1165 3 8 Grey 0 2000 3 5 210 3 9 Red 0 1800 5 100 1185 0 1900 3 4 185 1105 1437 Grey 0 2000 3 4 210 1245 4 1245 1 1 3 4 0 1 3 10 Blue 5 0 3 3 5 0 3 1 ABS Airbag_1 Alrbag_2 Alrco Automatic_alrco Boardcomputer CD_Player Central_Lock Powered_Windows 1 1 0 0 1 1 1 1 1 1 1 0 1 0 1 1 2 1 1 0 1 0 3 1 1 0 0 1 0 0 O 1 1 1 1 1 O 1 1 1 1 1 1 1 1 O 0 1 1 9 10 1437 0 1 O o 1 1 1 1 1 o 0 0 0 1 1 1 1 0 1 1 1 1 0 0 1 0 0 2 1 0 0 0 1 0 0 3 1 0 o 0 1 0 0 Power_Steering Radio Mistlamps Sport_Model Backseat_Divider Metallic_Rim Radio_cassette Tow_Bar Validation 1 0 0 O Validation 1 0 o O Validation 0 Training 1 0 0 0 1 o 0 Training 1 0 Training 0 Validation o Training 1 1 0 0 0 1 0 8 9 9 10 1437 1 0 0 0 0 1 0 0 o RSquare RMSE N Number of Splits 0.933 938.52912 862 47 0.853 1387.5365 574 AICC 14349.9 Training Valldation Validation Price Residual Price Predicted Leaf Number 1437 43 Leaf Label Age_08_04=33&Age_08_04>=57&Age_08_04>=69&KM>=145996&ABS=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=33&Age_08_04>=57&Age_08_04>=69&KM=1&Doors=33&Age_08_04>=57&Age_08_04>=69&KM=1&Doors>=5 Age_08_04>=33&Age_08_04>=57&Age_08_04>=69&KM=1 Age_08_04>=33&Age_08_04>=57&Age_08_04>=69&KM=33&Age_08_04>=57&Age_08_04>=69&KM=85&Tow_Bar=1 Age_08_04>=33&Age_08_04>=57&Age_08_04=135337&HP=19&Central_Lock=19&Central_Locko=1&Weight=19&Central_Locko=1&Welght>=1115 Age_08_04=1125&Metallic_Rim=1125&Metallic_Rim=5 Age_08_04=1125&Metallic_Rim=2003&Quarterly_Tax=1125&Metallic_Rim=2003&Quarterly_Taxo=234 Age_08_04=1125&Metallic_Rim>=1&Mfg_Month>=4 Age_08_04=1125&Metallic_Rim>=1&Mfg_Month=33&Age_08_04>=57&Age_08_04>=69&KM>=145996&ABS=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=33&Age_08_04>=57&Age_08_04>=69&KM=1&Doors=33&Age_08_04>=57&Age_08_04>=69&KM=1&Doors>=5 Age_08_04>=33&Age_08_04>=57&Age_08_04>=69&KM=1 Age_08_04>=33&Age_08_04>=57&Age_08_04>=69&KM=33&Age_08_04>=57&Age_08_04>=69&KM=85&Tow_Bar=1 Age_08_04>=33&Age_08_04>=57&Age_08_04=135337&HP=19&Central_Lock=19&Central_Locko=1&Weight=19&Central_Locko=1&Welght>=1115 Age_08_04=1125&Metallic_Rim=1125&Metallic_Rim=5 Age_08_04=1125&Metallic_Rim=2003&Quarterly_Tax=1125&Metallic_Rim=2003&Quarterly_Taxo=234 Age_08_04=1125&Metallic_Rim>=1&Mfg_Month>=4 Age_08_04=1125&Metallic_Rim>=1&Mfg_Month

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

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

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Students also viewed these Accounting questions