This topic contains a solution. Click here to go to the answer

Author Question: Excel's _____ function can be used to compute the variance of a discrete random variable. a. ... (Read 138 times)

meagbuch

  • Hero Member
  • *****
  • Posts: 568
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.



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

ntsoane kedibone

  • Sr. Member
  • ****
  • Posts: 333
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

  • Member
  • Posts: 568
Reply 2 on: Jun 24, 2018
YES! Correct, THANKS for helping me on my review


raenoj

  • Member
  • Posts: 340
Reply 3 on: Yesterday
Great answer, keep it coming :)

 

Did you know?

Hyperthyroidism leads to an increased rate of metabolism and affects about 1% of women but only 0.1% of men. For most people, this increased metabolic rate causes the thyroid gland to become enlarged (known as a goiter).

Did you know?

Approximately 15–25% of recognized pregnancies end in miscarriage. However, many miscarriages often occur before a woman even knows she is pregnant.

Did you know?

In the United States, an estimated 50 million unnecessary antibiotics are prescribed for viral respiratory infections.

Did you know?

Eating carrots will improve your eyesight. Carrots are high in vitamin A (retinol), which is essential for good vision. It can also be found in milk, cheese, egg yolks, and liver.

Did you know?

In 1886, William Bates reported on the discovery of a substance produced by the adrenal gland that turned out to be epinephrine (adrenaline). In 1904, this drug was first artificially synthesized by Friedrich Stolz.

For a complete list of videos, visit our video library