I need some major help here. Can I get this solved and explained how to run the data through EXCEL. I have several more problems like this so a thorough explanation and how to make a graph is greatly needed.

Question 2:

Using the raw data, answer the following:

Use t-test calculations for the two-independent means: Be sure to show your work ( p-value, crit., df., Mean, etc.)?

What are the scores of the pre-and post-test for the experimental group (group #s 1&2)?

What are the scores of the pre-and post-test for the control group (group #s 3&4)? Is there a significance using p < 0.05

Now, compare the different scores for the control and experiment groups pretest and posttest data?

Is the null hypotheses true?

H0: the experimental group is more statistically significant than the control group

H1: the experimental group is not more statistically significant than the control group Be sure to insert an excel graph with the pretest and post test results of each group .

Raw Data:

Raw Data:

Group 1 Group 2 Group 3 Group 4

28.2 20.9 21.2 17.8

26.2 27.2 23.9 15.9

21.6 26.6 19.5 18.4

29.7 22.1 17.4 20.2

30.3 25.3 21.2 14.1

25.9 30.1 23.9 17.8

21.6 23.8 19.5 15.9

Group 1:Pre-test experimental group

Group 2: Post-test experimental group

Group 3: Pre-test control group

Group 4: Post-test control group