Excel's _____ function can be used to compute the variance of a ...

[meagbuch]

Excel's _____ function can be used to compute the variance of a discrete random variable.
 a. SUMPRODUCT
  b. AVERAGE
  c. MEDIAN
  d. VAR

Question 2

A student believes that the average grade on the statistics final examination was 87 . A sample of 36 past final examinations was taken. The average grade in the sample was 83.96 with a standard deviation of 12.
 a. State the null and alternative hypotheses.
  b. Using the critical value approach, test the hypotheses at the 5 level of significance.
  c. Using the p-value approach, test the hypotheses at the 5 level of significance.

[ntsoane kedibone]

Answer to Question 1

a

Answer to Question 2

a. H0:  = 87
Ha:   87
b. test statistic t = -1.52, critical t = 2.03; do not reject H0
c. p-value is between .1 and .2; therefore, do not reject H0

[meagbuch]

TYSM

[dantucker]

Thanks for the timely response, appreciate it