The prices (in $) of Rawlston, Inc. stock (y) over a period of 12 days, 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

(x₂)

are shown below.

Day	y	x1	x2
1	87.50	951	10.75
2	86.00	944	11.50
3	84.00	941	12.00
4	83.00	931	12.00
5	84.50	934	11.75
6	84.00	934	13.25
7	82.00	933	13.00
8	80.00	939	14.25
9	78.50	926	15.25
10	79.00	901	16.75
11	77.00	874	16.75
12	77.50	871	17.75

Excel was used to determine the least squares regression equation. Part of the computer output is shown below.

	df	SS	MS	F	Significance F
Regression	2	117.8205	58.9103	37.6126	0.0000
Residual	9	14.0961	1.5662
Total	11	131.9167

	Coefficients	Standard Error	t Stat	P-value
Intercept	116.6540	33.7992	3.45	0.0073
(x1)	0.0148	0.0318	0.47	0.6519
(x2)	1.5315	0.3579	4.28	0.0021

Questions:

1) Use the output shown above and make equation that can be used to predict the price of the stock. (Round your numerical values to four decimal place. ) =???

2) 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 down 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 $=??? when the number of shares of the stock sold is held constant.

3) At a 0.01 level of significance, determine which variables are significant and which are not.State the null and alternative hypotheses for the number of shares (in 100s) of company's stocks sold. (Enter != for as needed.)

4) Find the value of the test statistic. (Round your answer to two decimal places.) ???

5) Find the p-value. (Round your answer to four decimal places.)

P-Value=???

6) What is your conclusion at the 0.01 level of significance?

Answers options:

a) Do not reject H₀. There is insufficient evidence to conclude that the number of shares (in 100s) of company's stocks sold is a significant factor.

b) Reject H₀. There is insufficient evidence to conclude that the number of shares (in 100s) of company's stocks sold is a significant factor.

c) Do not reject H₀. There is sufficient evidence to conclude that the number of shares (in 100s) of company's stocks sold is a significant factor.

d) Reject H₀. There is sufficient evidence to conclude that the number of shares (in 100s) of company's stocks sold is a significant factor.

8) Find the value of the test statistic. (Round your answer to two decimal places.)???

9) Find the p-value. (Round your answer to four decimal places.)???