Business Statistics - EXCEL

1) Need to create a statistical table & chart in EXCEL with corresponding verbiage that describes them - with at least 5 different visuals with verbiage. See the attached example [You may need PHStat2]. 2) Need a single word file containing the excel output and written descriptions, and the verbiage that would go with descriptives (NO hypothesis testing).

Probability

Suppose you have 6 nickels, 4 dimes, and 2 quarters in your pocket. If you draw a coin randomly from your pocket, what is the probability that a. You will draw a dime? b. You will draw a half-dollar? c. You will draw a quarter?

Rolling a pair of dices

You are rolling a pair of dices, one red and one green. What is the probability of the following outcome? a. The sum of the two numbers you roll from the dice is 10? b. The sum of the two numbers you roll is 8? c. The sum of the two numbers you roll is 3? Need to show how you came up with the answer.

Business Statistics using PHSTAT add-in

See attached: Must use Excel with the PHSTAT add-in, and then paste all into MS Word. The manager of a paint supply store wants to determine whether the amount of paint contained in 1-gallon cans purchased from a nationally known manufacturer actually averages 1gallon. It is known from the manufacturer's specifications that the standard deviation of the amount of paint is equal to .02 gallon. A random sample of 50 cans is selected, and the mean of the amount of paint per 1-gallon can is found to be .995 gallon. See attached file for full problem description. Must use Excel with the PHSTAT add-in and then paste all into MS Word Template Problem #1 The manager of a paint supp... click for more

Drawing cards

Pretend you are drawing cards without replacement from the infamous Iraq's most wanted deck issued by the us military. If you are drawing from the full deck of 55 cards, what are the folloing probabilities: a. You draw a card that is not Saddam Hussein? b. You draw two cards, which end up being Saddam Hussein and another one with his cousin "Chemical Ali"? c. You draw 14 cards and not one of them is Saddam Hussein. Could you please show me how you figured out these answers out so that I can proceed with the other questions my teacher has given me.