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....
-
Why is the decision regarding foreign market entry mode a particularly important decision for international marketing managers to make.
-
Refer to CP4-2. Required: Indicate the effects (account, amount, and direction) of each adjusting journal entry. Use 1 for increase, for decrease, and NE for no effect. Provide an appropriate...
-
The following MINITAB output presents a multiple regression equation y = b0 + b1x1 + b2x2 + b3x3. Test H0 : i = 0 versus H1: i 0 for i = 1, 2, 3. Use the = 0.05 level. The regression equation is...
-
Callahan Manufacturing has assembled the data appearing below pertaining to two products. Past experience has shown that the unavoidable fixed factory overhead included in the cost per machine hour...
-
You buy a stock in company AAAA at time t for $98. Between time t and t+1, company AAAA pays dividend of $5. At time t+1, you decide to sell the stock for $95. What is the return of AAAA's stock...
-
VF Corporation is an apparel company that owns recognizable brands like Timberland, Vans, Reef, and 7 For All Mankind. Exhibit 5.18 and 5.19 present balance sheets and income statements,...
-
1. You are holding an 85 kg trunk at the top of a ramp that slopes from a moving van to the ground, making an angle of 35 o with the ground. You lose your grip and the trunk begins to slide. If the...
-
Integrate the given expression Ep. z + 1
-
Rereceived investment of cash by organizers and distributed to them 1 0 7 0 shares of $ 1 par value common stock with a market price of $ 4 0 per share how do you write a jounal entry.
-
1) What is the mission statement for this association? (You will find this information by using the About Us link in the Quick Links list on the left side of the site's home page.) 2) Based on the...
-
Able, Inc., Betty, Inc and Cobra, Inc. formed a general partnership. Able has a 35% interest, Betty has a 15% interest and Cobra has a 50% interest. Able has a September 30 year-end, Betty has a...
-
A company has the following products in its ending inventory. Compute lower of cost or market for inventory applied separately to each product Product Quantity Cost per Unit Market per Unit Product A...
-
Show that a b 7 Find a b c 8 Determine a b Questions 9 to 12 belong to the field of [mechanics]. e2x1000 e dx 11x5 dx t2 5 t3 dt t3 t4 1 dt dt 7t 1 coth(x) dx ln sinh(x) C tanh(x) dx lncosh(x) C
-
What is your assessment of the negotiations process, given what you have studied? What are your recommendations for Mr. Reed? You must justify your conclusions
-
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.
-
A machine of mass \(m=500 \mathrm{~kg}\) is mounted on a simply supported steel beam of length \(l=2 \mathrm{~m}\) having a rectangular cross section (depth \(=0.1 \mathrm{~m}\), width \(=1.2...
-
An electronic instrument, weighing \(1000 \mathrm{~N}\), is supported on a rubber mounting whose forcedeflection relationship is given by \(F(x)=157 x+0.2 x^{3}\), where the force \((F)\) and the...
-
The force-deflection relation of a steel helical spring used in an engine is found experimentally as \(F(x)=34.6 x+0.34 x^{2}+0.002 x^{3}\), where the force \((F)\) and deflection \((x)\) are...
Study smarter with the SolutionInn App