Excel to Conduct a t-test for Two Samples - Statistics HW Help

Over the last five years statistics teachers have notice a difference in grades for day and night class students. In an attempt to analyze what the differences are and determine the cause two random samples have been taken. Your tasks are to determine if the variance of the populations are equal by running an F Test and then using the appropriate T test given the information from the F test determine, if the night class has a lower mean than the day class.

Using Excel Data Analysis and Word, write a case study. (Must be typed, single space, include data output from excel) After running your excel data you must interpret the analysis.

You report should include an introduction stating what you are trying to determine and why. You should then run descriptive statistics and state what you expect to be the outcome of your hypotheses. Then state your hypotheses using statistical symbols and discuss the data from excel with appropriate critical value rejection rule and p values rejection rules conclude for both p-value and critical value what you find in each situation (Not just means are not equal). The report should be in narrative paragraph form with use of headings and conclusions about what the data tells you.

Solution:

Our purpose is to study the difference observed in grades for day and night class students. The ultimate goal is to compare the means of both populations (day and night students). Since the population variances are unknown, we need first to test for equality of the variances. The outcome of such test will determine the statistics we will use to compare the means.

We select a sample from both populations: