Statistical Power of this test?: Can you please show me how to do this in excel?

Question

Statistical Power of this test?:

Can you please show me how to do this in excel? Thank you!

Starved Fed 1.9 1.5 2.1 1.7 3.8 2.4 9.0 3.6 9.6 5.7 13.0 22.6 14.7 22.8 17.9 39.0 21.7 54.4 29.0 72.1 62.3 73.6 79.5 88.9 Do the appropriate test to determine if starved females mate faster than fed females.   Obviously, you must consider "tailedness" when formulating your hypotheses and making your conclusions. Make no assumptions in this test and show all work. Answers: Ho: Ha: test statistic: df: Exact Prob. of test statistic: Conclusion relative to the hypothesis: What is the

Statistical Power of this test?:

Can you please show me how to do this in excel? Thank you!

%

Explanation / Answer

In excel

Go to

data analysis--->t test:Two-sample assuming unequal variances

in variable 1 select starved column

in variable 2 select Fed column

high light labels

alpha=0.05

click ok.

Output:

ANswers:

Null hypothesis:

Ho:(starved)=(fed)

Alternative Hypothesis:

H1:(starved)>(fed)

right tail t test

alpha=0.05

test statistic:

t=-1.79

degrees of freedom=18

Exact Prob. of test statistic:0.044

P<0.05

Conclusion relative to the hypothesis: Reject nUll hypothesis

There is sufficiient evidence at 5% level of significance to conclude that   starved females mate faster than fed females

t-Test: Two-Sample Assuming Unequal Variances starved Fed Mean 16.81818 35.98462 Variance 298.2936 1131.045 Observations 11 13 Hypothesized Mean Difference 0 df 18 t Stat -1.79415 P(T<=t) one-tail 0.044802 t Critical one-tail 1.734064 P(T<=t) two-tail 0.089604 t Critical two-tail 2.100922

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---