Question: can someone please list the steps / formula in excel? Trevor is interested in purchasing the local hardware/sporting goods store in the small town of

can someone please list the steps / formula in excel?

Trevor is interested in purchasing the local hardware/sporting goods store in the small town of Dove Creek, Montana. After examining accounting records for the past several years, he found that the store has been grossing over $850 per day about 55% of the business days it is open. Estimate the probability that the store will gross over $850 for the following. (Round your answers to three decimal places.)

(a) at least 3 out of 5 business days

(b) at least 6 out of 10 business days

(c) fewer than 5 out of 10 business days

(d) fewer than 6 out of the next 20 business days

(e) more than 17 out of the next 20 business days

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Q:

Trevor is interested in purchasing the local hardware/sporting goods store in the small town of Dove Creek, Montana. After examining accounting records for the past several years, he found that the...

Q:

homework please help stats \\l l Trevor is interested in purchasing the local hardware/sporting goods store in the small town of Dove Creek, Montana. After examining accounting records for the past...

Q:

Hardware Store: Income Trevor is interested in purchasing the local hardware/sporting goods store in the small town of Dove Creek, Montana. After examining accounting records for the past several...

Q:

Trevor is interested in purchasing the local hardware/sporting goods store in the small town of Dove Creek, Montana. After examining accounting records for the past several years, he found that the...

Q:

MY NOTES ASK YOUR TEACHER PRACTICE ANOTHER A research team conducted a study showing that approximately 25% of all businessmen who wear ties wear them so tightly that they actually reduce blood flow...

Q:

Trevor is interested in purchasing the local hardware/sporting goods store in the small town of Dove Creek, Montana. After examining accounting records for the past several years, he found that the...

Q:

10. [-/0.24 Points] DETAILS BBUNDERSTAT12 5.2.022.MI.S. MY NOTES ASK YOUR TEACHER PRACTICE ANOTHER Trevor is interested in purchasing the local hardware/sporting goods store in the small town of Dove...

Q:

Probability & statistics /2 Points] DETAILS BBUNDERSTAT12 5.2.019.MI.S. MY NOTES ASK YOUR TEACHER PRACTICE ANOTHER Sociologists say that 85% of married women claim that their husband's mother is the...

Q:

Trevor is interested in purchasing the local hardware/sporting goods store in the small town of Dove Creek, Montana. After examining accounting records for the past several years, he found that the...

Q:

10. [-/0.24 Points] DETAILS BBUNDERSTAT12 5.2.022.MI.S. MY NOTES ASK YOUR TEACHER PRACTICE ANOTHER Trevor is interested in purchasing the local hardware/sporting goods store in the small town of Dove...

Q:

What are the steps for constructing a financial plan? What is a pro forma balance sheet or cash budget? How do they differ, and what role do they play in the construction of financial plans?

Q:

Suppose that bread and housing must be paid for in three ways: money, ration coupons, and time spent waiting. To get, for example, a loaf of bread one must pay $10, hand over 3 ration coupons, and...

Q:

favor resumir Ajuste de los ndices Los ndices suelen ajustarse cuando se producen variaciones en las cotizaciones, que se deben a hechos que no son motivados por las propias fuerzas del mercado....

Q:

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...