I need help with the test statistic! I dont know what to do with the excel

A price-earnings ratio or P/E ratio is calculated as a firm's share price compared to the income or profit earned by the firm per share, Generally, a high P/E ratio suggests that investors are expecting higher earnings growth in the future compared to firms with a lower P/E ratio. The data accompanying this exercise show P/E ratios for 30 firms. Click here for the Excel Data File a. Select the null and the alternative hypotheses in order to test whether the P/E ratio of all firms differs from 15 H0:=15;HA:15H01=15;HA=15 b-1. Calculate the value of the test statistic. (Round final answer to 3 decimal places.) Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you A price-earnings ratio or P/E ratio is calculated as a firm's share price compared to the income or profit earned by the firm per share, Generally, a high P/E ratio suggests that investors are expecting higher earnings growth in the future compared to firms with a lower P/E ratio. The data accompanying this exercise show P/E ratios for 30 firms. Click here for the Excel Data File a. Select the null and the alternative hypotheses in order to test whether the P/E ratio of all firms differs from 15 H0:=15;HA:15H01=15;HA=15 b-1. Calculate the value of the test statistic. (Round final answer to 3 decimal places.) Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you