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 66 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
Excellent


kthug

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

 

Did you know?

More than 20 million Americans cite use of marijuana within the past 30 days, according to the National Survey on Drug Use and Health (NSDUH). More than 8 million admit to using it almost every day.

Did you know?

Each year in the United States, there are approximately six million pregnancies. This means that at any one time, about 4% of women in the United States are pregnant.

Did you know?

The most destructive flu epidemic of all times in recorded history occurred in 1918, with approximately 20 million deaths worldwide.

Did you know?

Approximately one in four people diagnosed with diabetes will develop foot problems. Of these, about one-third will require lower extremity amputation.

Did you know?

Sildenafil (Viagra®) has two actions that may be of consequence in patients with heart disease. It can lower the blood pressure, and it can interact with nitrates. It should never be used in patients who are taking nitrates.

For a complete list of videos, visit our video library