The database Wine Quality.xlsx** contains data on the chemical properties of nearly 5,000 wines. It also has
Question:
The database Wine Quality.xlsx** contains data on the chemical properties of nearly 5,000 wines. It also has a quality score for each wine that is based on the opinions of experts. The goal is to create a Multiple Linear Regression model which predicts the quality score.
In each of the following exercises, the goal is to develop a classification or prediction model for the given situation and data. Follow these steps:
1. Examine the data descriptions and explore the data.
2. Clean the data as needed.
3. Transform the data as needed (e.g., create dummy variables for categorical variables).
4. Partition the data.
5. Run the specified algorithm.
6. Interpret the results and choose the best model (e.g., choose the best k in the k-Nearest Neighbor method).
Step by Step Answer:
Management Science The Art Of Modeling With Spreadsheets
ISBN: 1301
4th Edition
Authors: Stephen G. Powell, Kenneth R. Baker