We have a dataset containing wine quality information. Each row records information about one distinct wine sample. For each wine sample, we observe its quality (last column), and its7characteristics, including fixed acidity, volatile acidity, citric acid, residual sugar, chlorides, free sulfur dioxide, and total sulfur dioxide.

A screenshot of the first five rows of the dataset is as follows.

Suppose we would like to fit asimple linear regression model(hereafter,SLRmodel)to predict the "quality" of the wine sample based on characteristic "fixed acidity." UsingData -> Data Analysis -> Regression in Excel,

1) which variable(s) should we put in as "Input Y Range?" [ Select ] ["fixed acidity, volatile acidity, citric acid, residual sugar, chlorides, free sulfur dioxide, and total sulfur dioxide", "quality", "fixed acidity", "Depends on the model"]

Excel produces the following regression output.

Additionally, wefit amultiple linear regression model(hereafter,MLRmodel)to predictthe "quality" of the wine sample based on all7characteristics. Excel produces the following regression output.

2)What is the % of variation explained by theMLRmodel? [ Select ] ["8.2%", "28.7%", "39.5%", "62.8%"]

3) True or False: The MLR model fits the data better than the SLR model. [ Select ] ["True", "FALSE"]

4) The sum of squared errors of theSLRmodel is: [ Select ] ["12.94", "8.44", "1.76", "19.61"] .

5) True or False: MLR is better than the intercept-only model. [ Select ] ["TRUE", "FALSE"]

6) How many significant coefficients (including intercept) are there in the MLR model? [ Select ] ["5", "2", "3", "4"]

7) There is a new wine sample with the following characteristics:

fixed acidity	volatile acidity	citric acid	residual sugar	chlorides	free sulfur dioxide	total sulfur dioxide
5.6	0.615	0	1.6	0.089	16	59

What is this predicted quality based onMLR? [ Select ] ["-0.49", "5.38", "0.29", "4.60"]

Recall, the coefficients are

Intercept	fixed acidity	volatile acidity	citric acid	residual sugar	chlorides	free sulfur dioxide	total sulfur dioxide
5.09	0.18	-1.43	-0.14	0.03	-1.40	0.04	-0.02