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

Hello, I need support to answer 2 questions below. Submissions can be made on a Microsoft Word, Excel, or a pdf file.

Requirements: Complete the 2 questions. There is no length requirement.

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

Explore the data using the data visualization capabilities 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:

The dataset has two categorical 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.

Prepare the dataset (as factored into dummies) 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 that these partitions will play in modeling.