INTG GC- 1055 4: Descriptive Statistics Correlation and VisualizationJava

Java Python 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 t INTG GC- 1055 Assignment 4: Descriptive Statistics, Correlation, and VisualizationJava he 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