Midterm Examination Simulation

Question 1

Fixed Value/ known mean value

Answer 1

One Sample T-test

Question 2

It has two Dependent Variables

Answer 2

Period Sample Mean

Question 3

Mean

Answer 3

=AVE(FROM:TO)

example: =AVE(A2:A13)

Question 4

STANDARD DEVIATION

Answer 4

=STDEV(FROM:TO)

example: =STDEV(A2:A13)

Question 5

COUNT

Answer 5

=COUNT(FROM:TO)

example: =COUNT(A2:A13)

Question 6

STANDARD ERROR OF MEAN SE

Answer 6

VALUE OF SD/SQRT(VALUE OF COUNT)

example: =E3/SQRT(E4)

Question 7

DEGREES OF FREEDOM

Answer 7

TOTAL ITEMS - 1

get the value of count then subtract it to 1

Question 8

HYPOTHESIS MEAN

Answer 8

Given

Fixed Value

Question 9

T STATISTICS

Answer 9

=(VALUE OF MEAN-VALUE OF HYPOTHESIS MEAN)/STANDARD ERROR OF MEAN SE

example: =(E2-E7)/E5

Question 10

P-VALUE

Answer 10

=TDIST(T STATISTICS, HYPOTHESIS MEAN, 1)

=TDIST(E9,E7,1)