PLEASE!! read The question and answer Part C. I already have a and b. please include all steps to do part c on excel formula and numbers used and explanation

The following were the PE ratios of he firms in the aerospace/defense industry at the end of December 1993, With additional data on expected growth and risk Company PE Ratio Expected Growth Beta Payout Boeing 17.3 3.50% 1.10 28% General Dynamics 15.5 11.50% 1.25 40% General Motors- Hughes 16.5 13.00% 0.85 41% Grumman 11.4 10.50% 0.80 37% Lockheed Corporation 10.2 9.50% 0.85 37% Logicon 12.4 14.00% 0.85 11% Loral Corporation 13.3 16.50% 0.75 23% Martin Marietta 11.0 8.00% 0.85 22% McDonnell Douglas 22.6 13.00% 1.15 37% Northrop 9.5 9.00% 1.05 47% Raytheon 12.1 9.50% 0.75 28% Rockwell 13.9 11.50% 1.00 38% Thiokol 8.7 5.50% 0.95 15% United Industrial 10.4 4.50% 0.70 50% Total 14 184.80 139.50% 12.90 454.00% Average 13.2 9.96% 0.92 32%

a. Estimate the average and median PE ratios. What, if anything, would these averages tell you?

b. An analyst concludes that Thiokol is undervalued, because its PE ratio is lower than the industry average. Under what conditions is this statement true? Would you agree with it here?

c. Using a regression, control for differences across firms on risk, growth, and payout. Specify how you would use this regression to spot under- and over- valued stocks. What are the limitations of this approach?