Statistics Assignment | Online Assignment

For your research report, I would like you to test the following hypotheses using the Statistics Students Data and Excel’s Data Analysis Tool. Please test the following hypotheses using the α = 0.05 level of significance and assuming equal population variances:
That there is a difference in the number of drinks taken per week by male and female statistics students
That there is a difference in the number of cigarettes smoked per day by male and female statistics students
That there is a difference in the number of hours of sleep per night for male and female statistics students
That there is a difference in the number of hours of exercise per week by male and female statistics students
The assignment should be in the form of a Word or pdf document. For each research question, I expect you to follow the five-step procedure as outlined in class, which includes a clear statement of the conclusion to be drawn from the results of your tests. I also expect you to include the Excel printouts, which means that you have to copy and paste the print-out from Excel to Word. As part of your project, please construct one table that clearly summarizes the results of all four hypothesis test. Part of your grade will be based on professional appearance of the report. Please construct the report as if your next promotion and raise depended on the quality of this report.
Note: This assignment will require you to sort the data by the variable ‘Female=1’ so as to separate observations on male and female students.