sample t-test NO PLAGERISM

For this assignment, use data from W1 Midweek Assignment.ATTACHED

Using Microsoft Excel and following the instructions given in your lecture, compute a one-sample t-test comparing the age of your sample to the age of the general population of college students in traditional on-ground universities. Assume the population mean is 21.

Move your Microsoft Excel output into a Microsoft Word document.

1. Write 1 paragraph to explain how you located and determined the critical value of t, and how you determined whether your obtained t-statistic was significant.
2. Write a 1-paragraph, APA-formatted interpretation of the results modeled on the example given in your lecture.

2

>Sheet

, Female=1)

= (1= freshman, 2=sophomore,

= junior,

= senior

Year in college

0

1

18 0

1

0

1

18 0

1

0

1

20 1

.4

1

19 1

1

18 1

1

18 1

1

1 63 1

19 0

2

20 0

2

20 0

2

21 0

2

19 0

2

20 1

2

19 1

2

20 1

2

19 1

2

20 1

2

0

3

21 0

3

20 0

3

20 0 68 3

22 0 68.1 3

20 1 63.8 3

21 1 63.6 3

21 1 63.9 3

20 1 64 3

21 1

3

22 0

4

23 0

4

23 0

4

21 0

4

21 0

4

22 1 64.3 4

21 1

4

21 1

4

23 1 64.3 4

22 1

4

Order an Essay Now & Get These Features For Free:

Turnitin Report

Formatting

Title Page

Citation

Outline

Place an Order