The stock price (y, in $) of a certain company over a twelve-day period, the number of shares (in 100s) of company's stocks sold (x,), and the volume of exchange (in millions) on the New York Stock Exchange (x2) are shown below. Day V X1 X2 87.50 951 11.25 2 86.00 946 11.00 3 84.00 941 12.00 4 83.00 929 11.50 5 84.50 936 11.75 6 84.00 934 13.25 82.00 933 13.00 8 80.00 939 14.75 9 78.50 924 15.2 10 79.00 899 16.75 11 77.00 876 16.75 12 77.50 869 17.25 Excel was used to determine the least squares regression equation. Part of the computer output is shown below. ANOVA dt SS MS F Significance F Regression 2 116.1289 58.0645 33.1004 0.0001 Residual 9 15.7877 1.7542 Total 11 131.916 Coefficients Standard Error t Stat P-value Intercept 89.0757 31.4078 2.84 0.0195 (x 1 ) 0.0112 0.0295 0.38 0.7138 (x2 ) -1.2753 0.3409 -3.74 0.0046 (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.) y =(b) Interpret the coefcients 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 as 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 3; 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 HO: One or more of the parameters is not equal to zero. Ha:,81=2=0 OHO:,B0 Ha:,80=0 uHu:1:2=0 Ha: All the parameters are not equal to zero. uHu:1:2=0 Ha: One or more of the parameters is not equal to zero. O HO: n : D Ha: ,6\" at 0 Find the value of the test statistic. (Round your answer to four decimal places.) 2 Find the p-value. {Round your answer to four decimal places.) State your conclusion. 0 Reject H\". There is sufficient evidence to conclude there is a signicant relationship between the stock price and the independent variables. 0 Reject H\". There is insufficient evidence to conclude there is a significant relationship between the stock price and the independent variables. 0 Do not reject Ho' There is sufficient evidence to conclude there is a signicant relationship between the stock price and the independent variables. 0 Do not reject H0. 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. H0: 191 = 0 Ha: l #0 Find the value of the test statistic. (Round your answer to two decimal places.) 2 Find the p-value. (Round your answer to four decimal places.) What is your conclusion at the 0.01 level of signicance? 0 Reject H0. There is insufficient evidence to conclude that the number of shares (in 1005) of company's stocks sold is a signicant factor. Q Do not reject H0. There is sufficient evidence to conclude that the number of shares (in 1005) of company's stocks sold is a significant factor. 0 Do not reject H0. There is insufficient evidence to conclude that the number of shares (in 1005) of company's stocks sold is a significant factor: 0 Reject H . There is sufficient evidence to conclude that the number of shares (in 1005) of company's stocks sold is a significant factor