SPSS is a software that can conduct basic and complex statistical analyses. In this assignment, you will use SPSS to explore the data and conduct descriiptive statistics, create frequency charts, recode variables, and create new variables.
For this assignment, utilize SPSS Statistics and the “Health Behavior Data Set.”
Refer to the topic Resources for assistance with accessing and using SPSS.
Follow the steps below to complete the assignment.
Part 1
Import the Excel file into SPSS.
Sort by age in SPSS to determine the age-range of participants in the data set.
Use the Descriiptive Statistics Feature in SPSS to find the mean and standard deviation for the “Age” and “Annual Income.”
Use the “Frequencies” feature to create frequency tables for the employed, education level and sex variables.
Recode the sex variable where “Male”=1 and “Female”=2. Create a frequency table for the new variable.
Compute a new “BMI” variable based on “Weight” and “Height.” Use the Descriiptive Statistics Feature in SPSS to find the mean and standard deviation for the new BMI variable.
Part 2
In 200-250 words, compare Excel and SPSS. Discuss specific SPSS software features that make it preferable to Excel for data management. Provide examples illustrating when electing to use SPSS could be preferable to Excel in regard to analyzing survey data.
General Requirements
Submit the SPSS exported output and the 200–250-word Excel and SPSS comparison to the assignment dropbox.
APA style is not required, but solid academic writing is expecte