The prices $($in $$)$ of Rawlston, Inc. stock $(y)$ over a period of $12$ days, the number of

shares $($in $100$s$)$ of company's stocks sold $(x_1),$ and the volume of exchange $($in

millions$)$ on the New York Stock Exchange $(x_2)$ are shown below.

Using Excel, run a regression analysis and answer the following questions:

Write an equation that can be used to predict the price of the stock following

the format given $($Ex: $"$y $=0\mathrm{.}0000+0\mathrm{.}00001+0\mathrm{.}00002").$ To avoid

problems do a copy$/$paste of the example, and replace the zeros and $+$ by the

correct numbers and sign using the same format: rounded to $4$ decimals.

Is the model significant at a $0\mathrm{.}05$ level?

What is the p$-$value that justifies your answer $($rounded to $4$ decimals$)$

Is the variable $x1$ significant at a $0\mathrm{.}05$ level?

Is the variable $2$ significant at a $0\mathrm{.}05$ level?

What percentage of variability in price is explained by the model $($give it as a

number between $0$ and $1,$ rounded to $2$ decimals, and without a percentage

sign?