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

This final submission should summarize your entire project.The project should include the following:? Paragraph 1:o Brief summary of the U.S. News Data: The Average Online Bachelor’s Student article, including the source? A direct link to this article is located in the Learn section of Module 7: Week 7 entitled Read: U.S. News Data: The Average Online Bachelor’s Student.o Define the population, sample, and statistic for the study o Statement of the two claims in the article that were tested in this projecto Null and alternative hypothesis for both tests run for this project (in words)Paragraph 2 (address the claim about the mean): o Summary of sample statistics (mean, standard deviation, median, quartiles, sample size)o Confidence interval, along with interpretation of the confidence intervalo Description of hypothesis test (alpha, test statistic, p-value, conclusion, interpretation)Paragraph 3 (address the claim about the proportion):o Summary of sample statistics (sample size, successes, proportion)o Confidence interval, along with interpretation of the confidence intervalo Description of hypothesis test (alpha, test statistic, p-value, conclusion,

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:

GRADING

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

Help for this spreadsheet

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.

• Your data is already copied into columns A

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

included on this page under the headers

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

Grading:

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

Help for this spreadsheet

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

your answers. Do not just put the general

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?

• Your data for Columns A and B will link from

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

Grading:

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