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.

1.
Please perform Hypothesis
testing for two samples on the data by
doing the following (Hint: Chapter 11, total 25 points)

a. Write down one research question that you could answer using
Hypothesis Testing for two samples with the Happiness_2011.xls
datasetand state its null and alternative hypotheses (5 points)

b. Organize the data and show in Excel and perform F-test on the
variance first to check on the variance (treat both interval variables and
ordinal variables as interval variables for this exam) (5 points).

c. Perform t-test Hypothesis testing for two samplesâ€™ means using two
variables from Happiness_2011.xls dataset (one quantitative
variable and one qualitative group variable with only two values) and show the
analysis results for the question (10 points);

d. Indicate whether you reject or accept the null hypothesis and Interpret
your findings from the analysis (5 points)

Note:

i.
in Excel, copy and paste the interval data about a two categories
into two columns and then perform analysis.

ii.
For the test, please watch the video under Chapter 11:F Test
(Test of equal variance) in Excel using data analysis: http://www.youtube.com/watch?v=hI5VZp7Ibiw
and then choose between equal variance (http://www.youtube.com/watch?v=X65pklzSUTI) and unequal variance
t-test (http://www.youtube.com/watch?v=SHOSNYLrhus).

2.
Please Perform ANOVA One-Factor
Analysis by doing the following (Hint: Chapter 12, ANOVA,, total 25 points):

a. 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);

b. Organize the data and show them in
MS Excel (5 points)

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);

d. Indicate whether you reject or
accept the null hypothesis and Interpret your findings from the analysis (5
points)

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)

3.
Please Perform one Chi-square
Test by doing the following (Hint: Chapter 15/17, Nonparametric Methods: Chi-Square, 20 points):

a. 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);

b. Organize the data and show in MS
Excel first and then 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);

d. Indicate whether you reject or
accept the null hypothesis and Interpret your findings from the analysis (5
points);

Note:

iii.
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

iv.
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

4.
Please Perform regression
analysis by doing the following (Hint: Chapter 13 on simple regression and 14
on multiple regression, 30 points):

a. Write down potential questions
that you could answer using regression analysis for the Happiness_2011.xls dataset (5 points);

b. Organize the data first and then
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);

c. Interpret the findings from the
simple regression analysis (5 points);

d. 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 (5 points)

e. Interpret your findings from the
multiple regression analysis (5 points).

Note:

i.
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.

ii.
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

iii.
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

Get Higher Grades Now

Tutors Online