Answer To: University of La Verne Winter 2020 EXAM #4 XXXXXXXXXXNAME_______________________________ BUS500C...
Monali answered on May 22 2021
University of La Verne Winter 2020
EXAM #4 NAME_______________________________
BUS500C GRADES _____________________________
Warning: While it is an open book, please work on the exam by yourself and do not communicate with anyone about the exam.
Instruction: The final submission can either be in Excel or in this MS Word file or with both; your answers should be based analyzing the MS Excel file Happiness_2011.xls on the Happiness Survey under Exam 4; MS Excel file is organized with multiple datasheet for you in the Happiness_2011.xls file. In this exam, you can treat ordinal variables as interval variables.
Please Perform ANOVA One-Factor Analysis by doing the following (Hint: Chapter 12, ANOVA):
Organize the data and show in MS Excel (5 points);
Data of Level of Happiness and Level of EQ is organized in 3 levels. This is sorted and arranged in excel under tab of ANOVA.
Write down one question that you could answers using ANOVA One Factor analysis with the Happiness_2011.xls dataset and state its null and alternate hypotheses (5 points);
We can test if group on levels of Happiness is the same as groups on three levels of EQ. Logically, higher level of emotional quotient will lead to higher level of happiness. Therefore, we can check if there is difference in mean of three levels which are divided under two groups of happiness and EQ.
Null hypothesis: There is no difference between group of Happiness and EQ levels, µ1 = µ2
Alternative hypothesis: There is difference between groups of happiness and EQ levels, in other words it means, µ1 ≠ µ2
c. Perform one ANOVA One-Factor analysis using two reasonable variables from the Happiness_2011.xls dataset (one quantitative variable and one qualitative group variable) and show the analysis results for the question (10 points);
Summary of one-way ANOVA test is as below;
SUMMARY
Groups
Count
Sum
Average
Variance
Happiness (Level)
3
101
33.66667
433.3333
EQ (Level)
3
101
33.66667
97.33333
ANOVA
Source of Variation
SS
df
MS
F
P-value
F crit
Between Groups
0.0000
1.0000
0.0000
0.0000
#NUM!
7.7086
Within Groups
1061.333
4
265.3333
Total
1061.333
5
d. Indicate whether you reject or accept the null hypothesis (5 points);
Mean of both groups are equal = 33.667.
F critical value 7.7086 > F test value 0.00. Based on this null hypothesis cannot be rejected.
A large F ratio means that variation among group, by chance, is more than expected. In this case F- test calculated is 0.00. Therefore, based on mean both groups being equal and small F value, we conclude that there is no variation among group is not by chance.
e. Interpret your findings from the analysis (5 points).
Based on one-way ANOVA, we conclude that there is no different in groups of Happiness level and EQ levels. In other words, happiness and EQ would have the same effect across age.
Note:
i. in Excel, you may use Sort function to select the data under different categories from the dataset, and then use the organized dataset to perform the analysis.
ii. For one-way/factor ANOVA test, please watch the video under Chapter 12: One way/factor ANOVA: www.youtube.com/watch?v=leHOBf_-9kM)
2. Please Perform one Chi-square Test by doing the following (Hint: Chapter 15/17, Nonparametric Methods: Chi-Square):
a. Organize the data and show in MS Excel (5 points);
Two categorical variables are relationship and Health levels.
Relationship is divided into Divorced, Married, Separated, Never married and Married.
Health Level are divided into 4 with Healthy, Very Healthy, Poor health and Very Poor health.
Data is organized in Excel under tab of “Chi Square”
b. Write down one potential question that you could answers using Chi-square test with the Happiness_2011.xls dataset and state its...