#### Question Details

##### [solution] » How do I create the below? I have prices from 10 stations in my

Brief item decscription

Step-by-step solution file

Item details:

How do I create the below? I have prices from 10 stations in my
More:

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

Running head: MATH: SUPPLY AND DEMAND

1

Math: Supply and Demand

Professor?s Name

Student?s Name

Date

MATH: SUPPLY AND DEMAND

2

The supply and demand curves are drawn in line with the laws...

STATUS
QUALITY
Approved

This question was answered on: Feb 21, 2020

Solution~000241233.zip (18.37 KB)