PLEASE answer all 3 parts. (You need to use excel):

1. Consider the data set on airline seats in this Lecture module. Using excel run regression to find coefficients for a model that tries to explain number of airline seats as a function of price, competitor price and income. In this case the coefficient on the price variable is _____.
Answer Choices: (A) -1.91 (B) -2.12 (C) -2.88 (D) -3.44

2. Using the excel estimates for the coefficients from the airline seats data, rounded at 100th place, what would the estimated number of seats be if P = 229, Pc = 245 and I = 112?
Answer Choices: (A) 142.76 (B) 150.44 (C) 133.10 (D) 128.88

3. One last time, using the excel estimates for the model of airline seats, what is the error term for the second data point?
Answer Choices: (A) -5.49 (B) -4.77 (C) -4.05 (D) -3.33

PLEASE answer all 3 parts You need to use excel 1 Consider the data set on airline seats in this Lecture module Using excel run regression to find coefficients class=