Your first task is to estimate a demand function based on the following relationship: Quantity = a + B,Price In order to do this, you will have to estimate a regression equation using Excel. This will provide you with the coefficient estimates for a and ß, in the demand function above (round your estimates to the nearest whole number). Your second task is to illustrate the demand function – don't forget to label your diagram! Finally, I would like you to address my main concern: what price should I charge for a pecan pie to maximize total revenue? Support your argument by using theories related to the price elasticity of demand.
Your first task is to estimate a demand function based on the following relationship: Quantity = a + B,Price In order to do this, you will have to estimate a regression equation using Excel. This will provide you with the coefficient estimates for a and ß, in the demand function above (round your estimates to the nearest whole number). Your second task is to illustrate the demand function – don't forget to label your diagram! Finally, I would like you to address my main concern: what price should I charge for a pecan pie to maximize total revenue? Support your argument by using theories related to the price elasticity of demand.
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
Related questions
Question
100%
I solve the
However, I do not know how to maximize the total revenue and cannot explain it why by using theories related to the
Could you help me to answer this question?
**I asked to Contact support, and they told me to ask this question here again. Thanks.
![Day
Quantity
Price
Variable Descriptions
Quantity refers to the number of pecan pies sold on a particular day
refers to the price charged per pecan pie (measured in dollars)
1
50
8.00
2
48
8.00
Price
3
72
8.00
4
53
8.00
82
8.00
6.
75
8.00
63
8.00
8
48
8.50
9
52
8.50
10
61
8.50
11
70
8.50
12
59
8.50
13
53
8.50
14
58
8.50
15
43
9.00
16
50
9.00
17
53
9.00
18
38
9.00
19
44
9.00
20
59
9.00
21
41
9.00
22
38
9.50
23
35
9.50
24
45
9.50
25
52
9.50
26
32
9.50
27
39
9.50
28
46
9.50
29
29
10.00
30
35
10.00
31
28
10.00](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F05cc2bd7-b769-4852-9759-e68f1360e9fe%2F7fafcecc-aade-422a-ac7b-3d55e646f77e%2Fn8r409s_processed.png&w=3840&q=75)
Transcribed Image Text:Day
Quantity
Price
Variable Descriptions
Quantity refers to the number of pecan pies sold on a particular day
refers to the price charged per pecan pie (measured in dollars)
1
50
8.00
2
48
8.00
Price
3
72
8.00
4
53
8.00
82
8.00
6.
75
8.00
63
8.00
8
48
8.50
9
52
8.50
10
61
8.50
11
70
8.50
12
59
8.50
13
53
8.50
14
58
8.50
15
43
9.00
16
50
9.00
17
53
9.00
18
38
9.00
19
44
9.00
20
59
9.00
21
41
9.00
22
38
9.50
23
35
9.50
24
45
9.50
25
52
9.50
26
32
9.50
27
39
9.50
28
46
9.50
29
29
10.00
30
35
10.00
31
28
10.00
![Hello!
To help you with the consultation, please refer to "Penny's Pecan Pies – Data" which I've attached to this
memo.
Your first task is to estimate a demand function based on the following relationship:
Quantity = a + B¿Price
In order to do this, you will have to estimate a regression equation using Excel. This will provide you
with the coefficient estimates for a and ß, in the demand function above (round your estimates to the
nearest whole number).
Your second task is to illustrate the demand function – don't forget to label your diagram!
Finally, I would like you to address my main concern: what price should I charge for a pecan pie to
maximize total revenue? Support your argument by using theories related to the price elasticity of
demand.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F05cc2bd7-b769-4852-9759-e68f1360e9fe%2F7fafcecc-aade-422a-ac7b-3d55e646f77e%2Fi80uqse_processed.png&w=3840&q=75)
Transcribed Image Text:Hello!
To help you with the consultation, please refer to "Penny's Pecan Pies – Data" which I've attached to this
memo.
Your first task is to estimate a demand function based on the following relationship:
Quantity = a + B¿Price
In order to do this, you will have to estimate a regression equation using Excel. This will provide you
with the coefficient estimates for a and ß, in the demand function above (round your estimates to the
nearest whole number).
Your second task is to illustrate the demand function – don't forget to label your diagram!
Finally, I would like you to address my main concern: what price should I charge for a pecan pie to
maximize total revenue? Support your argument by using theories related to the price elasticity of
demand.
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.
Step by step
Solved in 3 steps
![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