1a MidCentury Lilac Exercises
.pdf
keyboard_arrow_up
School
Boston University *
*We aren’t endorsed by this school
Course
856
Subject
Economics
Date
Feb 20, 2024
Type
Pages
3
Uploaded by MajorGalaxy9336
Lilac Soap
A manufacturer of fancy scented bar soaps is interested in the price elasticity shown by her popular lilac variety. She assembled data for each of the past twenty months concerning the number of bars sold, the price, and the number of retail outlets that put the lilac soap on display and then carried out a regression analysis on this data. Here are the resulting means for each variable. The regression output is on the next page:
32
Mean
Variable
2,506
Bars of lilac soap sold
1.59
Price
167.9
Number of displays
Lilac Soap
1.
What is the coefficient of the price variable in the Excel output?
2.
Describe how you would explain the interpretation of this price coefficient to someone who is not familiar with multiple regression.
3.
Calculate the price elasticity implied by these results.
33
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
A marketing analyst wants to examine the relationship between sales (in $1,000s) and advertising (in $100s) for firms in the food and beverage industry
and collects monthly data for 25 firms. He estimates the modet:
Sales- Bo + B1 Advertising +t. The following table shows a portion of the regression results.
Coefficients
Standard Error
t-stat
p-value
Intercept
40.10
14.08
2.848
0.0052
Advertising
2.88
1.52
-1.895
0.0608
Which of the following are the competing hypotheses used to test whether the slope coefficient differs from 3?
Multiple Choice
Ho i bị 3; HAtbi3
Họ ib - 2.88; HAibi 2.88
arrow_forward
A marketing analyst wants to examine the relationship between sales (in $1,000s) and advertising (in $100s) for firms in the food and
beverage industry and so collects monthly data for 25 firms. He estimates the model:
Sales 6g + 61 Advertising + e. The following table shows a portion of the regression results.
Coefficients
Standard Error
t-stat
p-value
40.10
14.88
2.848
0.0052
Intercept
Advertising
2.88
1.52
-1.895
0.0608
When testing whether Advertising is significant at the 10% significance level, the conclusion is to
Multiple Choice
reject Hg, we can conclude advertising is significant
not reject He; we cannot conclude advertising is significant
reject He; we cannot conclude advertising is significant
not reject He; we can conclude advertising is significant
arrow_forward
Numerical Answer Only Type Question
Enter the numerical value only for the correct answer in the blank box. If a decimal point appears, round it to two decimal places.
Assume that the number of visits by a particular customer to a mall located in downtown Toronto is related to the distance from the customer's home. The following regression analysis shows the relationship between the number of times a customer visits(Y)per month and the distance(X, measured in km) from the customer's home to the mall.
\[ Y=15-0.5 X \]
A customer who lives30 kmaway from the mall will visi______ who lives10 km away. less times than a customer
arrow_forward
Sally Sells Sea Shells by the Sea Shore and collects all sales dataNow she is curious to find out what the elasticity of demand is for her shells Assume they are all the same type and quantity She scatter plots the data and finds there is a linear relationship that looks ripe for a regression estimation of the price response function for her shells The slope of her regression line is 61. Currently, her average daily price is 11.74 and she sells 95 quantity at that priceCalculate the point elasticity of demand for her sea shells
arrow_forward
You are interested in how the number of hours a high school student has to work in an outside job has on their GPA. In your
regression you want to control for high school
standing and so you run the following regression:
GPA = 3.4 0.03 * HrsWrk - 0.7 * Frosh - 0.3 * Soph +0.1 * Junior
(1.1) (0.013)
(0.23)
(0.14) (0.08)
where HrsWrk is the number of hours the student works per week, and Frosh, Soph, and Junior are dummy variables for the
student's class standing.
a) If you include a dummy variable for seniors, that would cause a
Hint: type one word in each blank.
For the rest of questions, type a number in one decimal place.
b) The expected GPA of a Sophomore who works 10 hours per week is
c) The expected GPA of a Senior who works 10 hours per week is
d) If Dom and Sarah work the same number of hours per week, but Dom is a Junior and Sarah is a Freshman.
Dom is expected to have a
higher GPA than Sarah.
e) Suppose you rewrite the regression as:
problem.
GPA = ₁HrsWrk + ß2Frosh + B2Soph +…
arrow_forward
Test Design: Suppose I want to test the impact of soccer coaches on soccer teams. How would you test this? Include a few (3 or 4) independent variables to explain the dependent variable. Describe the data and write the regression equation.
arrow_forward
Mita, the manufacturer of copiers, has been spending
increasing amounts of money on radio and television
advertising in recent years. An analyst employed by Mita
wanted to estimate a simple linear regression of the
company's annual copier sales versus advertising dollars. Th
regression results included SSE = 12593 and SSR = 87663.
What is the coefficient of determination for this regression?
0.874
0.935
0.144
0.126
arrow_forward
Suppose the Sherwin-Williams Company is interested in developing a simple regression model with paint sales (Y) as the dependent variable and
selling price (P) as the independent variable.
Complete the following worksheet and then use it to determine the estimated regression line.
Sales Region
Selling Price
($/Gallon)
Sales
(x 1000 Gal)
i
2
Zi
Yi
Zith
1
15
160
2,400
225
25,600
2
13.5
220
2,970
182.25
48,400
3
16.5
140
2,310
272.25
19,600
4
14.5
190
2,755
210.25
36,100
5
17
140
2,380
289
19,600
6
16
160
2,560
256
25,600
7
13
200
2,600
169
40,000
8
18
150
2,700
324
22,500
9
12
220
2,640
144
48,400
10
15.5
190
2,945
240.25
36,100
Total
151
1,770
2,312
Regression Parameters Estimations
Slope (B)
Intercept (a)
In words, for a dollar increase in the selling price, the expected sales will
What is the standard error of the estimate (&)?
O 14.889
12.180
13.342
gallons in a given sales region.
What is the estimate of the standard deviation of the estimated slope (86)?
O 2.636
2.157
2.362
Can you…
arrow_forward
A guidance counselor wants to determine if there is
a relationship between a student's number of
absences, x, and their grade point average
(GPA), y. The data that were collected are displayed
in the scatterplot and the least-squares regression
line was calculated. One student with 2 absences
has a GPA of 1.8. This point is circled on the graph.
GPA and Absences
4.8
4.4
4.0
3.6
3.2
2.8
2.4
2.0
1.6
4 6 8 10 12 14
16
Absences (Days)
What effect does the circled point have on the
standard deviation of the residuals?
This point will increase the value of the standard
deviation of the residuals because it has a large
positive residual.
This point will increase the value of the standard
deviation of the residuals because it has a large
negative residual.
This point will not affect the value of the standard
deviation of the residuals because it has a large
positive residual.
This point will decrease the value of the standard
deviation of the residuals because it has a large
negative residual.…
arrow_forward
Find the degrees of freedom in a regression model that has 10 observations and 7 independent variables
arrow_forward
QUESTION 1
Suppose a researcher collects data on houses that have been sold in a particular neighbourhood over the past year, and obtains the regressions results in the table shown below. This table is
used for Questions 1-6.
Dependent variable: In(Price)
Regressor
(1)
(2)
(3)
(4)
(5)
0.00042
(0.000038)
Size
In(Size)
0.57
(2.03)
0.69
0.68
0.69
(0.055)
(0.054)
(0.087)
In(Size)²
0.0078
(0.14)
Bedrooms
0.0036
(0.037)
Рol
0.082
0.071
0.071
0.071
0.071
(0.032)
(0.034)
(0.034)
(0.036)
(0.035)
0.037
0.027
0.026
0.027
0.027
(0.030)
View
(0.029)
(0.028)
(0.026)
(0.029)
Pool x View
0.0022
(0.10)
0.12
(0.035)
Condition
0.13
0.12
0.12
(0.035)
0.12
(0.045)
(0.035)
(0.036)
6.63
(0.53)
Intercept
10.97
6.60
7.02
6.60
(0.069)
(0.39)
(7.50)
(0.40)
Summary Statistics
SER
0.102
0.098
0.099
0.099
0.099
R?
0.72
0.74
0.73
0.73
0.73
Variable definitions: Price = sale price ($); Size = house size (in square feet); Bedrooms = number of bedrooms; Pool = binary
variable (1 if house has a swimming pool, 0…
arrow_forward
A finance manager employed by an automobile dealership believes that the number of
cars sold in his local market can be predicted by the interest rate charged for a loan.
Interest Rate (%) Number of Cars Sold (100s)
3
5
10
7
8
2
The finance manager performed a regression analysis of the number of cars sold and
interest rates using the sample of data above. Shown below is a portion of the
regression output.
Regression Statistics
Multiple R0.998868
R2
0.997738
Coefficient
|14.88462
Interest Rate -1.61538
Intercept
1. Are there factors other than interest rate charged for a loan that the finance
manager should consider in predicting future car sales?
2. Is interest rate charged for a loan the most important factor to be considered
in predicting future car sales? Explain your reasoning.The dealership's vice-
president of marketing has requested a sales forecast at the prevailing interest
rate of 7%.
3. As finance manager, what reasons would you convey to the vice-president in
recommending…
arrow_forward
18
Given that the sum of the squared deviations of EDUC is
9025.6
The standard error of the slope coefficient is ________.
a
0.1524
b
0.1249
c
0.1024
d
0.0839
arrow_forward
does the simple regression of log (price) on log (nox) produce an upward or a downward biased estimator of β1?
arrow_forward
Interpret the coefficients in the regression model
arrow_forward
A finance manager employed by an automobile dealership believes that the number of cars sold in his local market can be predicted by the interest rate charged for a loan.
Interest Rate (%)
Number of Cars Sold (100s)
3
10
5
7
6
5
8
2
The finance manager performed a regression analysis of the number of cars sold and interest rates using the sample of data above. Shown below is a portion of the regression output.
Regression Statistics
Multiple R
0.998868
R2
0.997738
Coefficient
Intercept
14.88462
Interest Rate
-1.61538
1. Are there factors other than interest rate charged for a loan that the finance manager should consider in predicting future car sales?
2. Is interest rate charged for a loan the most important factor to be considered in predicting future car sales? Explain reasoning.The dealership's vice-president of marketing has requested a sales forecast at the prevailing interest rate of 7%.
3. As…
arrow_forward
A finance manager employed by an automobile dealership believes that the number of cars sold in his local market can be predicted by the interest rate charged for a loan.
Interest Rate (%)
Number of Cars Sold (100s)
3
10
5
7
6
5
8
2
The finance manager performed a regression analysis of the number of cars sold and interest rates using the sample of data above. Shown below is a portion of the regression output.
Regression Statistics
Multiple R
0.998868
R2
0.997738
Coefficient
Intercept
14.88462
Interest Rate
-1.61538
2. Is interest rate charged for a loan the most important factor to be considered in predicting future car sales? Explain reasoning.The dealership's vice-president of marketing has requested a sales forecast at the prevailing interest rate of 7%.
3. As finance manager, what reasons would you convey to the vice-president in recommending this forecasting model?
4. Is the prediction of car sales…
arrow_forward
You have data on the training regime of 100m elite runners. For each runner you observe their best run of the year (in second) (pb), the number of hours they train each week (tr) and a dummy variable equal to 1 if thei
are male (male).
Using OLS you get the following regression:
pb= 36.2 1.3male -0.92tr +0.009tr² -0.09male tr +0.001male * (tr²)
How many hours should a male elite runner train each week to minimize the time of their best run of the year? (round to the closest decimal)
arrow_forward
Determine the PRF.
arrow_forward
A manufacturer of computer workstations gathered average monthly sales figures from its
56 dealerships across the country and estimated the demand for its product using the
following regression equation:
Q=B0+ B₁ PRICE + ẞ2 ADV + ẞ3 PRICE C
where Q is the number of computer workstations sold monthly, PRICE is the price of the
computer workstation, ADV is the advertising expenditures, and PRICE, is the average price
of a leading competitor's computer workstation. The regression results are as follows:
DEPENDENT VARIABLE: Q
PROB(F-STATISTIC)
OBSERVATIONS: 56
R-SQUARED
0.68
F-STATISTIC
21.25
Standard
0.04
Variable Coefficient error
Intercept 15,000.0
5234.0
PRICE
-2.8
1.29
ADV
150.0
175.0
PRICEC
0.2
0.13
a. Which coefficients have a statistically significant effect on the number of workstations
sold? Substantiate your answers appropriately.
b. Calculate the expected number of workstations sold when PRICE = $7,000, ADV = $52,
and PRICE
$8,000.
c. Calculate the own-price elasticity of…
arrow_forward
Refrigerator prices are affected by characteristics such as whether or not the refrigerator is on sale, whether or not it is listed as a Sub-
Zero brand, the number of doors (one door or two doors), and the placement of the freezer compartment (top, side, or bottom). The
table below shows the regression output from a regression model using the natural log of price as the dependent variable. The model
was developed by the Bureau of Labor Statistics.
Variable
Coefficient Standard Error t Statistic
5.4841
Intercept
0.13081
41.92
Sale price
-0.0733
0.0234
-3.13
Sub-Zero brand
1.1196
0.1462
7.66
0.06956
0.005351
13.00
Total capacity (in cubic feet)
Two-door, freezer on bottom
Two-door, side freezer
0.04657
0.08085
0.58
Two-door, freezer on top
0.03596
-9.55
Base
-0.3432
-0.7096
-0.8820
One door with freezer
0.1310
-5.42
-5.92
One door, no freezer
0.1491
(a) Write the regression model, being careful to exclude the base indicator variable. (Negative amounts should be indicated by a
minus…
arrow_forward
The following data relate the sales figures of the bar in Mark Kaltenbach's small bed-and-breakfast inn in portland, to the number of guest registered that week:
week guests bar sales
1 16 $330
2 12 $270
3 18 $380
4 14 $315
a) The simple linear regression equation that relates bar sales to number of guests(not to time) is (round your responses to one decimal place):
Bar sales = [___]+[___]X guests
arrow_forward
4) can i please get help with this question
arrow_forward
Suppose that we obtained an estimated equation for the regression of weekly sales of palm pilots and the price charged during the week. Interpret the constants b0 for the product brand manager.
arrow_forward
5.2
42
The following regression shows the impact of the number of rooms (ROOM) on the
monthly rent of an apartment (in thousand Rands) (RENT) from a sample of 42 randomly
chosen apartments in Parow:
Dependent Variable: RENT
Variable
C
ROOM
r-square: 0.7180
Parameter
-0.7705
2.1331
SE of regression: 2.3397
Std. Error
0.8233
0.2114
sample size = 42
What will be values of the parameters, variance and standard errors of the
parameters, estimated variance of error terms, coefficient of determination and
correlation coefficient, if RENT is measured in Rands and there is no change to
the unit of measurement of the ROOM variable?
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Economics: Applications, Strategies an...
Economics
ISBN:9781305506381
Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:Cengage Learning
Related Questions
- A marketing analyst wants to examine the relationship between sales (in $1,000s) and advertising (in $100s) for firms in the food and beverage industry and collects monthly data for 25 firms. He estimates the modet: Sales- Bo + B1 Advertising +t. The following table shows a portion of the regression results. Coefficients Standard Error t-stat p-value Intercept 40.10 14.08 2.848 0.0052 Advertising 2.88 1.52 -1.895 0.0608 Which of the following are the competing hypotheses used to test whether the slope coefficient differs from 3? Multiple Choice Ho i bị 3; HAtbi3 Họ ib - 2.88; HAibi 2.88arrow_forwardA marketing analyst wants to examine the relationship between sales (in $1,000s) and advertising (in $100s) for firms in the food and beverage industry and so collects monthly data for 25 firms. He estimates the model: Sales 6g + 61 Advertising + e. The following table shows a portion of the regression results. Coefficients Standard Error t-stat p-value 40.10 14.88 2.848 0.0052 Intercept Advertising 2.88 1.52 -1.895 0.0608 When testing whether Advertising is significant at the 10% significance level, the conclusion is to Multiple Choice reject Hg, we can conclude advertising is significant not reject He; we cannot conclude advertising is significant reject He; we cannot conclude advertising is significant not reject He; we can conclude advertising is significantarrow_forwardNumerical Answer Only Type Question Enter the numerical value only for the correct answer in the blank box. If a decimal point appears, round it to two decimal places. Assume that the number of visits by a particular customer to a mall located in downtown Toronto is related to the distance from the customer's home. The following regression analysis shows the relationship between the number of times a customer visits(Y)per month and the distance(X, measured in km) from the customer's home to the mall. \[ Y=15-0.5 X \] A customer who lives30 kmaway from the mall will visi______ who lives10 km away. less times than a customerarrow_forward
- Sally Sells Sea Shells by the Sea Shore and collects all sales dataNow she is curious to find out what the elasticity of demand is for her shells Assume they are all the same type and quantity She scatter plots the data and finds there is a linear relationship that looks ripe for a regression estimation of the price response function for her shells The slope of her regression line is 61. Currently, her average daily price is 11.74 and she sells 95 quantity at that priceCalculate the point elasticity of demand for her sea shellsarrow_forwardYou are interested in how the number of hours a high school student has to work in an outside job has on their GPA. In your regression you want to control for high school standing and so you run the following regression: GPA = 3.4 0.03 * HrsWrk - 0.7 * Frosh - 0.3 * Soph +0.1 * Junior (1.1) (0.013) (0.23) (0.14) (0.08) where HrsWrk is the number of hours the student works per week, and Frosh, Soph, and Junior are dummy variables for the student's class standing. a) If you include a dummy variable for seniors, that would cause a Hint: type one word in each blank. For the rest of questions, type a number in one decimal place. b) The expected GPA of a Sophomore who works 10 hours per week is c) The expected GPA of a Senior who works 10 hours per week is d) If Dom and Sarah work the same number of hours per week, but Dom is a Junior and Sarah is a Freshman. Dom is expected to have a higher GPA than Sarah. e) Suppose you rewrite the regression as: problem. GPA = ₁HrsWrk + ß2Frosh + B2Soph +…arrow_forwardTest Design: Suppose I want to test the impact of soccer coaches on soccer teams. How would you test this? Include a few (3 or 4) independent variables to explain the dependent variable. Describe the data and write the regression equation.arrow_forward
- Mita, the manufacturer of copiers, has been spending increasing amounts of money on radio and television advertising in recent years. An analyst employed by Mita wanted to estimate a simple linear regression of the company's annual copier sales versus advertising dollars. Th regression results included SSE = 12593 and SSR = 87663. What is the coefficient of determination for this regression? 0.874 0.935 0.144 0.126arrow_forwardSuppose the Sherwin-Williams Company is interested in developing a simple regression model with paint sales (Y) as the dependent variable and selling price (P) as the independent variable. Complete the following worksheet and then use it to determine the estimated regression line. Sales Region Selling Price ($/Gallon) Sales (x 1000 Gal) i 2 Zi Yi Zith 1 15 160 2,400 225 25,600 2 13.5 220 2,970 182.25 48,400 3 16.5 140 2,310 272.25 19,600 4 14.5 190 2,755 210.25 36,100 5 17 140 2,380 289 19,600 6 16 160 2,560 256 25,600 7 13 200 2,600 169 40,000 8 18 150 2,700 324 22,500 9 12 220 2,640 144 48,400 10 15.5 190 2,945 240.25 36,100 Total 151 1,770 2,312 Regression Parameters Estimations Slope (B) Intercept (a) In words, for a dollar increase in the selling price, the expected sales will What is the standard error of the estimate (&)? O 14.889 12.180 13.342 gallons in a given sales region. What is the estimate of the standard deviation of the estimated slope (86)? O 2.636 2.157 2.362 Can you…arrow_forwardA guidance counselor wants to determine if there is a relationship between a student's number of absences, x, and their grade point average (GPA), y. The data that were collected are displayed in the scatterplot and the least-squares regression line was calculated. One student with 2 absences has a GPA of 1.8. This point is circled on the graph. GPA and Absences 4.8 4.4 4.0 3.6 3.2 2.8 2.4 2.0 1.6 4 6 8 10 12 14 16 Absences (Days) What effect does the circled point have on the standard deviation of the residuals? This point will increase the value of the standard deviation of the residuals because it has a large positive residual. This point will increase the value of the standard deviation of the residuals because it has a large negative residual. This point will not affect the value of the standard deviation of the residuals because it has a large positive residual. This point will decrease the value of the standard deviation of the residuals because it has a large negative residual.…arrow_forward
- Find the degrees of freedom in a regression model that has 10 observations and 7 independent variablesarrow_forwardQUESTION 1 Suppose a researcher collects data on houses that have been sold in a particular neighbourhood over the past year, and obtains the regressions results in the table shown below. This table is used for Questions 1-6. Dependent variable: In(Price) Regressor (1) (2) (3) (4) (5) 0.00042 (0.000038) Size In(Size) 0.57 (2.03) 0.69 0.68 0.69 (0.055) (0.054) (0.087) In(Size)² 0.0078 (0.14) Bedrooms 0.0036 (0.037) Рol 0.082 0.071 0.071 0.071 0.071 (0.032) (0.034) (0.034) (0.036) (0.035) 0.037 0.027 0.026 0.027 0.027 (0.030) View (0.029) (0.028) (0.026) (0.029) Pool x View 0.0022 (0.10) 0.12 (0.035) Condition 0.13 0.12 0.12 (0.035) 0.12 (0.045) (0.035) (0.036) 6.63 (0.53) Intercept 10.97 6.60 7.02 6.60 (0.069) (0.39) (7.50) (0.40) Summary Statistics SER 0.102 0.098 0.099 0.099 0.099 R? 0.72 0.74 0.73 0.73 0.73 Variable definitions: Price = sale price ($); Size = house size (in square feet); Bedrooms = number of bedrooms; Pool = binary variable (1 if house has a swimming pool, 0…arrow_forwardA finance manager employed by an automobile dealership believes that the number of cars sold in his local market can be predicted by the interest rate charged for a loan. Interest Rate (%) Number of Cars Sold (100s) 3 5 10 7 8 2 The finance manager performed a regression analysis of the number of cars sold and interest rates using the sample of data above. Shown below is a portion of the regression output. Regression Statistics Multiple R0.998868 R2 0.997738 Coefficient |14.88462 Interest Rate -1.61538 Intercept 1. Are there factors other than interest rate charged for a loan that the finance manager should consider in predicting future car sales? 2. Is interest rate charged for a loan the most important factor to be considered in predicting future car sales? Explain your reasoning.The dealership's vice- president of marketing has requested a sales forecast at the prevailing interest rate of 7%. 3. As finance manager, what reasons would you convey to the vice-president in recommending…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Managerial Economics: Applications, Strategies an...EconomicsISBN:9781305506381Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. HarrisPublisher:Cengage Learning
Managerial Economics: Applications, Strategies an...
Economics
ISBN:9781305506381
Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:Cengage Learning