In Illustration 4.2 on page 140 of the textbook, a linear regression model was employed to determine
Question: In Illustration 4.2 on page 140 of the textbook, a linear regression model was employed to determine whether the auto insurance premiums (P) can be adequately explained differences in costs across counties in California. Two variables were used to measure costs: (1) the number of claims per thousand insured vehicles (N) , and the average dollar amount of each bodily injury claim (C) .
a. Estimate the following log-linear regression model using the data provided in Illustration 4.2. (10 pts)
P = aNb Cc
(Copy and paste here your computer printout).
b. Write the estimated log-linear model of bodily injury claims. (6 pts)
c. Provide a complete analysis (report) of your regression results (Note: Describing and correctly interpreting regression estimation result is equally as important as actually (if not more important) actually conducting the estimation). Emulating the textbook in this regard may prove to be useful. (35 pts)
d. Compare which model (the linear model in Illustration 4.2 and the log linear model you have estimated here} does a better job overall of explaining the variation in auto premiums (P)? Why? (5 pts)
Deliverable: Word Document
