Calculation Assignment <\/p>\n
2-Way ANOVA<\/p>\n
Researchers were interested in whether a cognitive-behavioral group therapy intervention would reduce symptoms of depression among male students in a particular high school. Thirty students were randomly assigned to either the intervention group or the control group, with 15 in each group. The depression level of all students was measured at the beginning of the study (Time 1) and again at the end (Time 2). A two-way mixed ANOVA was used to determine the impact of the intervention. The two independent variables were time of assessment (Time 1 vs. Time 2) and treatment (intervention group vs. control group). (Note that this is considered a \u201cmixed\u201d ANOVA because treatment is a between-group variable, and time of assessment is a within-group\/repeated measures variable.)<\/p>\n
3171825748665From the data table, notice that \u201cTreatment\u201d is represented by columns and \u201cTime\u201d is represented by rows. Also note that what we call \u201cRows,\u201d Excel calls \u201cSample.\u201d<\/p>\n
400000From the data table, notice that \u201cTreatment\u201d is represented by columns and \u201cTime\u201d is represented by rows. Also note that what we call \u201cRows,\u201d Excel calls \u201cSample.\u201d<\/p>\n
Use the data below to calculate a two-way ANOVA in Excel. Answer the questions that follow and include a copy of your results. <\/p>\n
Intervention Group Control Group<\/p>\n
Time 1 7 17<\/p>\n
12 7<\/p>\n
10 16<\/p>\n
15 14<\/p>\n
18 7<\/p>\n
12 11<\/p>\n
12 9<\/p>\n
11 10<\/p>\n
18 12<\/p>\n
9 9<\/p>\n
13 15<\/p>\n
9 9<\/p>\n
9 10<\/p>\n
10 10<\/p>\n
8 9<\/p>\n
Time 2 9 16<\/p>\n
12 8<\/p>\n
10 15<\/p>\n
9 9<\/p>\n
7 16<\/p>\n
6 14<\/p>\n
6 9<\/p>\n
10 11<\/p>\n
10 10<\/p>\n
14 8<\/p>\n
10 17<\/p>\n
7 9<\/p>\n
9 18<\/p>\n
8 12<\/p>\n
10 19<\/p>\n
Instructions:<\/p>\n
Copy the data table above into Excel.<\/p>\n
From the Data tab, click on Data Analysis. (If the Data Analysis option does not appear, add it by clicking File, Options, Add-Ins, Analysis ToolPak, Go, OK, as detailed in previous assignments.)<\/p>\n
Select Anova: Two-Factor With Replication and then click on OK.<\/p>\n
Click in the Input Range Box<\/p>\n
Select the entire data set, including all labels, by clicking on the top-left cell and dragging the mouse to the bottom-left cell before releasing the click.<\/p>\n
\u201cRows per sample\u201d is the number of participants in each group, which in this case is 15.<\/p>\n
Select .05 as the alpha level.<\/p>\n
Under Output options, select Output Range button and then click in the Output Range box.<\/p>\n
Click on the cell where you want your results to begin.<\/p>\n
Click OK<\/p>\n
Answer the questions below.<\/p>\n
Copy and paste the results (screen print, Snippit, or whatever works for you) to the bottom of the assignment.<\/p>\n
QUESTIONS:<\/p>\n
This is a 2×2, 2-way ANOVA. How many cells are there?<\/p>\n
The Excel table provides a column for the degrees of freedom. Tell how many df there are for each of the following:<\/p>\n
df Time ________________<\/p>\n
df Treatment _____________<\/p>\n
df Interaction ____________<\/p>\n
df Within______________<\/p>\n
df Total___________<\/p>\n
Notice that the results table (source table) from Excel gives the three values of F \u2013 one each for the main effect of time, the main effect of treatment and the interaction of treatment X time. For each, report the calculated value of F, it\u2019s associated p-value, and the critical value of F for the stated degrees of freedom. Then determine if each effect is statistically significant.<\/p>\n
Effect The calculated value of F P-value Critical Value of F<\/p>\n
(F crit) Is this result statistically significant? (yes or no)<\/p>\n
Time (\u201cSample\u201d) Treatment (\u201cColumns\u201d) Interaction For any statistically significant effect, write the results in APA format. Remember to include both values of df in parenthesis.<\/p>\n
In one or two sentences, describe the results of the study. <\/p>\n
Explain how the graph below (created from the data) illustrates an interaction effect.<\/p>\n
Copy of Excel results:<\/p>\n","protected":false},"excerpt":{"rendered":"
Calculation Assignment 2-Way ANOVA Researchers were interested in whether a cognitive-behavioral group therapy intervention would reduce symptoms of depression among<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-52893","post","type-post","status-publish","format-standard","hentry"],"yoast_head":"\n