Question: Apply the following steps on this wind quality dataset ( here Download here ) : step 1 : In excel regression, use quality as Y
Apply the following steps on this wind quality dataset here Download here:
step : In excel regression, use "quality" as Y variable, and use all other columns as X variables by selecting the whole block as the input x range, click on label, output the results starting from O and generating NO plots.
step : Copy the winequalityred sheet to create a duplicate worksheet,
step : In the duplicated sheet, from the excel output, identify variables with pvalue greater than which means the corresponding variables are not predictive. BtwE means Remove those variables by deleting those colums. Also delete the excel output portion.
Repeat Step until all variables remaining are significantly predictive, ie with pvalue less than This might or might not require more than two iterations.
a In your final model, what factors have positive influence on quality and what factors have negative influence on quality?
b use your final model to predict the quality of this wine with the profile below:
fixed acidity volatile acidity citric acid residual sugar chlorides free sulfur dioxide total sulfur dioxide density pH sulphates alcohol
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
