Please help solve. I have attached the data. Use a test size of 5% for all hypothesis tests.

1.An industrial psychologist wishes to study the effects of motivation on sales in a particular firm.Of 24 new salespersons, 12 are paid an hourly rate, and 12 are paid a commission.The 24 individuals are randomly assigned to the two groups.The first month sales generated by individuals in the two groups (in thousands of dollars) are reported in the data file SALESCOMP.xls.

A.Report the sample average and sample variance for each group.

B.Test the hypothesis that the population variances of the two groups are equal.In this step report:the null and the alternative hypothesis; the test statistic and p-value; provide a statement of whether you reject or fail to reject the null; and write concise test conclusion.

C.Test the hypothesis that the population means of the two groups are equal.Provide:a statement of whether you are running a pooled variance or a separate variance t-test; the null and the alternative hypothesis; the test statistic and p-value; provide a statement of whether you reject or fail to reject the null; and write concise test conclusion.