AttachedStudent ID PLEASE ENTER YOUR STUDENT ID HERE: Question 1 INFO & TASK In your worksheet...

Question

AttachedStudent ID 	PLEASE ENTER YOUR STUDENT ID HERE: Question 1 		INFO & TASK		In your worksheet (click on the “Data Question 1” tab) you will find data from a sensory assessment of 1599 different wines. The data are coded as follows: QUALITY RATING: Overall quality rating of the wine on a scale from 1-10 (Higher values indicate greater perceived quality) ALCOHOL: Alcohol content of the wine (in vol. %) FIXED ACIDITY: Content of tartaric acid in the wine (in grams/liter) VOLATILE ACIDITY: Content of acetic acid in the wine (in grams/liter) Conduct a multiple regression analysis using the Excel Data Analysis ToolPak. Use QUALITY RATING as dependent variable (DV) and ALCOHOL, FIXED ACIDITY and VOLATILE ACIDITY as the three independent variables (IVs).												Total:  5 points 		Question 1.1 		How can you interpret the R2 value? Be specific.												1 point 		Answer  1.1 		Question 1.2 		What can you say about the relationship between ALCOHOL and QUALITY RATING? Be specific and use the units of the variables.												 1.5 points 		Answer  1.2 		Question 1.3		What can you say about the relationship between VOLATILE ACIDITY and QUALITY RATING? Be specific and use the units of the variables.												 1.5 points 		Answer  1.3 		Question 1.4		Based on your regression results, which QUALITY RATING would you predict for a wine with 10 g/l FIXED ACIDITY, 0.5 g/l VOLATILE ACIDITY and 12.0 vol. % ALCOHOL?												1 point 		Answer  1.4  Data Question 1 		Alcohol	Fixed acidity	Volatile acidity	Quality rating 		9.40	7.40	0.70	5.00 		9.80	7.80	0.88	5.00 		9.80	7.80	0.76	5.00 		9.80	11.20	0.28	6.00 		9.40	7.40	0.70	5.00 		9.40	7.40	0.66	5.00 		9.40	7.90	0.60	5.00 		10.00	7.30	0.65	7.00 		9.50	7.80	0.58	7.00 		10.50	7.50	0.50	5.00 		9.20	6.70	0.58	5.00 		10.50	7.50	0.50	5.00 		9.90	5.60	0.62	5.00 		9.10	7.80	0.61	5.00 		9.20	8.90	0.62	5.00 		9.20	8.90	0.62	5.00 		10.50	8.50	0.28	7.00 		9.30	8.10	0.56	5.00 		9.00	7.40	0.59	4.00 		9.20	7.90	0.32	6.00 		9.40	8.90	0.22	6.00 		9.70	7.60	0.39	5.00 		9.50	7.90	0.43	5.00 		9.40	8.50	0.49	5.00 		9.70	6.90	0.40	6.00 		9.30	6.30	0.39	5.00 		9.50	7.60	0.41	5.00 		9.50	7.90	0.43	5.00 		9.40	7.10	0.71	5.00 		9.80	7.80	0.65	6.00 		10.10	6.70	0.68	5.00 		10.60	6.90	0.69	6.00 		9.80	8.30	0.66	5.00 		9.40	6.90	0.61	6.00 		9.20	5.20	0.32	5.00 		9.60	7.80	0.65	6.00 		10.80	7.80	0.60	6.00 		9.70	8.10	0.38	7.00 		9.80	5.70	1.13	4.00 		10.50	7.30	0.45	5.00 		10.50	7.30	0.45	5.00 		9.30	8.80	0.61	4.00 		10.50	7.50	0.49	6.00 		10.30	8.10	0.66	5.00 		9.50	6.80	0.67	5.00 		13.10	4.60	0.52	4.00 		9.20	7.70	0.94	5.00 		9.50	8.70	0.29	5.00 		9.20	6.40	0.40	5.00 		9.20	5.60	0.31	5.00 		9.20	8.80	0.66	5.00 		9.40	6.60	0.52	6.00 		9.40	6.60	0.50	6.00 		9.40	8.60	0.38	5.00 		10.20	7.60	0.51	6.00 		9.50	7.70	0.62	5.00 		9.60	10.20	0.42	5.00 		9.40	7.50	0.63	5.00 		10.00	7.80	0.59	5.00 		9.40	7.30	0.39	6.00 		9.20	8.80	0.40	5.00 		9.30	7.70	0.69	5.00 		9.50	7.50	0.52	7.00 		9.80	7.00	0.74	5.00 		10.90	7.20	0.73	5.00 		10.90	7.20	0.73	5.00 		9.60	7.50	0.52	5.00 		10.70	6.60	0.71	5.00 		10.70	9.30	0.32	5.00 		10.50	8.00	0.71	6.00 		9.50	7.70	0.63	6.00 		9.50	7.70	0.67	5.00 		9.50	7.70	0.69	5.00 		9.20	8.30	0.68	4.00 		9.60	9.70	0.32	5.00 		10.50	8.80	0.41	5.00 		10.50	8.80	0.41	5.00 		10.70	6.80	0.79	6.00 		10.10	6.70	0.75	5.00 		9.10	8.30	0.63	4.00 		9.20	6.20	0.45	5.00 		9.40	7.80	0.43	5.00 		9.10	7.40	0.50	5.00 		9.40	7.30	0.67	5.00 		10.30	6.30	0.30	6.00 		10.10	6.90	0.55	5.00 		9.90	8.60	0.49	6.00 		9.60	7.70	0.49	5.00 		9.50	9.30	0.39	5.00 		9.00	7.00	0.62	5.00 		9.50	7.90	0.52	5.00 		9.90	8.60	0.49	6.00 		9.80	8.60	0.49	5.00 		9.60	7.70	0.49	5.00 		10.50	5.00	1.02	4.00 		12.90	4.70	0.60	6.00 		10.70	6.80	0.78	5.00 		9.20	7.00	0.50	5.00 		9.80	7.60	0.90	5.00 		9.00	8.10	0.55	6.00 		10.20	8.30	0.61	6.00 		10.40	7.80	0.50	6.00 		9.00	8.10	0.55	6.00 		9.20	8.10	0.58	5.00 		9.40	7.20	0.49	5.00 		9.20	8.10	0.58	5.00 		9.30	7.80	0.41	5.00 		9.30	6.20	0.63	5.00 		9.60	8.00	0.33	6.00 		9.30	8.10	0.79	5.00 		9.50	7.80	0.56	5.00 		9.80	8.40	0.62	5.00 		9.80	8.40	0.60	5.00 		9.70	10.10	0.31	6.00 		9.50	7.80	0.56	5.00 		10.50	9.40	0.40	6.00 		10.00	8.30	0.54	6.00 		9.40	7.80	0.56	6.00 		10.90	8.80	0.55	6.00 		9.20	7.00	0.69	6.00 		9.00	7.30	1.07	5.00 		10.90	8.80	0.55	6.00 		9.20	7.30	0.70	5.00 		9.50	8.00	0.71	5.00 		9.50	7.80	0.50	5.00 		9.40	9.00	0.62	5.00 		10.90	8.20	1.33	5.00 		10.90	8.10	1.33	5.00 		10.50	8.00	0.59	7.00 		9.40	6.10	0.38	5.00 		9.40	8.00	0.75	5.00 		13.00	5.60	0.50	5.00 		13.00	5.60	0.50	5.00 		9.80	6.60	0.50	6.00 		9.90	7.90	1.04	6.00 		9.60	8.40	0.75	5.00 		9.50	8.30	0.72	5.00 		9.20	7.20	0.42	5.00 		9.50	7.80	0.56	5.00 		9.50	7.80	0.56	5.00 		9.60	8.40	0.75	5.00 		9.50	8.30	0.72	5.00 		14.00	5.20	0.34	6.00 		9.40	6.30	0.39	5.00 		14.00	5.20	0.34	6.00 		9.40	8.10	0.67	5.00 		10.00	5.80	0.68	5.00 		9.30	7.60	0.49	5.00 		10.20	6.90	0.49	6.00 		10.50	8.20	0.40	6.00 		10.30	7.30	0.33	6.00 		9.40	9.20	0.52	4.00 		10.10	7.50	0.60	5.00 		10.10	7.50	0.60	5.00 		10.50	7.10	0.43	5.00 		10.50	7.10	0.43	5.00 		10.50	7.10	0.43	5.00 		10.50	7.10	0.43	5.00 		9.30	7.10	0.68	5.00 		9.30	6.80	0.60	6.00 		9.60	7.60	0.95	5.00 		9.20	7.60	0.68	4.00 		10.00	7.80	0.53	6.00 		9.40	7.40	0.60	5.00 		9.40	7.30	0.59	5.00 		9.50	7.80	0.63	5.00 		10.20	6.80	0.64	5.00 		9.00	7.30	0.55	4.00 		10.40	6.80	0.63	6.00 		9.50	7.50	0.71	5.00 		9.10	7.90	0.89	4.00 		9.20	8.00	0.42	6.00 		9.20	8.00	0.42	6.00 		11.50	7.40	0.62	6.00 		9.50	7.30	0.38	5.00 		9.50	6.90	0.50	5.00 		9.50	7.30	0.38	5.00 		10.50	7.50	0.52	6.00 		9.60	7.00	0.81	5.00 		9.50	8.80	0.61	5.00 		9.50	8.80	0.61	5.00 		9.30	8.90	0.61	5.00 		9.30	7.20	0.73	5.00 		9.30	6.80	0.61	5.00 		9.30	6.70	0.62	6.00 		9.70	8.90	0.31	5.00 		9.20	7.40	0.39	5.00 		9.70	7.70	0.71	5.00 		9.50	7.90	0.50	5.00 		9.50	7.90	0.49	5.00 		9.40	8.20	0.50	5.00 		9.80	6.40	0.37	6.00 		9.50	6.80	0.63	5.00 		9.70	7.60	0.55	5.00 		9.70	7.60	0.55	5.00 		9.40	7.80	0.59	5.00 		10.20	7.30	0.58	5.00 		10.10	11.50	0.30	6.00 		13.00	5.40	0.84	7.00 		11.40	6.90	1.09	4.00 		10.30	9.60	0.32	7.00 		9.30	8.80	0.37	5.00 		9.50	6.80	0.50	5.00 		9.20	7.00	0.42	5.00 		9.20	7.00	0.43	6.00 		10.80	12.80	0.30	7.00 		10.80	12.80	0.30	7.00 		9.30	7.80	0.57	5.00 		9.40	7.80	0.44	5.00 		10.50	11.00	0.30	7.00 		12.40	9.70	0.53	6.00 		10.00	8.00	0.73	6.00 		10.20	11.60	0.44	6.00 		10.10	8.20	0.57	5.00 		9.80	7.80	0.74	6.00 		10.50	7.00	0.49	5.00 		11.00	8.70	0.63	5.00 		9.10	8.10	0.73	5.00 		9.70	7.50	0.49	5.00 		9.50	7.80	0.53	5.00 		9.40	7.80	0.34	6.00 		9.40	7.40	0.53	5.00 		9.50	6.80	0.61	5.00 		10.00	8.60	0.65	6.00 		10.40	8.40	0.64	4.00 		10.50	7.70	0.43	6.00 		9.50	8.90	0.59	6.00 		9.80	9.00	0.82	5.00 		10.50	7.70	0.43	6.00 		11.00	6.90	0.52	5.00 		12.20	5.20	0.48	7.00 		9.90	8.00	0.38	6.00 		9.60	8.50	0.37	6.00 		11.00	6.90	0.52	5.00 		9.00	8.20	1.00	6.00 		9.00	7.20	0.63	6.00 		9.00	7.20	0.63	6.00 		9.20	7.20	0.65	6.00 		9.00	7.20	0.63	6.00 		9.00	8.20	1.00	6.00 		9.30	8.90	0.64	5.00 		10.90	12.00	0.38	6.00 		9.80	7.70	0.58	6.00 		9.20	15.00	0.21	7.00 		9.20	15.00	0.21	7.00 		9.90	7.30	0.66	6.00 		9.50	7.10	0.68	5.00 		9.30	8.20	0.60	5.00 		9.80	7.70	0.53	6.00 		9.90	7.30	0.66	6.00 		10.00	10.80	0.32	6.00 		9.90	7.10	0.60	6.00 		10.50	11.10	0.35	5.00 		9.50	7.70	0.78	5.00 		9.90	7.10	0.60	6.00 		9.30	8.00	0.57	5.00 		9.20	9.40	0.34	5.00 		9.20	6.60	0.70	5.00 		9.40	7.70	0.41	5.00 		10.50	10.00	0.31	7.00 		9.30	7.90	0.33	5.00 		9.40	7.00	0.98	4.00 		10.00	8.00	0.52	5.00 		9.30	7.90	0.37	5.00 		10.90	12.50	0.56	5.00 		10.20	11.80	0.26	7.00 		9.80	8.10	0.87	4.00 		12.80	7.90	0.35	8.00 		9.40	6.90	0.54	6.00 		10.10	11.50	0.18	6.00 		10.70	7.90	0.55	6.00 		10.10	11.50	0.18	6.00 		10.10	10.90	0.37	5.00 		9.40	8.40	0.72	5.00 		9.40	7.50	0.65	5.00 		10.70	7.90	0.55	6.00 		9.40	6.90	0.54	6.00 		10.10	11.50	0.18	6.00 		12.60	10.30	0.32	8.00 		10.50	8.90	0.40	7.00 		9.30	11.40	0.26	6.00 		9.90	7.70	0.27	7.00 		9.10	7.60	0.52	5.00 		10.50	8.90	0.40	7.00 		9.80	9.90	0.59	5.00 		9.80	9.90	0.59	5.00 		10.30	12.00	0.45	6.00 		10.30	7.50	0.40	6.00 		10.60	8.70	0.52	7.00 		9.20	11.60	0.42	5.00 		10.60	8.70	0.52	7.00 		10.50	11.00	0.20	5.00 		10.30	10.40	0.55	6.00 		10.10	6.90	0.36	6.00 		9.50	13.30	0.34	6.00 		9.50	10.80	0.50	5.00 		9.90	10.60	0.83	5.00 		9.60	7.10	0.63	5.00 		9.70	7.20	0.65	5.00 		9.60	6.90	0.67	5.00 		10.70	7.50	0.53	6.00 		10.10	11.10	0.18	6.00 		10.00	8.30	0.71	5.00 		9.50	7.40	0.67	5.00 		9.20	8.40	0.65	5.00 		9.30	10.30	0.53	6.00 		9.40	7.60	0.62	5.00 		9.50	10.30	0.41	6.00 		9.50	10.30	0.43	6.00 		9.50	7.40	0.29	6.00 		9.30	10.30	0.53	6.00 		9.40	7.90	0.53	6.00 		9.50	9.00	0.46	6.00 		9.40	8.60	0.47	5.00 		11.00	7.40	0.36	5.00 		11.00	7.10	0.35	6.00 		10.10	9.60	0.56	5.00 		10.40	9.60	0.77	6.00 		11.50	9.80	0.66	7.00 		10.40	9.60	0.77	6.00 		11.50	9.80	0.66	7.00 		9.70	9.30	0.61	5.00 		9.30	7.80	0.62	5.00 		9.50	10.30	0.59	6.00 		9.20	10.00	0.49	6.00 		9.20	10.00	0.49	6.00 		11.50	11.60	0.53	7.00 		11.50	10.30	0.44	5.00 		9.70	13.40	0.27	6.00 		9.50	10.70	0.46	5.00 		12.50	10.20	0.36	6.00 		12.50	10.20	0.36	6.00 		9.40	8.00	0.58	6.00 		11.00	8.40	0.56	5.00 		11.70	7.90	0.65	7.00 		12.20	11.90	0.70	7.00 		12.50	8.90	0.43	6.00 		10.30	7.80	0.43	5.00 		11.50	12.40	0.49	6.00 		9.80	12.50	0.28	7.00 		9.20	12.20	0.34	6.00 		11.30	10.60	0.42	6.00 		9.80	10.90	0.39	6.00 		9.80	10.90	0.39	6.00 		10.70	11.90	0.57	6.00 		9.90	7.00	0.69	5.00 		12.30	6.60	0.82	7.00 		12.00	13.80	0.49	6.00

Mohammad Wasif · Accepted Answer

Student ID
	PLEASE ENTER YOUR STUDENT ID HERE:
Question 1
		INFO & TASK		In your worksheet (click on the “Data Question 1” tab) you will find data from a sensory assessment of 1599 different wines. The data are coded as follows:
QUALITY RATING: Overall quality rating of the wine on a scale from 1-10 (Higher values indicate greater perceived quality)
ALCOHOL: Alcohol content of the wine (in vol. %)
FIXED ACIDITY: Content of tartaric acid in the wine (in grams/liter)
VOLATILE ACIDITY: Content of acetic acid in the wine (in grams/liter)
Conduct a multiple regression analysis using the Excel Data Analysis ToolPak. Use QUALITY RATING as dependent variable (DV) and ALCOHOL, FIXED ACIDITY and VOLATILE ACIDITY as the three independent variables (IVs).												Total: 
5 points
		Question 1.1 		How can you interpret the R2 value? Be specific.												1 point
		Answer  1.1		The value of R2 is 0.3224. It means that 32.24%  of the Quality Rating varies.
		Question 1.2 		What can you say about the relationship between ALCOHOL and QUALITY RATING? Be specific and use the units of the variables.												 1.5 points
		Answer  1.2		The relationship between ALCOHOL and QUALITY RATING is positive. Its value is 0.3207 g/l
		Question 1.3		What can you say about the relationship between VOLATILE ACIDITY and QUALITY RATING? Be specific and use the units of the variables.												 1.5 points
		Answer  1.3		The relationship between VOLATILE ACIDITY and QUALITY RATING is negative. Its value is -1.286 g/l
		Question 1.4		Based on your regression results, which QUALITY RATING would you predict for a wine with 10 g/l FIXED ACIDITY, 0.5 g/l VOLATILE ACIDITY and 12.0 vol. % ALCOHOL?												1 point
		Answer  1.4		I would like to predict for the ALCOHOL.
 Data Question 1
		Alcohol	Fixed acidity	Volatile acidity	Quality rating		SUMMARY OUTPUT
		9.40	7.40	0.70	5.00
		9.80	7.80	0.88	5.00		Regression Statistics
		9.80	7.80	0.76	5.00		Multiple R	0.5678711731
		9.80	11.20	0.28	6.00		R Square	0.3224776692
		9.40	7.40	0.70	5.00		Adjusted R Square	0.3212033325
		9.40	7.40	0.66	5.00		Standard Error	0.6653493342
		9.40	7.90	0.60	5.00		Observations	1599
		10.00	7.30	0.65	7.00
		9.50	7.80	0.58	7.00		ANOVA
		10.50	7.50	0.50	5.00			df	SS	MS	F	Significance F
		9.20	6.70	0.58	5.00		Regression	3	336.0749734112	112.0249911371	253.0553159265	2.62982394339378E-134
		10.50	7.50	0.50	5.00		Residual	1595	706.0901297783	0.4426897365
		9.90	5.60	0.62	5.00		Total	1598	1042.1651031895
		9.10	7.80	0.61	5.00
		9.20	8.90	0.62	5.00			Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
		9.20	8.90	0.62	5.00		Intercept	2.6744693199	0.2180331658	12.266341727	4.05298383111862E-33	2.2468076409	3.1021309989	2.2468076409	3.1021309989
		10.50	8.50	0.28	7.00		Alcohol	0.3207261028	0.0160640596	19.9654452117	2.4320600265992E-79	0.2892172142	0.3522349913	0.2892172142	0.3522349913
		9.30	8.10	0.56	5.00		Fixed acidity	0.0357631568	0.0099612966	3.5902110141	0.0003404154	0.0162245476	0.0553017661	0.0162245476	0.0553017661
		9.00	7.40	0.59	4.00		Volatile acidity	-1.2862441593	0.098715673	-13.0297866666	5.93213589709179E-37	-1.4798702541	-1.0926180645	-1.4798702541	-1.0926180645
		9.20	7.90	0.32	6.00
		9.40	8.90	0.22	6.00
		9.70	7.60	0.39	5.00
		9.50	7.90	0.43	5.00
		9.40	8.50	0.49	5.00
		9.70	6.90	0.40	6.00
		9.30	6.30	0.39	5.00
		9.50	7.60	0.41	5.00
		9.50	7.90	0.43	5.00
		9.40	7.10	0.71	5.00
		9.80	7.80	0.65	6.00
		10.10	6.70	0.68	5.00
		10.60	6.90	0.69	6.00
		9.80	8.30	0.66	5.00
		9.40	6.90	0.61	6.00
		9.20	5.20	0.32	5.00
		9.60	7.80	0.65	6.00
		10.80	7.80	0.60	6.00
		9.70	8.10	0.38	7.00
		9.80	5.70	1.13	4.00
		10.50	7.30	0.45	5.00
		10.50	7.30	0.45	5.00
		9.30	8.80	0.61	4.00
		10.50	7.50	0.49	6.00
		10.30	8.10	0.66	5.00
		9.50	6.80	0.67	5.00
		13.10	4.60	0.52	4.00
		9.20	7.70	0.94	5.00
		9.50	8.70	0.29	5.00
		9.20	6.40	0.40	5.00
		9.20	5.60	0.31	5.00
		9.20	8.80	0.66	5.00
		9.40	6.60	0.52	6.00
		9.40	6.60	0.50	6.00
		9.40	8.60	0.38	5.00
		10.20	7.60	0.51	6.00
		9.50	7.70	0.62	5.00
		9.60	10.20	0.42	5.00
		9.40	7.50	0.63	5.00
		10.00	7.80	0.59	5.00
		9.40	7.30	0.39	6.00
		9.20	8.80	0.40	5.00
		9.30	7.70	0.69	5.00
		9.50	7.50	0.52	7.00
		9.80	7.00	0.74	5.00
		10.90	7.20	0.73	5.00
		10.90	7.20	0.73	5.00
		9.60	7.50	0.52	5.00
		10.70	6.60	0.71	5.00
		10.70	9.30	0.32	5.00
		10.50	8.00	0.71	6.00
		9.50	7.70	0.63	6.00
		9.50	7.70	0.67	5.00
		9.50	7.70	0.69	5.00
		9.20	8.30	0.68	4.00
		9.60	9.70	0.32	5.00
		10.50	8.80	0.41	5.00
		10.50	8.80	0.41	5.00
		10.70	6.80	0.79	6.00
		10.10	6.70	0.75	5.00
		9.10	8.30	0.63	4.00
		9.20	6.20	0.45	5.00
		9.40	7.80	0.43	5.00
		9.10	7.40	0.50	5.00
		9.40	7.30	0.67	5.00
		10.30	6.30	0.30	6.00
		10.10	6.90	0.55	5.00
		9.90	8.60	0.49	6.00
		9.60	7.70	0.49	5.00
		9.50	9.30	0.39	5.00
		9.00	7.00	0.62	5.00
		9.50	7.90	0.52	5.00
		9.90	8.60	0.49	6.00
		9.80	8.60	0.49	5.00
		9.60	7.70	0.49	5.00
		10.50	5.00	1.02	4.00
		12.90	4.70	0.60	6.00
		10.70	6.80	0.78	5.00
		9.20	7.00	0.50	5.00
		9.80	7.60	0.90	5.00
		9.00	8.10	0.55	6.00
		10.20	8.30	0.61	6.00
		10.40	7.80	0.50	6.00
		9.00	8.10	0.55	6.00
		9.20	8.10	0.58	5.00
		9.40	7.20	0.49	5.00
		9.20	8.10	0.58	5.00
		9.30	7.80	0.41	5.00
		9.30	6.20	0.63	5.00
		9.60	8.00	0.33	6.00
		9.30	8.10	0.79	5.00
		9.50	7.80	0.56	5.00
		9.80	8.40	0.62	5.00
		9.80	8.40	0.60	5.00
		9.70	10.10	0.31	6.00
		9.50	7.80	0.56	5.00
		10.50	9.40	0.40	6.00
		10.00	8.30	0.54	6.00
		9.40	7.80	0.56	6.00
		10.90	8.80	0.55	6.00
		9.20	7.00	0.69	6.00
		9.00	7.30	1.07	5.00
		10.90	8.80	0.55	6.00
		9.20	7.30	0.70	5.00
		9.50	8.00	0.71	5.00
		9.50	7.80	0.50	5.00
		9.40	9.00	0.62	5.00
		10.90	8.20	1.33	5.00
		10.90	8.10	1.33	5.00
		10.50	8.00	0.59	7.00
		9.40	6.10	0.38	5.00
		9.40	8.00	0.75	5.00
		13.00	5.60	0.50	5.00
		13.00	5.60	0.50	5.00
		9.80	6.60	0.50	6.00
		9.90	7.90	1.04	6.00
		9.60	8.40	0.75	5.00
		9.50	8.30	0.72	5.00
		9.20	7.20	0.42	5.00
		9.50	7.80	0.56	5.00
		9.50	7.80	0.56	5.00
		9.60	8.40	0.75	5.00
		9.50	8.30	0.72	5.00
		14.00	5.20	0.34	6.00
		9.40	6.30	0.39	5.00
		14.00	5.20	0.34	6.00
		9.40	8.10	0.67	5.00
		10.00	5.80	0.68	5.00
		9.30	7.60	0.49	5.00
		10.20	6.90	0.49	6.00
		10.50	8.20	0.40	6.00
		10.30	7.30	0.33	6.00
		9.40	9.20	0.52	4.00
		10.10	7.50	0.60	5.00
		10.10	7.50	0.60	5.00
		10.50	7.10	0.43	5.00
		10.50	7.10	0.43	5.00
		10.50	7.10	0.43	5.00
		10.50	7.10	0.43	5.00
		9.30	7.10	0.68	5.00
		9.30	6.80	0.60	6.00
		9.60	7.60	0.95	5.00
		9.20	7.60	0.68	4.00
		10.00	7.80	0.53	6.00
		9.40	7.40	0.60	5.00
		9.40	7.30	0.59	5.00
		9.50	7.80	0.63	5.00
		10.20	6.80	0.64	5.00
		9.00	7.30	0.55	4.00
		10.40	6.80	0.63	6.00
		9.50	7.50	0.71	5.00
		9.10	7.90	0.89	4.00
		9.20	8.00	0.42	6.00
		9.20	8.00	0.42	6.00
		11.50	7.40	0.62	6.00
		9.50	7.30	0.38	5.00
		9.50	6.90	0.50	5.00
		9.50	7.30	0.38	5.00
		10.50	7.50	0.52	6.00
		9.60	7.00	0.81	5.00
		9.50	8.80	0.61	5.00
		9.50	8.80	0.61	5.00
		9.30	8.90	0.61	5.00
		9.30	7.20	0.73	5.00
		9.30	6.80	0.61	5.00
		9.30	6.70	0.62	6.00
		9.70	8.90	0.31	5.00
		9.20	7.40	0.39	5.00
		9.70	7.70	0.71	5.00
		9.50	7.90	0.50	5.00
		9.50	7.90	0.49	5.00
		9.40	8.20	0.50	5.00
		9.80	6.40	0.37	6.00
		9.50	6.80	0.63	5.00
		9.70	7.60	0.55	5.00
		9.70	7.60	0.55	5.00
		9.40	7.80	0.59	5.00
		10.20	7.30	0.58	5.00
		10.10	11.50	0.30	6.00
		13.00	5.40	0.84	7.00
		11.40	6.90	1.09	4.00
		10.30	9.60	0.32	7.00
		9.30	8.80	0.37	5.00
		9.50	6.80	0.50	5.00
		9.20	7.00	0.42	5.00
		9.20	7.00	0.43	6.00
		10.80	12.80	0.30	7.00
		10.80	12.80	0.30	7.00
		9.30	7.80	0.57	5.00
		9.40	7.80	0.44	5.00
		10.50	11.00	0.30	7.00
		12.40	9.70	0.53	6.00
		10.00	8.00	0.73	6.00
		10.20	11.60	0.44	6.00
		10.10	8.20	0.57	5.00
		9.80	7.80	0.74	6.00
		10.50	7.00	0.49	5.00
		11.00	8.70	0.63	5.00
		9.10	8.10	0.73	5.00
		9.70	7.50	0.49	5.00
		9.50	7.80	0.53	5.00
		9.40	7.80	0.34	6.00
		9.40	7.40	0.53	5.00
		9.50	6.80	0.61	5.00
		10.00	8.60	0.65	6.00
		10.40	8.40	0.64	4.00
		10.50	7.70	0.43	6.00
		9.50	8.90	0.59	6.00
		9.80	9.00	0.82	5.00
		10.50	7.70	0.43	6.00
		11.00	6.90	0.52	5.00
		12.20	5.20	0.48	7.00
		9.90	8.00	0.38	6.00
		9.60	8.50	0.37	6.00
		11.00	6.90	0.52	5.00
		9.00	8.20	1.00	6.00
		9.00	7.20	0.63	6.00
		9.00	7.20	0.63	6.00
		9.20	7.20	0.65	6.00
		9.00	7.20	0.63	6.00
		9.00	8.20	1.00	6.00
		9.30	8.90	0.64	5.00
		10.90	12.00	0.38	6.00
		9.80	7.70	0.58	6.00
		9.20	15.00	0.21	7.00
		9.20	15.00	0.21	7.00
		9.90	7.30	0.66	6.00
		9.50	7.10	0.68	5.00
		9.30	8.20	0.60	5.00
		9.80	7.70	0.53	6.00
		9.90	7.30	0.66	6.00
		10.00	10.80	0.32	6.00
		9.90	7.10	0.60	6.00
		10.50	11.10	0.35	5.00
		9.50	7.70	0.78	5.00
		9.90	7.10	0.60	6.00
		9.30	8.00	0.57	5.00
		9.20	9.40	0.34	5.00
		9.20	6.60	0.70	5.00
		9.40	7.70	0.41	5.00
		10.50	10.00	0.31	7.00
		9.30	7.90	0.33	5.00
		9.40	7.00	0.98	4.00
		10.00	8.00	0.52	5.00
		9.30	7.90	0.37	5.00
		10.90	12.50	0.56	5.00
		10.20	11.80	0.26	7.00
		9.80	8.10	0.87	4.00
		12.80	7.90	0.35	8.00
		9.40	6.90	0.54	6.00
		10.10	11.50	0.18	6.00
		10.70	7.90	0.55	6.00
		10.10	11.50	0.18	6.00
		10.10	10.90	0.37	5.00
		9.40	8.40	0.72	5.00
		9.40	7.50	0.65	5.00
		10.70	7.90	0.55	6.00
		9.40	6.90	0.54	6.00
		10.10	11.50	0.18	6.00
		12.60	10.30	0.32	8.00
		10.50	8.90	0.40	7.00
		9.30	11.40	0.26	6.00
		9.90	7.70	0.27	7.00
		9.10	7.60	0.52	5.00
		10.50	8.90	0.40	7.00
		9.80	9.90	0.59	5.00
		9.80	9.90	0.59	5.00
		10.30	12.00	0.45	6.00
		10.30	7.50	0.40	6.00
		10.60	8.70	0.52	7.00
		9.20	11.60	0.42	5.00
		10.60	8.70	0.52	7.00
		10.50	11.00	0.20	5.00
		10.30	10.40	0.55	6.00
		10.10	6.90	0.36	6.00
		9.50	13.30	0.34	6.00
		9.50	10.80	0.50	5.00
		9.90	10.60	0.83	5.00
		9.60	7.10	0.63	5.00
		9.70	7.20	0.65	5.00
		9.60	6.90	0.67	5.00
		10.70	7.50	0.53	6.00
		10.10	11.10	0.18	6.00
		10.00	8.30	0.71	5.00
		9.50	7.40	0.67	5.00
		9.20	8.40	0.65	5.00
		9.30	10.30	0.53	6.00
		9.40	7.60	0.62	5.00
		9.50	10.30	0.41	6.00
		9.50	10.30	0.43	6.00
		9.50	7.40	0.29	6.00
		9.30	10.30	0.53	6.00
		9.40	7.90	0.53	6.00
		9.50	9.00	0.46	6.00
		9.40	8.60	0.47	5.00
		11.00	7.40	0.36	5.00
		11.00	7.10	0.35	6.00
		10.10	9.60	0.56	5.00
		10.40	9.60	0.77	6.00
		11.50	9.80	0.66	7.00
		10.40	9.60	0.77	6.00
		11.50	9.80	0.66	7.00
		9.70	9.30	0.61	5.00
		9.30	7.80	0.62	5.00
		9.50	10.30	0.59	6.00
		9.20	10.00	0.49	6.00
		9.20	10.00	0.49	6.00
		11.50	11.60	0.53	7.00
		11.50	10.30	0.44	5.00
		9.70	13.40	0.27	6.00
		9.50	10.70	0.46	5.00
		12.50	10.20	0.36	6.00
		12.50	10.20	0.36	6.00
		9.40	8.00	0.58	6.00
		11.00	8.40	0.56	5.00
		11.70	7.90	0.65	7.00
		12.20	11.90	0.70	7.00
		12.50	8.90	0.43	6.00
		10.30	7.80	0.43	5.00
		11.50	12.40	0.49	6.00
		9.80	12.50	0.28	7.00
		9.20	12.20	0.34	6.00
		11.30	10.60	0.42	6.00
		9.80	10.90	0.39	6.00
		9.80	10.90	0.39	6.00
		10.70	11.90	0.57	6.00
		9.90	7.00	0.69	5.00
		12.30	6.60	0.82	7.00
		12.00	13.80	0.49	6.00
		10.00	9.60	0.56	6.00
		9.40	9.10	0.79	6.00
		9.90	10.70	0.67	6.00
		9.40	9.10	0.80	6.00
		9.30	7.70	0.67	5.00
		13.00	13.50	0.53	5.00
		11.90	6.10	0.21	6.00
		12.80	6.70	0.75	6.00
		11.00	11.50	0.41	5.00
		11.70	10.50	0.42	7.00
		10.40	11.90	0.43	7.00
		9.80	12.60	0.38	6.00
		9.40	8.20	0.70	5.00
		9.90	8.60	0.45	6.00
		10.00	11.90	0.58	5.00
		10.20	12.50	0.46	5.00
		10.00	12.80	0.62	7.00
		11.80	10.00	0.42	6.00
		10.00	12.80	0.62	7.00
		9.00	10.40	0.58	5.00
		9.40	10.30	0.34	5.00
		12.00	9.40	0.27	7.00
		9.90	6.90	0.77	5.00
		8.70	7.90	0.24	6.00
		10.60	9.10	0.28	6.00
		9.20	7.40	0.55	5.00
		10.80	14.00	0.41	6.00
		11.80	11.50	0.54	7.00
		11.00	11.50	0.45	6.00
		12.00	9.40	0.27	7.00
		13.30	11.40	0.63	6.00
		10.80	8.30	0.42	6.00
		9.40	8.30	0.26	6.00
		10.00	13.70	0.42	6.00
		9.40	8.30	0.26	6.00
		9.40	8.30	0.26	6.00
		9.20	7.70	0.51	5.00
		9.70	7.40	0.63	6.00
		9.20	7.80	0.54	6.00
		9.60	8.30	0.66	6.00
		9.20	7.80	0.46	6.00
		10.00	9.60	0.38	7.00
		12.90	5.60	0.85	8.00
		10.00	13.70	0.42	6.00
		9.50	9.50	0.37	5.00
		9.10	8.40	0.67	5.00
		9.90	12.70	0.60	5.00
		13.00	12.00	0.37	7.00
		9.90	6.60	0.74	5.00
		11.00	11.50	0.59	6.00
		11.00	11.50	0.59	6.00
		9.40	8.70	0.77	5.00
		9.90	6.60	0.74	5.00
		10.80	7.70	0.26	6.00
		10.50	12.20	0.48	6.00
		10.50	11.40	0.60	6.00
		9.10	7.70	0.69	5.00
		10.10	8.70	0.31	6.00
		10.80	9.80	0.44	6.00
		10.80	12.00	0.39	7.00
		11.30	10.40	0.34	6.00
		9.60	12.50	0.46	4.00
		9.50	9.00	0.43	6.00
		9.50	9.10	0.45	5.00
		9.30	7.10	0.74	5.00
		11.70	9.90	0.40	7.00
		9.50	8.80	0.52	5.00
		9.30	8.60	0.73	5.00
		11.70	10.60	0.48	6.00
		10.50	7.00	0.58	5.00
		10.40	11.90	0.38	6.00
		9.90	6.80	0.77	5.00
		11.80	9.50	0.56	7.00
		12.30	6.60	0.84	7.00
		10.90	7.70	0.96	5.00
		11.00	10.50	0.24	7.00
		10.90	7.70	0.96	5.00
		12.30	6.60	0.84	7.00
		11.40	6.40	0.67	6.00
		10.60	9.50	0.78	6.00
		9.30	9.10	0.52	5.00
		10.40	12.80	0.84	6.00
		11.00	10.50	0.24	7.00
		9.20	7.80	0.55	5.00
		12.80	11.90	0.37	6.00
		9.50	12.30	0.39	5.00
		9.90	10.40	0.41	6.00
		9.50	12.30	0.39	5.00
		10.20	8.00	0.67	6.00
		11.20	11.10	0.45	6.00
		9.90	10.40	0.41	6.00
		9.30	7.00	0.62	5.00
		9.80	12.60	0.31	8.00
		11.30	11.90	0.40	6.00
		11.20	15.60	0.69	7.00
		11.60	10.00	0.44	7.00
		12.50	5.30	0.57	7.00
		10.10	9.50	0.74	6.00
		10.50	12.50	0.38	5.00
		11.20	9.30	0.48	5.00
		10.20	8.60	0.53	6.00
		10.80	11.90	0.39	6.00
		10.

Student ID PLEASE ENTER YOUR STUDENT ID HERE: Question 1 INFO & TASK In your worksheet (click on the “Data Question 1” tab) you will find data from a sensory assessment of 1599 different wines. The...

Answer To: Student ID PLEASE ENTER YOUR STUDENT ID HERE: Question 1 INFO & TASK In your worksheet (click on the...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment