Question

Use the following data related to the same population and determine if the selected independent variable is affecting the dependent variable. Variable (27,29,32,31,26,25)

Use an alpha of 5% for ANOVA and Correlation Coefficient. Use excel for the results. Explain the outcome.

Data Sample:

30, 27, 24, 21,27,32

25, 21, 22, 28, 30, 31

26,25,25, 21, 22, 20

31, 29, 24,22,20. 29

Answer 1

ANOVA:

Input data in the following manner. Go to Data, select Data Analysis, choose Anova: Single Factor grouping by columns.

	Dependent
	27	29	32	31	26	25
1	30	27	24	21	27	32
2	25	21	22	28	30	31
3	26	25	25	21	22	20
4	31	29	24	22	20	29

Anova: Single Factor
SUMMARY
Groups	Count	Sum	Average	Variance
27	4	112	28	8.67
29	4	102	25.5	11.67
32	4	95	23.75	1.58
31	4	92	23	11.33
26	4	99	24.75	20.92
25	4	112	28	30
ANOVA
Source of Variation	SS	df	MS	F	P-value	F crit
Between Groups	89.5	5	17.90	1.28	0.32	2.77
Within Groups	252.5	18	14.03
Total	342	23

H0: µ1 = µ2 = µ3 = µ4 = µ5 = µ6,Independent variable is not affecting the dependent variable

H1: At least one µi is different,Independent variable is affecting the dependent variable

p-value = 0.32

Since p-value is more than 0.05, we do not reject the null hypothesis and conclude that independent variable is not affecting the dependent variable.