You work for a consultancy and a client is interested in knowing the consumer preferences between...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You work for a consultancy and a client is interested in knowing the consumer preferences between pints and shoes. You obtain data on prices and quantities of consumption of shoes and pints for 40 individuals. You also have data on the individuals gender. a. Download and look at the spreadsheet "pints and shoes.xlsx". b. Use the data in "pints and shoes.xlsx" to estimate the parameters of a simple linear demand model for shoes: Si = αo + B₁ Pi + ei where S, is sales of shoes per individual and P; is the average price of shoes paid per person C. Determine whether the coefficient on price is statistically different from zero at the significance levels of 0.01, 0.05 and 0.10. Calculate the point price elasticity of demand across the observed range of prices at £5 intervals. Use the data in "pints and shoes.xlsx", create a dummy variable for gender where 1 is Female and 0 is Male. Include the dummy variable in the model you estimated in question 1.b. d. Estimate a linear demand model for pints where the quantity demanded of pints of beer is the dependent variable and the regressors are the price of pints and the gender: Qi = αo + B₁Z₁ + B₂ Gi + ei where Q₁ is sales of pints per individual, Z, is the average price of pints paid per person, and G₁ is a dummy variable equal to 1 if individual i is a Female and 0 otherwise ID GENDER SHOES (quantity) PINTS (quantity) SHOES (average price per unit) 1 Male 2 Female 3 Female 4 Male 5 Male 6 Female 7 Male 8 Male 9 Female 10 Female 11 Female 12 Male 13 Male 14 Male 15 Male 16 Female 17 Male 18 Male 19 Male 20 Male 21 Female 22 Female 23 Male 24 Female 25 Male 26 Female 27 Male 28 Male 29 Female 30 Female 31 Female 32 Male 33 Male 34 Male 35 Male 36 Female 37 Female 38 Female 39 Female 40 Female 4 5 6 7 6 2 1 1 1 4 3 5 2 5 3 1 1 11 1 2 9 2 2 4 1 5 1 4 4 2 1 1 1 4 3 10 3 2 1 6 25 1 4 10 10 4 10 5 7 1 5 8 14 3 4 1 30 20 24 15 10 1 13 12 5 9 12 18 7 5 3 12 25 30 17 1 9 10 1 4 55 101 89 87 16 114 96 145 147 85 129 146 97 40 57 77 32 21 147 138 71 88 100 41 143 78 116 43 113 88 54 44 105 118 60 63 110 52 103 84 PINTS (average price per unit) 2 5 3 6 5 5 2 6 4 6 3 3 5 2 3 6 2 3 3 2 4 6 2 4 5 4 3 3 5 5 6 3 2 3 3 6 5 6 6 6 Country 2 1 2 3 1 2 2 3 2 1 1 3 2 2 1 3 2 1 2 3 2 2 3 2 1 1 3 3 1 3 3 2 2 2 2 2 2 2 1 2 You work for a consultancy and a client is interested in knowing the consumer preferences between pints and shoes. You obtain data on prices and quantities of consumption of shoes and pints for 40 individuals. You also have data on the individuals gender. a. Download and look at the spreadsheet "pints and shoes.xlsx". b. Use the data in "pints and shoes.xlsx" to estimate the parameters of a simple linear demand model for shoes: Si = αo + B₁ Pi + ei where S, is sales of shoes per individual and P; is the average price of shoes paid per person C. Determine whether the coefficient on price is statistically different from zero at the significance levels of 0.01, 0.05 and 0.10. Calculate the point price elasticity of demand across the observed range of prices at £5 intervals. Use the data in "pints and shoes.xlsx", create a dummy variable for gender where 1 is Female and 0 is Male. Include the dummy variable in the model you estimated in question 1.b. d. Estimate a linear demand model for pints where the quantity demanded of pints of beer is the dependent variable and the regressors are the price of pints and the gender: Qi = αo + B₁Z₁ + B₂ Gi + ei where Q₁ is sales of pints per individual, Z, is the average price of pints paid per person, and G₁ is a dummy variable equal to 1 if individual i is a Female and 0 otherwise ID GENDER SHOES (quantity) PINTS (quantity) SHOES (average price per unit) 1 Male 2 Female 3 Female 4 Male 5 Male 6 Female 7 Male 8 Male 9 Female 10 Female 11 Female 12 Male 13 Male 14 Male 15 Male 16 Female 17 Male 18 Male 19 Male 20 Male 21 Female 22 Female 23 Male 24 Female 25 Male 26 Female 27 Male 28 Male 29 Female 30 Female 31 Female 32 Male 33 Male 34 Male 35 Male 36 Female 37 Female 38 Female 39 Female 40 Female 4 5 6 7 6 2 1 1 1 4 3 5 2 5 3 1 1 11 1 2 9 2 2 4 1 5 1 4 4 2 1 1 1 4 3 10 3 2 1 6 25 1 4 10 10 4 10 5 7 1 5 8 14 3 4 1 30 20 24 15 10 1 13 12 5 9 12 18 7 5 3 12 25 30 17 1 9 10 1 4 55 101 89 87 16 114 96 145 147 85 129 146 97 40 57 77 32 21 147 138 71 88 100 41 143 78 116 43 113 88 54 44 105 118 60 63 110 52 103 84 PINTS (average price per unit) 2 5 3 6 5 5 2 6 4 6 3 3 5 2 3 6 2 3 3 2 4 6 2 4 5 4 3 3 5 5 6 3 2 3 3 6 5 6 6 6 Country 2 1 2 3 1 2 2 3 2 1 1 3 2 2 1 3 2 1 2 3 2 2 3 2 1 1 3 3 1 3 3 2 2 2 2 2 2 2 1 2
Expert Answer:
Answer rating: 100% (QA)
b To estimate the parameters of a simple linear demand model for shoes you can use ordinary least squares OLS regression The model you want to estimat... View the full answer
Related Book For
Accounting Tools for business decision making
ISBN: 978-0470095461
4th Edition
Authors: kimmel, weygandt, kieso
Posted Date:
Students also viewed these economics questions
-
Hill Company uses budgets in controlling costs. The August 2012 budget report for the companys Assembling Department is as follows. The monthly budget amounts in the report were based on an expected...
-
Hill Company uses budgets in controlling costs. The August 2014 budget report for the company's Assembling Department is as follows. The monthly budget amounts in the report were based on an expected...
-
Ratchet Company uses budgets in controlling costs. The August 2022 budget report for the companys Assembling Department is as follows. The monthly budget amounts in the report were based on an...
-
1. Should Sandy do exactly what the partner suggests, or risk losing the business for the firm, and perhaps her job, by suggesting a different approach? 2. What might be an alternative approach? 3....
-
The consolidated financial statements for Dowsett Shipping Corporation and Subsidiaries follow. Dowsett Shipping Corporation and Subsidiaries Consolidated Balance Sheets (In thousands) LIABILITIES...
-
The diagram shows the curve with equation y = 5 + 2x x 2 and the line with equation y = 2. The curve and the line intersect at the points A and B. Find the x-coordinates of A and B. 0 y = 2 y = 5 +...
-
Referring to the information in Brief Exercise 17-26, show the balance sheet presentation on December 31, 2020, and the income statement presentation for the year ended December 31, 2020. Exercise...
-
You must analyze a potential new producta caulking compound that Cory Materials R&D people developed for use in the residential construction industry. Corys marketing manager thinks the company can...
-
Please show work, preferably in excel What is the interest rate of a 4-year, annual $1,000 annuity with present value of $3,500? Mr. Jones decides to purchase a car for $10,000. The dealer offers t...
-
You have two assets, A and B, with different possible payoffs each. The payoffs and the corresponding unconditional probabilities are given in the table below. The assets are independent of each...
-
Felles Hospitality Group currently operates two (2) midsize limited-service hotels. Each of the 100-plus room properties is located within a 200-mile radius, and each is a participant in the...
-
Kyle is over $5,000 behind in court-ordered child support payments. He has lost his job over a year ago and has made no real effort to find another one. Kyle does not want to pay child support since...
-
A company expects to pay its first dividend of $1.50 a share in Year 6 with annual dividend increases of 2.8 percent thereafter. At a required return of 15.4 percent, what is the current share price?
-
Consider the following model for the variable yt: Yt = Et + 0.5t-1 where Et is an i.i.d. white noise process with variance o = 2. What is the value of cov(yt, Yt-1)? Your Answer:
-
Find deflection a point c using double integration method? E=200GPa, I=95x10 6 mm 4 49 KHM 23kW 2174/m A 3 1.7m 46KN
-
On 15 November 19X8, Hughes consigned 300 cases of wooden items to Galvez of Madrid. On 31 December 19X8, Galvez forwarded an account sales, with a draft for the balance, showing the following...
-
se podra realizar un anlisis estadstico inferencial para determinar si la economa de un pas tiene influencia sobre la economa de otro. Falso Cierto
-
If a test has high reliability. O the test measures what the authors of the test claim it measures O people who take the same test twice get approximately the same scores both times O scores on the...
-
Thomas Holme, a mid-level product manager for Dorothys Shoes, thinks his company should switch from LIFO to FIFO. He says, My bonus is based on net income. If we switch it will increase net income...
-
What is the difference between gross pay and net pay? Which amount should a company record as wages or salaries expense?
-
Identify the special journal(s) in which the following column headings appear. 1. Sales Discounts Dr. 2. Accounts Receivable Cr. 3. Cash Dr. 4. Sales Cr. 5. Merchandise Inventory Dr.
-
What was the forerunner of the American Institute of CPAs?
-
Which country was the first to require the audit of corporations, England or the United States?
-
The first volume of the Accountant's Index listed forensic-type articles under which categories?
Study smarter with the SolutionInn App