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 117 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


emsimon14

  • Member
  • Posts: 344
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

 

Did you know?

Women are two-thirds more likely than men to develop irritable bowel syndrome. This may be attributable to hormonal changes related to their menstrual cycles.

Did you know?

A good example of polar molecules can be understood when trying to make a cake. If water and oil are required, they will not mix together. If you put them into a measuring cup, the oil will rise to the top while the water remains on the bottom.

Did you know?

When intravenous medications are involved in adverse drug events, their harmful effects may occur more rapidly, and be more severe than errors with oral medications. This is due to the direct administration into the bloodstream.

Did you know?

A headache when you wake up in the morning is indicative of sinusitis. Other symptoms of sinusitis can include fever, weakness, tiredness, a cough that may be more severe at night, and a runny nose or nasal congestion.

Did you know?

There are actually 60 minerals, 16 vitamins, 12 essential amino acids, and three essential fatty acids that your body needs every day.

For a complete list of videos, visit our video library