Math 1070 Excel Project Part I and 2

| August 30, 2017

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:

Get a 30 % discount on an order above $ 100
Use the following coupon code:
RESEARCH
Order your essay today and save 30% with the discount code: RESEARCHOrder Now
Positive SSL