Question: Please show step by step or formula in excel. Suppose that the average amount of money students at Bellevue University spend on gas monthly is

Please show step by step or formula in excel.

Suppose that the average amount of money students at Bellevue University spend on gas monthly is $32.50 per month with a standard deviation of $4.64 per month. If I take a sample of 52 BU students, what is the probability that the mean amount of their monthly gas spending is greater than $36.00?

Explain in words how you used Excel to find both the z-score and probability (or show the formulas), then attach a screen shot of the output in Excel.

For your second post, find theprobability that the mean amount of their monthly phone bill differs from the expected mean by less than $2.00, again showing your output and explaining your solution.

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!

Suppose that the average cell phone bill at Bellevue University is $38.90 per month with a standard deviation of $3.64 per month. If I take a sample of 44 BU students, what is the probability that...

IOE 419 Mark S. Daskin Service Operations Management IOE Department Winter, 2017 University of Michigan Problem set 4 DUE: MONDAY - February 20, 2017 Points: 100 points total Problem 1: Babette has...

1 (1 point) You own a small storefront retail business and are interested in determining the average amount of money a typical customer spends per visit to your store. You take a random sample over...

1. The principal P is borrowed and the loan's future value A at time t is given. Determine the loan's simple interest rate r to the nearest tenth of a percent. P=2000.00 A=2042.50 t=3 months 2. A...

Assignment 4A. Theory Component Show your work for this component. Where relevant, keep all your middle work as well as your final answer to a minimum of four decimals, unless otherwise stated. For...

need some one good at English paraphrase for me this paper! must be on your own word! Introduction: My top 3 in assignment one are: Financial Analyst, Logistician, and Personal Financial Advisor; and...

On December 31, 20x0 a publicly accountable entity leased an asset from Nguyen Leasing Corporation. Details on the lease are as follows: Fair value of asset Lease term Economic (and useful) life of...

River Rock, Inc. has just paid an annual dividend of $2.80. The company has increased its dividend by 2.5 percent per year for the past 10 years and expects to continue to do so. What will be the...

12. LO.3 Hugo dies in 2012, leaving a large estate. Among other provisions in his will are charitable and marital bequests. When Hugos executor elects the alternate valuation date, it has the effect...

Picture 1 Picture 2 Ques- Picture 1 is the question and picture 2 is the answer sheet that is to be filled after reviewing picture 1. Calculate the MRP and fill it in the above-mentioned table....

3. Give three examples from your own everyday life where a piece of communi-cation is structured into a linear sequence, i.e. B is the cause of A.

2. What information is conveyed through a particular type of metaphor? The answer to the question gives us insight into what code the person using the metaphor uses, and thus an insight into how...

2. Give six examples that silence (not saying anything) or not responding can be very informative to the other party.