Perform the following work • Assume that Supply has a quadratic relationship with the price. Find this relationship (the help buttons contain an article to compute trend-lines in Excel): S(p) = Round your answer to 3 decimal places • Assume that the Demand has a quadratic relationship with the price. Find this relationship (the help button links to an article to compute trend-lines in Excel): D(p) Round your answer to 3 decimal places Use the trendlines to find the price corresponding to the equlibrium price between supply and demand: $ per gallon Round your answer to 2 decimal places From the price above what is the equilibrum quantity between supply and demand: million of gallons Round your answer to closest whole number
Perform the following work • Assume that Supply has a quadratic relationship with the price. Find this relationship (the help buttons contain an article to compute trend-lines in Excel): S(p) = Round your answer to 3 decimal places • Assume that the Demand has a quadratic relationship with the price. Find this relationship (the help button links to an article to compute trend-lines in Excel): D(p) Round your answer to 3 decimal places Use the trendlines to find the price corresponding to the equlibrium price between supply and demand: $ per gallon Round your answer to 2 decimal places From the price above what is the equilibrum quantity between supply and demand: million of gallons Round your answer to closest whole number
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
Related questions
Question
![The table below shows how supply and demand of gasoliine vary depending on the price:
Demand (million of gal.)
Price ($/gal)
Supply (million of gal.)
1
787
483
1.2
700
550
1.4
640
600
1.6
580
623
1.85
531
660
2.2
450
680
2.4
430
700
2.6
420
720
2.8
390
735
2.9
357
765
Note: there is some randomization in the above data to account for price fluctuations. Make sure to check that you input
the correct data in your device.
Perform the following work
• Assume that Supply has a quadratic relationship with the price. Find this relationship (the help buttons contain an
article to compute trend-lines in Excel):
S(p) =
Round your answer to 3 decimal places
• Assume that the Demand has a quadratic relationship with the price. Find this relationship (the help button links to
an article to compute trend-lines in Excel):
D(p) =
Round your answer to 3 decimal places
Use the trendlines to find the price corresponding to the equlibrium price between supply and demand:
$ per gallon Round your answer to 2 decimal places
• From the price above what is the equilibrum quantity between supply and demand:
million of gallons Round your answer to closest whole number
• Under these conditions, what is the consumer surplus?
million of gallons Round your answer to closest whole number
• Under these conditions, what is the producer surplus?
million of gallons Round your answer to closest whole number
Discuss what is a mathematical model in general, and how mathematical models are used in this activity.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F3fe8531a-a619-49d0-9f5b-2fe908554eae%2F83abbc50-def8-4cba-b82c-b99e4968871c%2Fjwbcz3m_processed.png&w=3840&q=75)
Transcribed Image Text:The table below shows how supply and demand of gasoliine vary depending on the price:
Demand (million of gal.)
Price ($/gal)
Supply (million of gal.)
1
787
483
1.2
700
550
1.4
640
600
1.6
580
623
1.85
531
660
2.2
450
680
2.4
430
700
2.6
420
720
2.8
390
735
2.9
357
765
Note: there is some randomization in the above data to account for price fluctuations. Make sure to check that you input
the correct data in your device.
Perform the following work
• Assume that Supply has a quadratic relationship with the price. Find this relationship (the help buttons contain an
article to compute trend-lines in Excel):
S(p) =
Round your answer to 3 decimal places
• Assume that the Demand has a quadratic relationship with the price. Find this relationship (the help button links to
an article to compute trend-lines in Excel):
D(p) =
Round your answer to 3 decimal places
Use the trendlines to find the price corresponding to the equlibrium price between supply and demand:
$ per gallon Round your answer to 2 decimal places
• From the price above what is the equilibrum quantity between supply and demand:
million of gallons Round your answer to closest whole number
• Under these conditions, what is the consumer surplus?
million of gallons Round your answer to closest whole number
• Under these conditions, what is the producer surplus?
million of gallons Round your answer to closest whole number
Discuss what is a mathematical model in general, and how mathematical models are used in this activity.
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.Recommended textbooks for you
![ENGR.ECONOMIC ANALYSIS](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9780190931919/9780190931919_smallCoverImage.gif)
![Principles of Economics (12th Edition)](https://www.bartleby.com/isbn_cover_images/9780134078779/9780134078779_smallCoverImage.gif)
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
![Engineering Economy (17th Edition)](https://www.bartleby.com/isbn_cover_images/9780134870069/9780134870069_smallCoverImage.gif)
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
![ENGR.ECONOMIC ANALYSIS](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9780190931919/9780190931919_smallCoverImage.gif)
![Principles of Economics (12th Edition)](https://www.bartleby.com/isbn_cover_images/9780134078779/9780134078779_smallCoverImage.gif)
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
![Engineering Economy (17th Edition)](https://www.bartleby.com/isbn_cover_images/9780134870069/9780134870069_smallCoverImage.gif)
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
![Principles of Economics (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781305585126/9781305585126_smallCoverImage.gif)
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
![Managerial Economics: A Problem Solving Approach](https://www.bartleby.com/isbn_cover_images/9781337106665/9781337106665_smallCoverImage.gif)
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
![Managerial Economics & Business Strategy (Mcgraw-…](https://www.bartleby.com/isbn_cover_images/9781259290619/9781259290619_smallCoverImage.gif)
Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education