1. Interpreting Regression Output: Your client wants to determine whether there is a correlation between money spent on TV advertisements and sales. You were given the following data to input into excel:

Based on this data:

1. How good is your model?

2. What percentage of the variation is explained by the variables included?

3. What is the probability that the regression model is wrong and needs to be discarded?

4. Where can I get the figures needed to create the regression equation?

5. What is the regression equation for the above?

6. If the client spends $2 on TV ads, what is the resulting, expected sales?