Posted by Ed on Monday, June 4, 2007 at 7:32pm.
4) The manager of Collins Import Autos
believes that the number of cars
sold in a day (Q) depends on two
factor: (1) the number of hours the
dealership is open (H) and (2) the
number of salespersons working that
day (S). After collecting the data
for two months (53 days), the
manager estimates the following log-
Q = aH S
a) Explain how to transform this log-
linear model into a linear form
that can be estimated using
multiple regression analysis.
The computer output for the multiple regression analysis is shown below:
Dependant Variable: LNQ
R-Square: 0.5452 F-Ratio: 29.97
P-Value on F: 0.0001
Parameter Est: o.9162
Standard Error: 0.2413
Parameter Estimate: 0.3517
Standard Error: 0.1021
Parameter Est: 0.2550
Standard Error: 0.0785
b) How do you interpret coefficients
b and c?If the dealership increases
the number of salespersons by 20
percent, what will the percentage
increase in daily sales?
c) Test the overall model for
statistical significance at the 5%
d) What percent of the total variation
in daily auto sales is explained by
What could you suggest to increase
e) Test the intercept for statistical
significance at the 5% level
Significance. If H and S both equal
0, are the sales expected to be 0?
Explain why or why notů..
f) Test the estimated coefficient b
for statistical significance. If
the Dealership decreases its hours
of operation by 10%, what is the
expected impact on daily sales?
a) transform natural log values to linear values using e^x.
b) Parameter estimates in a log-linear function are elasticities.
c) what does the F statistic tell you?
d) what does the R^2 statistic tell you.
e) what does the T-ratio statistics on the parameter estimates tell you?
f) re-examine answers b and e
No one has answered this question yet.
Answer this Question
Math - How would you solve this using a chart? Rodney sold twice as many cars as...
Algebra Word problem - Suppose you are an event coordinator for a large ...
math 117 - Suppose you are an event coordinator for a large performance theater...
college - Suppose that the number of cars, C, on 1st Avenue in a city over a ...
Accounting - Kam Motor Company manufactures automobiles. During September 2007 ...
accounting - Kam Motor Company manufactures automobiles. During September 2007 ...
Math - Suppose that the number of cars, C, on 1st Avenue in a city over a period...
Math - Monday, Mr. C stacked a display case of 80 heads of lettuce. By end of ...
statistics - The number of cars sold annually by used car salespeople is ...
Algebra - Suppose you are an event coordinator for a large performance theater. ...
For Further Reading