ou are interested in purchasing the local florist shop, located next to Vanier College. After examining the accounting records for the past several years, you note that the store has been grossing over $975.00 per day about 65% of the days that it is open. (a) Use the formula for Binomial probabilities to find the probability that the store will gross over $975.00 for exactly 5 of the next 7 business days. What information does this give you about purchasing the store? (b) Use the table of the Binomial Probability Distribution to find the probability that the store will gross over $975.00 for at least 6 of the next 10 business days. How does this probability contribute to your decision about purchasing the store?

A First Course in Probability (10th Edition)
10th Edition
ISBN:9780134753119
Author:Sheldon Ross
Publisher:Sheldon Ross
Chapter1: Combinatorial Analysis
Section: Chapter Questions
Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...
icon
Related questions
Topic Video
Question

You are interested in purchasing the local florist shop, located next to Vanier College. After examining the accounting records for the past several years, you note that the store has been grossing over $975.00 per day about 65% of the days that it is open. (a) Use the formula for Binomial probabilities to find the probability that the store will gross over $975.00 for exactly 5 of the next 7 business days. What information does this give you about purchasing the store? (b) Use the table of the Binomial Probability Distribution to find the probability that the store will gross over $975.00 for at least 6 of the next 10 business days. How does this probability contribute to your decision about purchasing the store? (c) If you collect the store's records for the last 10 business days and find that it had grossed LESS than $975.00 on 7 of the days, would you suspect that the store's financial situation had changed? Use a Binomial probability to justify your answer. (d) Use the Binomial approximation to the Normal distribution to find an estimate for the probability that the store will gross over $975.00 for 18 of the next 25 business days.

Please provide solution in excel with formulas used. Thanks 

Expert Solution
Step 1

Probability homework question answer, step 1, image 1

 

Excel FunctionExcel provides the following functions regarding the binomial distribution: BINOMDIST(x, n, p, cum) where n = the number of trials, p = the probability of success for each trial and cum takes the value TRUE or FALSE.

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Discrete Probability Distributions
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, probability and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
A First Course in Probability (10th Edition)
A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON
A First Course in Probability
A First Course in Probability
Probability
ISBN:
9780321794772
Author:
Sheldon Ross
Publisher:
PEARSON