# sample t-test NO PLAGERISM

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

Don't use plagiarized sources. Get Your Custom Essay on
sample t-test NO PLAGERISM
Just from \$13/Page

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

1

, 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

 sex (Male= 0 Year in college 3 4 Subject ID Number Age Sex Height S1 18 67.2 S2 66.9 S3 20 67.5 S4 66.8 S5 19 67.3 S6 63 S7 63.2 S8 62.8 S9 63.6 S10 21 S11 67.8 S12 68 S13 68.1 S14 67.6 S15 67.9 S16 64 S17 63.9 S18 64.2 S19 64.3 S20 63.8 S21 22 68.3 S22 68.2 S 23 68.5 S24 S25 S26 S27 S28 S29 S30 64.1 S31 69 S32 69.1 S33 69.3 S34 68.8 S35 69.4 S36 S37 65 S38 64.8 S39 S40 64.7

Calculator

Total price:\$26
Our features