frequency methodology- problem

 

Upload the Excel data file Career in SPSS and save it in SPSS data format for future use. The data file is available on GAP under “Supplemental Material” folder.  Complete the following tasks and copy your results in a word document and submit your report. 

Note: If you do not have access to SPSS, you can do this assignment in Excel. 

• Build a frequency table for the variable Age.
• Compose standardized values for the variable Family Income. Report key descriptive statistics for this variable. Make sure your report table includes measures of kurtosis and skewness. 
• Sketch a histogram for the variable Family Income. Based on your visual inspection and measures of kurtosis and skewness, what is your conclusion regarding the shape of the distribution?   
• Create a cross tabulation of Education vs Income and interpret the result.