multiple choice

11/29/2015 Quiz: Quiz 8 --- Hypothesis testing

https://usfca.instructure.com/courses/1554912/quizzes/2291737/take 1/3

Quiz 8 ­­­ Hypothesis testing Started: Nov 2 at 12:56pm

Quiz Instructions

  1 ptsQuestion 1

=(B1­B5)/B7

=B1­B5/B7

=B1­B5/SQRT(B2)

=(B1­B5)/SQRT(B2)

Which formula should be entered in cell B8 to compute the test statistic?

1 ptsQuestion 2

=NORM.S.DIST(B8, TRUE)

=NORM.DIST(B8, B1, B3, TRUE)

What formula should be entered in cell B10 to compute the P­value for a lower­tail test?

11/29/2015 Quiz: Quiz 8 --- Hypothesis testing

https://usfca.instructure.com/courses/1554912/quizzes/2291737/take 2/3

=1­NORM.S.DIST(B8, TRUE)

=1­NORM.DIST(B8, B1, B3, TRUE)

  1 ptsQuestion 3

=SQRT(B4*(1­B4)/B2)

=SQRT(B4*1­B4/B2)

=SQRT(B1*(1­B1)/B2)

=SQRT(B1­B4/B2)

What formula should be entered in cell B6 to compute the standard error?

1 ptsQuestion 4

NORM.S.DIST

NORM.S.INV

T.DIST

NORM.INV

Which Excel function should be used in the computations of P­values in the scenario shown?

11/29/2015 Quiz: Quiz 8 --- Hypothesis testing

https://usfca.instructure.com/courses/1554912/quizzes/2291737/take 3/3

Not saved  

1 ptsQuestion 5

=T.DIST.RT(B8, B2­1)

=T.DIST(B8, B2­1, TRUE)

=T.DIST.2T(B8, B2­1)

=NORM.DIST(B8, TRUE)

Which of the formulas will yield the correct P­value for a lower­tail test in the scenario shown?

Submit Quiz