Question: How do I create the below? I have prices from 10 stations in my area and I am not sure how or what to use
How do I create the below? I have prices from 10 stations in my area and I am not sure how or what to use for the demand curve.
Identify 10 gas stations in your local area.
Record the price per gallon for each gas station.
Research supply and demand curves for gasoline.
Create an Excel spreadsheet in which you do the following:
Create a supply curve for gasoline.
Create a demand curve for gasoline.
Calculate the average cost of gas in your local area.
Calculate the standard deviation.
Determine whether the prices in your local area are higher or lower than the national average.
Gas prices in Bountiful, Utah August 29, 2016 Zip code 84010 Price per gallon regular
Common cents 2.23
Smiths 2.23
Maverik 2.23
Sinclair 2.23
Ernies 2.25
Chevron 2.25
Sinclair 2.29
Chevron on main 2.41
Costco 2.13
Shell 2.25
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
