Question

Be sure to do your computations using Excel. Do not do computations using Table A, Table C, or on a calculator and then type the answers into Excel.

1. 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?

USING EXCEL PLEASE

Answer 1

From the data given problem.. we had first written the null and alternative hypothesis for the given problem after that we found the t-statistic using the formula. From the t-statistic value we had found the p-value for the t-statistic and written whether the given tCRIT is 1.679 and hence cannot reject the null hypothesis.