The dataset ToyotaCorrola.xls contains data used on used cars for sale during the late summer of 2004 in the Neverlands.

The dataset ToyotaCorrola.xls contains data used on used cars for sale during the late summer of 2004 in the Neverlands. It has 1436 records containing details on 38 attributes, including Price, Age, Kilometers, HP, and other specifications.

1. Explore the data using the data visualization of XLMiner. Which of the pairs among the variables seem to be correlated?

We plan to analyze the data using various data mining techniques described in future chapters. Prepare the data for use as follows.

1. The dataset has two categorial attributes, Fuel Type and Metallic. Describe how you would convert these to binary variables. Confirm this using XLMiner's utility to transform categorical data into dummies.
2. Prepare the dataset for data mining techniques of supervised learning by creating partitions using XLMiner's data partitioning utility. Select all the variables and use default values for the random seed and partitioning percentages for training (50%), validation (30%), and test (20%) sets. Describe the roles these partitions play in modeling.