Statistical Measurements, Analysis & Research
INTG GC- 1055
MEMORANDUM
RE: Assignment 4: Descriptive Statistics, Correlation, and Visualization
Complete the following exercises. Make sure to include ALL calculations and outputs to receive full credit. Be concise and specific in your answers.
1) A company employs 300 people. Each of them is asked how long they have worked at the company, in years. Answer the following questions, given the frequency distribution below:
a) What is the mode?
b) What is the median?
c) What percent report that they have worked at the company for more than 10 years?
d) What proportion report that they have worked at the company at least 5 but less than 10 years?
2) Using SPSS and for each of (a), (b), and (c) below, generate a dataset with n = 20 cases on X and Y and then a corresponding scatterplot depicting each the following. Copy your scatterplot into your response.
a) a large positive but not perfect correlation between X and Y.
b) a correlation of about zero between X and Y.
c) a negative correlation weaker than the correlation between X and Y in your response to (a) but not a perfect negative correlation.
For each of (a), (b), and (c) calculate the Pearson correlation between X and Y using and copy the output showing the correlation into your response.
3) Open BevXPfin.sav in SPSS and familiarize yourself with the data and SPSS layout. Check the original survey BevXP Statistics Course. Please provide all tables and interpretations of results where needed in Word or PDF file. Provide Output file as Word.
a) Data Preparation
i) Clean data
(1) Provide descriptives for Age variable and report maximum and minimum values
(2) Select cases based on Age between 21 and 85. Report how many cases are excluded.
(3) Select cases based on Income and exclude those that “prefer not to answer” that question (option 9). Report how many cases are excluded.
(4) Keep the file with selection of cases based on income variable for further analysis.
ii) Compute new variables
(1) Satisfaction - average of Sat1, Sat2, and Sat3
(2) WOM - average of WoM1, WoM2, WoM3, and WoM4
(3) Return_Intention - average of RI1, RI2, and RI3
(4) Social_Environment - average of Soc1, Soc2, Soc3 Soc4 and Soc5
iii) Recode Income into different variable (Income_levels) with three levels: 1) Low Income $0 – $50,000; 2) Medium Income – $50,001 – $100,000; and 3) High Income –
$100,001 and above
iv) Create and interpret Box Plots for
(1) Satisfaction
(2) WOM
(3) Return_Intention
b) Descriptive Analysis
i) Create Bar Charts and interpret them in one sentence
(1) Bar type and age
(2) Education (frequency)
ii) Create Histograms and interpret them in one sentence
(1) Age
(2) Satisfaction
iii) Create Pie Charts and interpret them in one sentence
(1) Gender
(2) Ethnicity
(3) Income_levels
iv) Create population Pyramid - Age based on Gender Split
v) Create Frequency tables and interpret them in one sentence
(1) Sub_type
(2) Live_entertainment
(3) Food_offer
(4) Beverage_order
c) Univariate Statistics – Explore Variables and report means, standard deviations, and 95% confidence interval
i) Satisfaction
ii) WOM
iii) Return_Intention
d) Split File based on income_levels
i) Compare Pie Charts and report differences between income groups for
(1) Gender
(2) Ethnicity
ii) Compare Means and report differences between income groups for
(1) Satisfaction
(2) WOM
(3) Return_Intention
iii) Compare Frequencies and report differences between income groups for
Beverage_order
iv) Merge file back together
e) Bivariate Analysis
i) Create Scatter Plots interpret them in one sentence for
(1) Social_Environment and Satisfaction
(2) Satisfaction and WOM
(3) Satisfaction and Return_Intention
ii) Create Cross tabulations interpret them in one sentence for
(1) Beverage_Order and Gender
(2) Education and Income_level
iii) Calculate Correlation interpret them in one sentence (explain if they are large or small) for pairs
(1) Social_Environment and Satisfaction
(2) Satisfaction and WOM
(3) Satisfaction and Return_Intention
iv) Create Correlation Matrix with 1) Social_Environment, 2) Satisfaction, 3) WOM, and
4) Return_Intention
版权所有:编程辅导网 2021 All Rights Reserved 联系方式:QQ:99515681 微信:codinghelp 电子信箱:99515681@qq.com
免责声明:本站部分内容从网络整理而来,只供参考!如有版权问题可联系本站删除。