Can Excel Anova (if so, which Anova) be used to answer the following questions?

Question

Can Excel Anova (if so, which Anova) be used to answer the following questions? If so, how? Can Excel What if also be used? Assume researcher would like to conduct experiment to test effectiveness of study aid. Effectiveness of study aid will be measured by seeing if treated students improved their grade relative to control students. Researcher imagines randomly assigning a sample of n=50 students to either a treatment condition of a study aid or control condition of no study aid. Fix alpha=0.05. What is the researcher's ex ante power to detect a treatment effect (the mean change in test scores between treatment and control groups) of 5 test score points?Researcher actually conducts experiment on given random sample of n=50 students. For the actual realized sample, test whether study aid intervention worked. Control: 25 students. Treatment: 25 students. Test 1 mean for control: 72.2 (standard deviation: 17.05627939), test 1 mean for treatment: 70.52 (standard deviation: 21.31005541). Test 2 mean for control: 81.76 (standard deviation: 10.40545), test 2 mean for treatment: 79.04 (standard deviation: 13.4132).

Explanation / Answer

You have to use one way Excel ANOVA(single factor) for this analysis. The reason behind this is that the reseacher assigning the students randomly in two groups.So,this is a complete randomised design with only one factor having two levels.One is treatment group and another is control group.So,we want to see that whether introducing this the factor,the mean difference between this two groups increasing or not.If the absolute mean difference between them is increasing readily,then we can infer that,yes,after treating some students with medicine,their score improve over the control group.If the absolute mean difference does not increase by a significant level,we say that the treatment group's mean score have not improved over the control group. Excel what if can also be used to check thether the mean diffference between those two groups is really differeing.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.