The linear regression is Y= -8222.8x + 123,367 R?=0.6503 oan oo Is the price variable statistically significant at the 5% level? How do you know? How much of the variation in quantity is explained by price? If price is $100, what is our predicted quantity? If | raise my price by $5, what would be our predicted change in gquantity? Create a scatter plot with a linear trendline through the data points. (Hint: the videos on D2L, in particular \"Doing a Regression in Microsoft Excel, are helpful here). One way to add a trendline is to select a data point, right-tlick that point, and then choose \"Add Trendline\") Choose the options where the trendline equation and R-squared are displayed. The Linear regression is Y= -0.0022x + 132.02 R2= 0.6503 f.- B h. i e Which of these explanatory variables are significant at the 5% level? Which of these explanatory variables are significant at the 1% level? How much of the variation in quantity is explained by the explanatory variables? If price rises by $1, what would be our predicted change in quantity? If the unemployment rate falls by 1 percentage point, what would be our predicted change in quantity