Descriptive Statistics - Make a Frequency Distribution with 5 classes

profileJayLQue
StudentAnswerSheetMath201D03SP21.xlsx

Week 3

Age Gender For the following questions, use only the "age" column:
47 F
60 F Points Age Frequency Distribution: Class Width
43 M
18 F Class Limits Midpoint Freq. Relative Frequency Cumulative Relative Freq
37 F Low High
31 M Limits 2
31 F Freq. 2
18 M Mid. 2
27 F RF 2
58 M CF 1
19 M
41 F 2 Mean *Round to two decimals
54 M 2 Median *Round to one decimal
42 F 2 Sample Standard deviation: *Round to two decimals
26 M 2 Q1 *Round to one decimal
26 F 2 Q3 *Round to one decimal
36 M
38 F
40 M Ogive: 3 Ogive: Polygon:
21 F Polygon 3
44 F
35 F
25 F
33 M Total: 25
23 M
28 M
22 F

Week 5

Note: The goal of the project is to practice making a confidence interval for a mean and proportion with real data. Do not worry about failed assumptions tests and do not make corrections for small sample size. Use primary methods described in text and used on homework.
Age Gender Points 95% Confidence Interval for Average Age of Online College Students:
47 F
60 F Sample Mean: 0 Note: Calculation cells should list the numbers and operations used to get your answers. Do not put the generic formula and show all calculation steps.
43 M Sample St. Dev: 0 Normal Distribution
18 F 1 Sample Size: T-Distribution
37 F
31 M 2 Distribution:
31 F
18 M 2 Critical Value: *2 decimals
27 F
58 M 2 Margin of Error: *2 decimals Calculation:
19 M 1 Lower Bound: *2 decimals Calculation:
41 F 1 Upper Bound: *2 decimals Calculation:
54 M
42 F Interpret (context)
26 M 2
26 F
36 M 95% Confidence Interval for Proportion of Male Online College Students:
38 F
40 M 1 Sample Size:
21 F 1 Number of Males:
44 F 2 Male Proportion: Female Proportion *4 decimals
35 F
25 F 2 Distribution:
33 M
23 M 2 Critical Value: *2 decimals
28 M
22 F 2 Margin of Error: *4 decimals Calculation:
1 Lower Bound: *4 decimals Calculation:
1 Upper Bound: *4 decimals Calculation:
Interpret (context)
2
25 Total Points

Week 6

Note: The goal of the project is to practice conducting a hypothesis test for a mean and proportion with real data. Do not worry about failed assumptions tests. Use primary methods described in text and used on homework.
For the following two hypothesis tests, use alpha = .05
Points Claim: The average age of online students is 32 years old. Can you prove it is not?
Normal Distribution
1 Ho: Note: Calculation cells should list the numbers and operations used to get your answers. Do not put the generic formula and show all calculation steps. T-Distribution
2 Ha:
Sample mean: 0
Sample St. Dev: 0
2 Distribution:
Reject Ho
2 Test Statistic: *2 decimals Calculation: Fail to Reject Ho
2 p-value: *4 decimals
1 Decision:
2 Interpretation: (context)
Claim: The proportion of males in online classes is 35%. Can you prove it is not?
1 Ho:
2 Ha:
Sample Proportion Males 0 Sample Proportion Females 0
2 Distribution:
3 Test Statistic: *2 decimals Calculation:
2 p-value: *4 decimals
1 Decision:
2 Interpretation: (context)
25 Total Points