PUB 550 Introduction to SPSS

PUB 550 Introduction to SPSS

PUB 550 Introduction to SPSS

Part 1

Table 1: Descriptive Statistics for Age and Annual Income

  N Range Minimum Maximum Mean Std. Deviation
Age 30 43 18 61 39.93 11.902
Annual Income 30 80000 5000 85000 34766.67 22875.500
Valid N (listwise) 30          


Frequencies for Employed, Educational Level, and Sex Variable

Table 2: 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  


Table 3: 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    


Table 4: 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 the BMI Variable

Click here to ORDER an A++ paper from our Verified MASTERS and DOCTORATE WRITERS: PUB 550 Introduction to SPSS

Descriptive Statistics

  N Mean Std. Deviation
BMI 30 .0381 .00987
Valid N (listwise) 30    


Part 2

SPSS Software is commonly applied in the statistical analysis for different researchers. The software is simpler

PUB 550 Introduction to SPSS
PUB 550 Introduction to SPSS

compare to the Microsoft Excel where there is the need for one to inset formulas in determining both the descriptive and inferential statistics. Even though Microsoft Excel has advanced, Excel Ad in for quicker data analysis, this feature lacks some data analysis procedure. SPSS Software is easier to use, it also offers reliable and fast answers in the process of data analysis (Rose et al., 2017). Unlike Microsoft Excel, SPSS has a very dynamic as well as the useful tables and graphs. SPSS has inbuilt large number of statistical tests compared to the Microsoft Excel, as a result, different statistical tests can be performed at simultaneously (Larson-Hall, 2015).

SPSS and Microsoft Excel have similar feel and look as a result of menus, built-in statistical functions, and spreadsheets (Chaamwe & Shumba, 2016). However, SPSS is a definite winner in the processes of data analysis (Bernard et al., 2019). Compared to the Microsoft Excel, SPSS has a wide range of graphs and charts to choose from. It also offers a faster access to the statistical tests. Finally, with SPSS, there is always an easier and quicker access to the basic functions such as descriptive statistics in the pull-down menus (Bala, 2016). With SPSS, there is always though data management features that makes it preferred by many researchers. There are instances when electing to use SPSS could be preferable to Microsoft Excel in regard to analyzing survey data (Khan, 2016). For example, when running hypothesis tests, SPSS provides elaborate and direct approaches the lead to the accuracy in the outcomes. Also, when running frequencies, SPSS provides elaborate approaches compared to Microsoft Excel where an individual have to compute the pivot tables (MacInnes, 2016).


Bala, J. (2016). Contribution of SPSS in Social Sciences Research. International Journal of Advanced Research in Computer Science7(6). Retrieved from:

Bernard, M., Akbar, P., Ansori, A., & Filiestianto, G. (2019, October). Improve the ability of understanding mathematics and confidence of elementary school students with a contextual approach using VBA learning media for Microsoft Excel. In Journal of Physics: Conference Series (Vol. 1318, No. 1, p. 012035). IOP Publishing. Retrieved from:

Chaamwe, N., & Shumba, L. (2016). ICT integrated learning: using spreadsheets as tools for e-learning, a case of statistics in microsoft excel. International Journal of Information and Education Technology6(6), 435-440. Retrieved from:

Khan, H. A. (2016). SCEW: a Microsoft Excel add-in for easy creation of survival curves. Computer methods and programs in biomedicine83(1), 12-17. Retrieved from:

Larson-Hall, J. (2015). A guide to doing statistics in second language research using SPSS and R. Routledge.

MacInnes, J. (2016). An introduction to secondary data analysis with IBM SPSS statistics. Sage.

Rose, J. M., Black, I. R., Ioannou, C., & Efron, A. (2017). Using Microsoft Excel as an alternative survey instrument. In CD-Rom of the ISCTSC conférence. Retrieved from:,%20Black,%20Ioannou%20and%20Efron%20Costa%20Rica%20submitted.pdf