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 109 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
Thanks for the timely response, appreciate it


helenmarkerine

  • Member
  • Posts: 324
Reply 3 on: Yesterday
:D TYSM

 

Did you know?

More than 34,000 trademarked medication names and more than 10,000 generic medication names are in use in the United States.

Did you know?

Although not all of the following muscle groups are commonly used, intramuscular injections may be given into the abdominals, biceps, calves, deltoids, gluteals, laterals, pectorals, quadriceps, trapezoids, and triceps.

Did you know?

There used to be a metric calendar, as well as metric clocks. The metric calendar, or "French Republican Calendar" divided the year into 12 months, but each month was divided into three 10-day weeks. Each day had 10 decimal hours. Each hour had 100 decimal minutes. Due to lack of popularity, the metric clocks and calendars were ended in 1795, three years after they had been first marketed.

Did you know?

Vampire bats have a natural anticoagulant in their saliva that permits continuous bleeding after they painlessly open a wound with their incisors. This capillary blood does not cause any significant blood loss to their victims.

Did you know?

Patients should never assume they are being given the appropriate drugs. They should make sure they know which drugs are being prescribed, and always double-check that the drugs received match the prescription.

For a complete list of videos, visit our video library