C.     What is the R-squared value and interpret it’s meaning?

D.    What is the correlation coefficient and interpret it’s meaning?

E.     Predict the receipts for a movie that has a Twitter activity of 100,000 using the linear regression formula generated after you run the regression analysis in Excel (just like we did in the lecture notes)

F.     At the 95% significance level, is there significant evidence of a relationship between Twitter activity and receipts?

G.    Do you accept or reject the null hypothesis?

H.    Based upon your answers above, provide us with a paragraph (3-4 sentence) conclusion that would be appropriate to explain the results to a senior executive that isn’t as familiar with statistics as you are!

Part 2 – Two Sample Hypothesis Testing

Using the Retirement funds spreadsheet, please determine if there is a significant difference between the average rate of return on Large Value and Large Growth stock funds.

I.      What are the two variables of interest?

J.      Write a null and alternative hypothesis statement

K.     At the 95% significance level, is there significant evidence of a difference between fund rate of returns?

L.     Do you accept or reject the null hypothesis?

M.   Based upon your answer above, provide us with a paragraph (3-4 sentence) conclusion that would be appropriate to explain the results to a senior executive that isn’t as familiar with statistics as you are!