Math 201-Statistics project

profileKailanyzi
HypothesisTesting.xlsx

Week 3

Age Gender For the following questions, use only the "age" column:
17 F
17 F Points Age Frequency Distribution: Class Width
18 F Cumulative Relative Freq Midpoint Freq.
18 F Class Limits Midpoint Freq. Relative Frequency Cumulative Relative Freq High
13 0
19 M Low High 24 8 21 8
22 F Limits 2 17 24 21 8 0.38 8 32 11 29 3
23 F Freq. 2 25 32 29 3 0.14 11 40 17 37 6
24 M Mid. 2 33 40 37 6 0.29 17 48 20 45 3
25 F RF 2 41 48 45 3 0.14 20 56 21 53 1
26 F CF 1 49 56 53 1 0.05 21 61 0
27 F 21
35 M 2 Mean 30.67 *Round to two decimals
36 F 2 Median 27 *Round to one decimal
36 F 2 Sample Standard deviation: 10.84 *Round to two decimals
37 F 2 Q1 19 *Round to one decimal
40 M 2 Q3 40 *Round to one decimal
40 F
41 M
46 F Ogive: 3 Ogive: Polygon:
47 M Polygon 3
50 M
644
Total: 25

&"Helvetica Neue,Regular"&12&K000000&P

O-give Chart

Series1 24 32 40 48 56 8 11 17 20 21

Frequency Polygon

Series1 13 21 29 37 45 53 61 0 8 3 6 3 1 0

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:
17 F
17 F Sample Mean: 30.67 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.
18 F Sample St. Dev: 10.84 Normal Distribution
18 F 1 Sample Size: 21 T-Distribution
19 M
22 F 2 Distribution: T-Distribution
23 F
24 M 2 Critical Value: 2.09 *2 decimals
25 F
26 F 2 Margin of Error: 4.93 *2 decimals Calculation: 4.93
27 F 1 Lower Bound: 25.74 *2 decimals Calculation: 25.74
35 M 1 Upper Bound: 35.60 *2 decimals Calculation: 35.60
36 F
36 F Interpret (context) At 95% confidence interval one is confident that the average age of online college students lies within (25.74,35.60) years .
37 F 2
40 M
40 F 95% Confidence Interval for Proportion of Male Online College Students:
41 M
46 F 1 Sample Size: 21
47 M 1 Number of Males: 7
50 M 2 Male Proportion: 0.3333 Female Proportion 0.6667 *4 decimals
644
2 Distribution: Normal Distribution
2 Critical Value: 1.96 *2 decimals
2 Margin of Error: 0.2016 *4 decimals Calculation: 0.2016
1 Lower Bound: 0.1317 *4 decimals Calculation: 0.1317
1 Upper Bound: 0.5350 *4 decimals Calculation: 0.5350
Interpret (context) At 95% confidence interval the true proportion of male online college students lies within (0.1317,0.5350) .
2
25 Total Points

&"Helvetica Neue,Regular"&12&K000000&P

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: 30.67
Sample St. Dev: 10.84
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.3333333333 Sample Proportion Females 0.6666666667
2 Distribution:
3 Test Statistic: *2 decimals Calculation:
2 p-value: *4 decimals
1 Decision:
2 Interpretation: (context)
25 Total Points

&"Helvetica Neue,Regular"&12&K000000&P