You should clearly label each part of the problems with (a), (b), etc., and ever

Question

You should clearly label each part of the problems with (a), (b), etc., and every computation should be labeled. For example, in the cell next to the mean of the data, you should have typed the word mean or average. Be sure to do your computations using Excel. Do not do computations using Tables A or C or on a calculator and then type the answers into Excel. I WANT THE ANSWER TO BE IN EXCEL FORMAT. (WHAT FORMULAS AND WHAT NUMBERS). <<<<< FOCUS HERE<<<<<<<<

2. Researchers did a study to compare how much men and women talk because it is commonly thought that women talk more then men. The study collected data from a simple random sample of women and a simple random sample of men. For each individual in these samples the researchers gave the estimated number of words spoken by her/him in a day. The data is in the accompanying file.

(a) (4 points) Do the data provide good evidence that women talk more than men, on average? State the null and alternative hypotheses relative to this question.

(b) (4 points) Find the t test statistic.

(c) (4 points) What is the P-value for your t?

(d) (4 points) Do the data support the researchers idea?

Sex Words F 15357 F 13618 F 9783 F 26451 F 12151 F 8391 F 19763 F 25246 F 8427 F 6998 F 24876 F 6272 F 10047 F 15569 F 39681 F 23079 F 24814 F 19287 F 10351 F 8866 F 10827 F 12584 F 12764 F 19086 F 26852 F 17639 F 16616 M 28408 M 10084 M 15931 M 21688 M 37786 M 10575 M 12880 M 11071 M 17799 M 13182 M 8918 M 6495 M 8153 M 7015 M 4429 M 10054 M 3998 M 12639 M 10974 M 5255

Explanation / Answer

a)

H0: 1 – 2 0

H1: 1 – 2 > 0

b)

Assuming population variances are equal, we would have to calculate pooled-variance t-Test

Sp^2= (n1-1)S1^2+(n2-1)S2^2/(n1-1)+(n2-1)

         = (27-1)*7914.35^2+(20-1)*8342.47^2/26+19

         = 65575519.2637037

tSTAT=(X1-X2)-(µ1-µ2)/Sp^2(1/n1+1/n2)

       =(16496.11-12866.7)-0/65575519.2637037(1/27+1/20)

       =1.519

c)

The P-Value is .067879.

The result is not significant at p < .05.

d)

tCRIT is 1.679 and hence cannot reject the null hypothesis.

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

---

---

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