This question has been perviously asked and answered, in which I do not understa
ID: 3170654 • Letter: T
Question
This question has been perviously asked and answered, in which I do not understand. Can you please answer in Excel, with the possibility of screen shots.
Some researchers contend that anxiety is detrimental to performance, while others argue that anxiety actually enhances performance. To answer this question once and for all, Dr. Rylee has each subject in an experiment work on crossword puzzles before and after being exposed to an anxiety-inducing stimulus (a segment from a Friday the 13th movie). She measured the number of words completed by each subject. The data from her subjects are presented below. Using = .05, test the null hypothesis that the two groups do not differ.
Provide the following in your answer:
The test you will run:
The null and research hypothesis
The test results:
Your interpretation of the results
No Anxiety
Anxiety
Pamela
23
14
Scott
19
11
Megan
21
10
Andrea
23
11
No Anxiety
Anxiety
Pamela
23
14
Scott
19
11
Megan
21
10
Andrea
23
11
Explanation / Answer
here we will apply chi test for independence.
null hypothesis: two groups do not differ.
alternate :hypothesis: they differ
from above degree of freedom =n-1=3
for 3 degree of freedom and above chi square test stat 31.196 ; p value =0.0000
as p value is less then 0.05 level, we reject null hypothesis.
Observed O pamela scott megan andrea Total no anxiety 173 158 95 53 479 anxiety 162 126 110 123 521 Total 335 284 205 176 1000 Expected E=rowtotal*column total/grand total pamela scott megan andrea Total no anxiety 160.465 136.036 98.195 84.304 479 anxiety 174.535 147.964 106.805 91.696 521 Total 335 284 205 176 1000 chi square =(O-E)^2/E pamela scott megan andrea Total no anxiety 0.979 3.546 0.104 11.624 16.253 anxiety 0.900 3.260 0.096 10.687 14.943 Total 1.879 6.807 0.200 22.311 31.196Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.