Math 1070 Excel Project Part I and 2

QUESTION

Reminder: The goal of this project is to get you comfortable with the use of Excel; to that end, any calculations, even minor ones, not done using Excel, could result in point deductions or possibly a grade of ‘0’ for this assignment. (You should have absolutely no need for a calculator on this assignment). Cells are formatted to show 2 decimal places … but you should type formulas (not numbers) Data Set The data in the columns below are counts of the number of words spoken in a day by male (M) and female (F) subjects in independent simple random samples of men and women ranging in age from 18 to 29. Parts 1-3 will relate to one or both of the data in these columns: Part 1: Descriptive Statistics a. In the spaces below, provide the mean, variance, standard deviation and range for the sample of the number of words spoken in a day by males and females: b. Provide the 5-Number Summary for the sample data of the number of words spoken in a day by males and females in the boxes below: Part 2: Hypothesis Test for Means (1-Sample) Test the claim that the mean number of words spoken by women (in between the ages of 18 to 29) is less than 16000 per day. Use a significance level of 0.05:

ANSWER:

REQUEST HELP FROM A TUTOR