Project Data fixed acidity volatile acidity citric acid residual sugar chlorides free sulfur dioxide total sulfur dioxide density ph sulphates alcohol quality 34 0.9978 3.51 9.4 11 0.56 0.7 1.9 0.076 67 0.9968 3.2 0.68 g.8 25 7.8 0.88 2.6 0.098 0.997 3.26 0.65 9.8 5 15 54 7.8 0.76 0.04 23 0.092 60 0.998 3.16 0.58 9.8 6 11.2 0.28 0.56 1.9 0.075 17 0.56 9.4 5 11 34 0.9978 3.51 7.4 0.7 0 1.9 0.076 13 40 0.9978 3.51 0.56 9.4 7.4 0.66 O 1.8 0.075 15 59 0.9964 3.3 0.46 9.4 7.9 0.6 0.06 1.6 0.069 21 0.9946 3.39 0.47 10 7.3 0.65 1.2 0.06 0.57 9.5 7.8 0.58 0.02 2 0.073 18 0.9968 3.36 0.8 10.5 6.1 0.071 102 0.9978 3.35 C C CT 7.5 0.5 0.36 0.54 9.2 6.7 0.58 0.08 1.8 0.097 65 0.9959 3.28 0.8 10.5 7.5 0.5 0.36 6.1 0.071 02 0.9978 3.35 59 0.9943 3.58 0.52 9.9 0.615 0 1.6 0.089 1.56 9.1 0.61 0.29 1.6 0.114 29 0.9974 3.26 45 0.9986 3.16 0.88 9.2 0.62 0.18 3.8 0.176 48 0.9986 3.17 0.93 9.2 0.62 0.19 3.9 0.17 0.75 0.28 0.56 1.8 0.092 03 0.9969 3.3 10.5 1.28 9.3 5 0.56 0.28 1.7 0.368 56 0.9968 3.11 0.5 9 0.59 0.08 4.4 0.086 29 0.9974 3.38 56 0.9969 3.04 1.08 9.2 6 7.9 0.32 0.51 1.8 0.341 60 0.9968 3.39 0.53 9.4 6 8.9 0.22 0.48 1.8 0.077 0.65 9.7 5 0.31 2.3 71 0.9982 3.52 0.39 0.082 0.91 9.5 0.43 0.21 1.6 0.106 37 0.9966 3.17 67 0.9968 3.17 0.53 9.4 5 0.49 0.11 2.3 0.084 0.63 9.7 6 0.14 2.4 0.085 10 0.9968 3.43 9.3 0.16 1.4 0.08 11 23 0.9955 3.34 0.56 0.39 9.5 0.41 0.24 1.8 0.08 11 0.9962 3.28 0.59 10 37 0.9966 3.17 0.91 9.5 0.43 0.21 1.6 0.10 14 35 0.9972 3.47 0.55 9.4 0.71 1.9 0.08 o O 2 0.082 8 16 0.9964 3.38 0.59 9.8 0.645 2.4 0.089 17 82 0.9958 3.35 0.54 10.1 0.675 0.07 0.685 0 2.5 0.105 22 37 0.9966 3.46 0.57 10.6 0.083 15 13 0.9966 3.17 0.66 9.8 0.655 0.12 2.3 0.52 9.4 0.605 0.12 10.7 0.073 40 83 0.9993 3.45 13 50 0.9957 3.38 0.55 9.2 0.32 0.25 1.8 0.103 0.55 9.6 7.8 0.645 0 5.5 0.086 18 0.9986 3.4 0.6 10.8 0.6 0.14 2.4 0.086 3 15 0.9975 3.42 13 30 0.9968 3.23 0.73 9 .7 0.38 0.28 2.1 0.066 19 0.994 3.5 0.48 9.8 1.13 0.09 1.5 0.172 7 12 87 0.9978 3.33 0.83 10.5 0.45 0.36 5.9 0.074 0.83 10.5 7.3 0.45 0.36 5.9 0.074 12 87 0.9978 3.33 17 46 0.9976 3.26 0.51 9.3 8.8 0.61 0.3 2.8 0.088 14 0.9968 3.21 0.9 10.5 7.5 0.49 0.2 2.6 0.332 23 0.9968 3.3 1.2 10.3 8.1 0.66 0.22 2.2 0.069 11 0.9962 3.48 0.52 9.5 6 . 8 0.67 0.02 1.8 0.05 65 0.9934 3.9 0.56 13.1 4.6 0.52 0.15 2.1 0.05 0.73 9.2 7.7 0.935 0.43 2.2 0.114 114 0.997 3.25 37 0.9969 3.25 0.58 9.5 8. 7 0.29 0.52 1.6 0.113 11 How many data points are in your final analysis? What is the average, median, variance and standard deviation of 2 each variable 3 Graph each variable using a bar chart. 4 Is there any skewness in the data? Which direction? 5 What is the cause of the skewness? 6 Which wines are possible outliers and why? a. Create scatter plots between the dependent and each independent variable. b. Produce the R2 value for each scatterplot. 7 c. Produce the correlation values for each scatterplot. d. Which scatterplot shows the strongest and weakest relationship? 8 Determine the multiple regression formula using all independent variables. Show the ANOVA table. What is the coefficient of determination, and adjusted coefficient of 9 determination? What do these values illustrate? At what point/value is each independent variable significant? What 10 does a 1 unit increase in each independent variable do to the dependent variable? 11 What is the mean squared error for this model? What does it mean? 12 Using 1% & 5% alphas, test the overall significance of the model