Exam.xlsx is a portion of the cerial.xls file. As you can see, there are some missing values in the table: Replace all the missing values with the mean of each variable. Explore the data using the data visualization capabilities of XLMiner. Which pairs among the variables seem to be correlated? Prepare the dataset (as factored into dummies) for data mining techniques by creating partition using XLMiner's data partitioning utility. Select all the variables and use default values for the random seed and partitioning percentages for training (65%) and validation (35%). Use XLMiner to plot a histogram for each of the quantitative variables. Which variables seem skewed? Conduct a principal components analysis and comment on the result. Should the data be normalized? Apply linear regression and write the equation for rating using the 4th best subset