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

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!