Question 1:

Part 1:

A. What is the independent variable (X) and what is the dependent variable (y)

B. Write a null and alternative hypothesis statement

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!

Question 2:

ANOVA

An experiment was conducted to determine if motivational techniques in management significantly impacted employee stress levels compared to no intervention.  An employee survey was given to three groups: one group under a manager who started using a transformational motivation technique, one group under a manager who began using a transformational motivation technique, and then a control group with no new technique used.  Stress levels were self-reported by the employees as shown below.  Use alpha = 0.05

1. What is your null hypothesis?

2. What is your alternative hypothesis?

3. After running the single factor analysis of variance on the data, what is the p-value for between groups?

4. Using the 95% significance level, is there a significance difference in stress levels between the three groups?

Yes                        No

5. Do you reject or accept the null hypothesis?

Reject                   Accept

Chi-Square Test for Independence 

Using Chi-Square, we are looking to see if there is a significant difference between what we would expect results to be, and what the actual results were.  That is, expected vs. observed.   Use alpha = .05

Listed below are data from a survey conducted recently where Males and Females responded to their happiness with their supervisor (this is fictitious data). 

What is your null hypothesis?

What is your alternative hypothesis?

What is the Chi-Square value?

Is there significance evidence that a difference exists between the actual males and female responses in this sample and the expected male/female responses in the population?  YES OR NO

Attachment:- retirement funds.xlsx