# BUSI 230 LU Students Pursuing Their Bachelors Online Report

#### Project:

Submit a final report  based on your findings and submissions from Parts 1 – 4.

https://www.usnews.com/higher-education/online-education/articles/2017-04-04/us-news-data-the-average-online-bachelors-student

Age
Gender
23 F
40 M
21 M
28 M
24 M
19 M
31 F
46 M
19 M
42 F
46 F
19 F
43 F
22 M
22 F
28 M
20 M
19 M
For the following questions, use only the “Age” column:
Limits
Freq.
Mid.
RF
CF
Points
Age Frequency Distribution:
1
1
1
1
1
Class Limits
Low
High
Midpoint
18
23
21
24
29
27
30
35
33
36
41
39
42
47
45
2
2
2
2
2
20 M
39 M
18 M
18 M
Ogive
Polygon
12
3
1
2
4
Mean
27.59 *Round to two decimals
Median
22.5 *Round to one decimal
Sample Standard deviation:
10.13
Q1
19 *Round to one decimal
Q3
39 *Round to one decimal
Ogive:
5
5
Mid pts
Total:
Freq.
25
(cumulative relative frequency gr
Cum rel
21
0.5455
27
0.6819
33
0.7274
39
0.8183
45
1
Ages of class
1.5
1
0.5
0
0
10
20
30
Series1
40
50
ons, use only the “Age” column:
Class Width
6
Relative
Cumulative
Frequency
Relative Freq
0.5455
0.5455
0.1364
0.6819
0.0455
0.7274
0.0909
0.8183
0.1818
1.0000
*Round to two decimals
• Review 2.2, 3.1 – 3.3 of your text.
and B.
• Only cells in yellow need to be completed.
• Choose a class width according to the
following equation:
CLASS WIDTH = (MAX VALUE – MIN VALUE)/#
of Classes (5)
• The ogive and polygon graphs need to be
below. Please do not put them on a separate
Polygon:
cumulative relative frequency graph)
Mid pts
(graph of actual frequencies)
Freq
21
27
33
39
45
12
3
1
2
4
FFff Ffff
14
12
10
8
6
4
2
0
0
10
20
30
Series1
40
50
Age
Gender
23 F
40 M
21 M
28 M
24 M
19 M
31 F
46 M
19 M
42 F
46 F
19 F
43 F
22 M
22 F
28 M
20 M
19 M
20 M
39 M
18 M
18 M
Points
95% Confidence Interval for Average Age of Online College Students:
1
Sample Mean:
Sample St. Dev:
Sample Size:
27.59
10.13
22
2
Distribution:
T-Distribution
2
Critical Value:
2.08 *2 decimals
2
1
1
Margin of Error:
Lower Bound:
Upper Bound:
4.49 *2 decimals Show Your Calculation:
23.1 *2 decimals Show Your Calculation:
32.08 *2 decimals Show Your Calculation:
2
E=2.080*10.13/sqrt.22
LB=27.59-4.49
UP=27.59+4.49
95% confidence that the average age of all online college students is somewhere between 23 and
Interpret 32.
95% Confidence Interval for Proportion of Male Online College Students:
1
1
2
Sample Size:
Number of Males:
Male Proportion:
2
Distribution:
Normal Distribution
2
Critical Value:
1.96 *2 decimals
2
1
1
Margin of Error:
Lower Bound:
Upper Bound:
2
22
15
0.68
Female Proportion
0.1949 *4 decimals Show Your Calculation:
0.4851 *4 decimals Show Your Calculation:
0.8749 *4 decimals Show Your Calculation:
0.32 *4 decimals
E=1.96*sqrt(0.68*0.32)/22
LB=0.68-0.1949
UB=0.68+0.1949
95% confidence that the average proportion of males in online classes is between 0.4851. And
Interpret 0.8749.
25
Total Points
80*10.13/sqrt.22
B=27.59-4.49
P=27.59+4.49
where between 23 and
*4 decimals
*sqrt(0.68*0.32)/22
B=0.68-0.1949
B=0.68+0.1949
tween 0.4851. And
• Review 8.2 of your text as well as the Project Video Helps tab below for the upper
confidence interval calculation.
• Review 8.3 of your text as well as the Project Video Helps tab below for the lower
confidence interval calculation.
• “Show Your Calculation” – these cells should
list the numbers and operations used to get
formula and show all calculation steps.
• For the “Interpret” text, what can we
conclude about the population mean age and
the population average male proportion of
online students with respect to these bounds?
the Week 3 tab on this spreadsheet – no need
to re-input!
• The green cells (G3 and G4) will link from the
Week 3 tab on this spreadsheet.
• Only cells that are yellow need to be
completed.
• Please note rounding for calculations!
For the following two hypothesis tests, use the alpha = .05 level of confidence
Points
1
2
Claim: The average age of online students is 32 years old.
Ho:
Ha:
U=32
U is two-tailed 0.35
Sample mean:
Sample St. Dev:
27.59
10.13
2
Distribution:
T-Distribution
2
2
1
Test Statistic:
p-value:
Decision:
-2.04 *2 decimals Show Your Calculation:
0.0539 *4 decimals
0.0539=0.05
2
Interpretation:
We do not reject.The result is not statistically significant.
27.59-32/10.13/sqrt(
Claim: The proportion of males in online classes is 35%
1
2
Ho:
Ha:
U=0.35
U is two-tailed 0.35
Sample Proportion Males
0.68
Sample Proportion Females
2
Distribution:
3
2
1
Test Statistic:
p-value:
Decision:
3.26 *2 decimals Show Your Calculation:
0.0011 *4 decimals
0.0011

Order your essay today and save 25% with the discount code: GREEN

## Order a unique copy of this paper

600 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
\$26