Question 1:
|
Movie
|
Twitter Activity
|
Receipts
|
|
The Devil Inside
|
219509
|
14763
|
|
The Dictator
|
6405
|
5796
|
|
Paranormal Activity 3
|
165128
|
15829
|
|
The Hunger Games
|
579288
|
36871
|
|
Bridesmaids
|
6564
|
8995
|
|
Red Tails
|
11104
|
7477
|
|
Act of Valor
|
9152
|
8054
|
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
|
Transformational
|
Transactional
|
Control
|
|
0
|
2
|
6
|
|
7
|
5
|
5
|
|
3
|
3
|
8
|
|
5
|
0
|
9
|
|
2
|
1
|
5
|
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).
|
Response
|
Male
|
Female
|
Total
|
|
Not at all
|
23
|
25
|
48
|
|
Somewhat
|
13
|
22
|
35
|
|
Very
|
26
|
16
|
42
|
|
Total
|
62
|
63
|
125
|
|
|
|
|
|
|
|
|
|
|
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