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
Order Essay

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

Calculate the price of your paper

Total price:$26
Our features

We've got everything to become your favourite writing service

Need a better grade?
We've got you covered.

Order your paper