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

Author Question: When using Excel's BINOM.DIST function, one should choose TRUE for the fourth input if _____. a. a ... (Read 90 times)

Pineappleeh

  • Hero Member
  • *****
  • Posts: 585
When using Excel's BINOM.DIST function, one should choose TRUE for the fourth input if _____.
 a. a probability is desired
  b. a cumulative probability is desired
  c. the expected value is desired
  d. the correct answer is desired

Question 2

A sample of 64 account balances from a credit company showed an average daily balance of 1040 . The standard deviation of the population is known to be 200 . We are interested in determining if the mean of all account balances (i.e., population mean) is significantly different from 1000.
 a. Develop the appropriate hypotheses for this problem.
  b. Compute the test statistic.
  c. Compute the p-value.
  d. Using the p-value approach and  = .05, test the above hypotheses. What is your conclusion?
  e. Using the critical value approach and  = .05, test the hypotheses. What is your conclusion?



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

zenzy

  • Sr. Member
  • ****
  • Posts: 336
Answer to Question 1

b

Answer to Question 2

a. H0:  = 1000
Ha:   1000
b. 1.60
c. .1096
d. p-value = .1096 >  = .05 . The null hypothesis is not rejected; no evidence to show that the mean is significantly different from 1000.
e. z = 1.60 is between -1.96 and 1.96; the null hypothesis cannot be rejected; there is no evidence that the mean is significantly different from 1000.




Pineappleeh

  • Member
  • Posts: 585
Reply 2 on: Jun 24, 2018
Excellent


chereeb

  • Member
  • Posts: 326
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

 

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?

Serum cholesterol testing in adults is recommended every 1 to 5 years. People with diabetes and a family history of high cholesterol should be tested even more frequently.

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?

During pregnancy, a woman is more likely to experience bleeding gums and nosebleeds caused by hormonal changes that increase blood flow to the mouth and nose.

Did you know?

Stroke kills people from all ethnic backgrounds, but the people at highest risk for fatal strokes are: black men, black women, Asian men, white men, and white women.

For a complete list of videos, visit our video library