You may need to use the appropriate technology to answer this question. The stock price (y, in $) of a certain company over a twelve-day period, the number of shares (in 1005) of company's stocks sold (x1), and the volume of exchange (in millions) on the New York Stock Exchange (x2) are shown below. Day y x1 x2 1 87.50 951 11.25 2 86.00 944 11.00 3 84.00 941 11.50 4 83.00 929 11.50 5 84.50 934 12.25 6 84.00 934 13.25 7 82.00 933 13.50 8 80.00 937 14.75 9 78.50 926 15.25 10 79.00 901 16.75 11 77.00 874 15.75 12 77.50 871 17.25 Excel was used to determine the least squares regression equation. Part of the computer output is shown below. ANOVA df SS MS F Signicance F Regression 2 115.8724 57.9362 32.4991 0.0001 Residual 9 16.0443 1.7827 Total 11 131.9167 Coefficients Standard Error t Stat P-value Intercept 86.9744 31.1639 2.79 0.0210 (x1) 0.0133 0.0294 0.45 0.6625 (X2) 1.2586 0.3336 3.77 0.0044 (a) Use the output shown above and write an equation that can be used to predict the price of the stock. (Round your numerical values to four decimal place.) )7: (b) Interpret the coefficients of the estimated regression equation that you found in part (a). (Give your answers in dollars. Round your answers to four decimal places.) As the number of shares of the stock sold goes up by 100 units, the stock price goes up by $ when the volume of exchange on the NYSE is held constant. As the volume of exchange on the NYSE goes up by 1 million, the stock price goes down by 35 when the number of shares of the stock sold is held constant. (c) Test whether or not there is a significant relationship between the stock price and the independent variables. Use a 0.01 level of significance. State the null and alternative hypotheses. O H0: [30 0 Ha: 0 = 0 O H0: 131 = 02 = 0 Ha: All the parameters are not equal to zero. 0 H0: [in = 0 Ha: 0 # 0 O H0: 131 = 02 = 0 Ha: One or more of the parameters is not equal to zero. 0 H0: One or more of the parameters is not equal to zero. Ha: \"1 = #92 = 0 Find the value of the test statistic. (Round your answer to four decimal places.) :1 Find the p-value. (Round your answer to four decimal places.) State your conclusion. O Do not reject Ho. There is insufficient evidence to conclude there is a significant relationship between the stock price and the independent variables. Do not reject Ho. There is sufficient evidence to conclude there is a significant relationship between the stock price and the independent variables. O Reject Ho. There is sufficient evidence to conclude there is a significant relationship between the stock price and the independent variables. O Reject Ho. There is insufficient evidence to conclude there is a significant relationship between the stock price and the independent variables. (d) At a 0.01 level of significance, determine which variables are significant and which are not. Perform the test of significance for the number of shares (in 100s) of company's stocks sold. Ho: B1 = 0 Ha: B 1 # 0 Find the value of the test statistic. (Round your answer to two decimal places.) Find the p-value. (Round your answer to four decimal places.) p-value = What is your conclusion at the 0.01 level of significance? O Do not reject Ho. There is insufficient evidence to conclude that the number of shares (in 100s) of company's stocks sold is a significant factor. O Reject Ho. There is insufficient evidence to conclude that the number of shares (in 100s) of company's stocks sold is a significant factor. O Reject Ho. There is sufficient evidence to conclude that the number of shares (in 100s) of company's stocks sold is a significant factor. O Do not reject Ho. There is sufficient evidence to conclude that the number of shares (in 100s) of company's stocks sold is a significant factor. (e) If on a given day, the number of shares of the company that were sold was 94,100 and the volume of exchange on the New York Stock Exchange was 19 million, what would you expect the price (in $) of the stock to be? (Round your answer to two decimal places.) $