please solve in excel with steps shown, and formulas as well

Run your Value Line Search, similar to the one we previously completed for Abercrombie & Fitch to download the data used to run regression analysis of current P/E ratios against retention ratios, 5 year betas, and projected EPS growth rates. However, restrict your choice of industry to Chemical (Basic Diversified, and Specialty). Run your regression analysis using Excel, check the statistical significance of the coefficients Interpret the coefficients, and generate the predicted current P/E ratio for Air Products & Chemical. What can you say about the stock? Is the stock overvalued or undervalued Run your Value Line Search, similar to the one we previously completed for Abercrombie & Fitch to download the data used to run regression analysis of current P/E ratios against retention ratios, 5 year betas, and projected EPS growth rates. However, restrict your choice of industry to Chemical (Basic Diversified, and Specialty). Run your regression analysis using Excel, check the statistical significance of the coefficients Interpret the coefficients, and generate the predicted current P/E ratio for Air Products & Chemical. What can you say about the stock? Is the stock overvalued or undervalued