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 descriptive statistics, create frequency charts, recode variables, and create new variables. For this assignment, utilize SPSS Statistics and the Topic 2 “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 1. Import the Excel file into SPSS. 2. Sort by age in SPSS to determine the age-range of pa

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 descriptive statistics, create frequency charts, recode variables, and create new variables. For this assignment, utilize SPSS Statistics and the Topic 2 “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 1. Import the Excel file into SPSS. 2. Sort by age in SPSS to determine the age-range of pa

Part 1

Range for age
Statistics

Age
N Valid 30
Missing 2
Range 43

Mean and Standard Deviation for Age and annual income

Descriptive Statistics

N Mean Std. Deviation
Statistic Statistic Std. Error Statistic
Age 30 39.93 2.173 11.902
Annual_Income* 30 34766.67 4176.476 22875.500
Valid N (listwise) 30

Frequency Table for Sex, Employment and Education Level
Sex
Frequency Percent Valid Percent Cumulative Percent
Valid 2 6.3 6.3 6.3
Female 15 46.9 46.9 53.1
Male 15 46.9 46.9 100.0
Total 32 100.0 100.0

Employed
Frequency Percent Valid Percent Cumulative Percent
Valid 2 6.3 6.3 6.3
No 13 40.6 40.6 46.9
Yes 17 53.1 53.1 100.0
Total 32 100.0 100.0

Education Level
Frequency Percent Valid Percent Cumulative Percent
Valid 1 10 31.3 33.3 33.3
2 10 31.3 33.3 66.7
3 10 31.3 33.3 100.0
Total 30 93.8 100.0
Missing System 2 6.3
Total 32 100.0

Frequency Table for New Sex Variables

Sex
Frequency Percent Valid Percent Cumulative Percent
Valid 2 6.3 6.3 6.3
Female 15 46.9 46.9 53.1
Male 15 46.9 46.9 100.0
Total 32 100.0 100.0

Descriptive Statistics for BMI

Descriptive Statistics
N Mean Std. Deviation
Statistic Statistic Std. Error Statistic
BMI 30 26.7651 1.26627 6.93566
Valid N (listwise) 30

Part 2
Microsoft Excel is a data computing software that employs spreadsheets to sort data using formulas and functions. On the other hand, SPSS is used in research for sophisticated data analysis. While Excel helps in the basic computation of data, SPSS gives more detailed analysis to data that enables researchers to make more detailed inferences from data. SPSS is preferred for data management for the following reasons. First, the software has tools in its data output interface that enable the user to develop charts and tables for analyzed data.
Additionally, the software allows for the computation of qualitative data by having the string variable option while defining variables. For example, using SPSS, descriptive data for qualitative data such as age and gender can be obtained by assigning a numeric value to string variables. Consequently, the user is able to obtain the desired results on the output interface. According to (Ozgur et al.,2017) relates data that is coded numerically to the intended meaning. Besides, SPSS allows for the importation of data from other software, while in Excel, the user has to key data manually.
SPSS is best suited in analyzing demographic data as opposed to Excel. Demographic data include age, income, education and race. The data is vital in understanding the population. As a result, detailed analysis by SPSS makes it preferable to Excel when studying data. To conclude, SPSS should be recommended in data management as it has data analyzing tools that present the data more elaborately.
 

References
Ozgur, C., Dou, M., Li, Y., & Rogers, G. (2017). Selection of statistical software for data scientists and teachers. Journal of modern applied statistical methods, 16(1), 40.