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);
- 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);
- 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);
- Indicate whether you reject or accept the null hypothesis (5 points);
- Interpret your findings from the analysis (5 points).
Note:
- 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.
- For one-way/factor ANOVA test, please watch the video under Chapter 12: One way/factor ANOVA: www.youtube.com/watch?v=leHOBf_-9kM)
- Please Perform one Chi-square Test by doing the following (Hint: Chapter 15/17, Nonparametric Methods: Chi-Square):
- Organize the data and show in MS Excel (5 points);
- Write down one potential question that you could answers using Chi-square test with the Happiness_2011.xls dataset and state its null and alternate hypotheses (5 points);
- Perform one Nonparametric Methods: Chi-Square Test using any two reasonable variables from the Happiness_2011.xls dataset (two qualitative variables) and show the analysis results for the question (10 points);
- Indicate whether you reject or accept the null hypothesis (5 points);
- Interpret your findings from the analysis (5 points).
Note:
- in Excel, you may use PivotTable function to build your contingency table from the dataset, and then use the table to perform the analysis. See Video under Chapter 1: How to build a PivotTable in Excel (optional): http://www.youtube.com/watch?v=7zHLnUCtfUk
- For Chi-square test, please watch the video under Chapter 15/17:: Chi-Square Test (Test of Contingency Table or Test for Independence) In Excel using data analysis: http://www.youtube.com/watch?v=WDLMhwuNATY
- Please Perform regression analysis by doing the following (Hint: Chapter 13 on simple regression and 14 on multiple regression):
- Organize the data and show in MS Excel (5 points);
- Write down potential questions that you could answer using regression analysis for the Happiness_2011.xls dataset (5 points);
- Perform one simple regression using any two reasonable variables from the Happiness_2011.xls file (two quantitative variables) and show the analysis results (10 points);
- Interpret the findings from the simple regression analysis (5 points);
- Add one or more quantitative variable (including dummy variable that have values of 0 and 1) to the analysis in #b, perform one multiple regression analysis (10 points)
- Interpret your findings from the multiple regression analysis (5 points).
Note:
- in Excel, you may copy the columns of the variables you want to analyze from the Happiness_2011 dataset and paste them next to each other in a new datasheet.
- For simple regression analysis, please watch the video under Chapter 13: simple regression basics (Excel): http://www.youtube.com/watch?v=8JOJ_7R_OWY and its interpretation explanation of simple regression: http://www.youtube.com/watch?v=c5blVUkkjTM
- For multiple regression analysis, please watch the video under Chapter 14: Multiple regression analysis using Excel: http://www.youtube.com/watch?v=720_5tv_JDs and Multiple regression analysis interpretation: http://www.youtube.com/watch?v=i7ml3SbWd0w; Multiple regression analysis with dummy variables: http://www.youtube.com/watch?v=F0tRzIjDoTs
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but splendidwritings.com proved they are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 14***| Rating: ⭐⭐⭐⭐⭐
"The company has some nice prices and good content. I ordered a term paper here and got a very good one. I'll keep ordering from this website."
