Calculating Basic Statistical Procedures in SPSS by John R. Slate, Ana Rojas-LeBouef - HTML preview

PLEASE NOTE: This is an HTML preview only and some elements such as links or page numbers may be incorrect.
Download the book in PDF, ePub, Kindle for a complete version.

Chapter 2Calculating Descriptive Statistics

ncpealogo.gif

This Chapter has been peer-reviewed, accepted, and endorsed by the National Council of Professors of Educational Administration (NCPEA) as a significant contribution to the scholarship and practice of education administration. Formatted and edited in Connexions by Theodore Creighton and Brad Bizzell, Virginia Tech, Janet Tareilo, Stephen F. Austin State University, and Thomas Kersten, Roosevelt University.

This chapter is part of a larger Collection (Book) and is available at: Calculating Basic Statistical Procedures in SPSS: A Self-Help and Practical Guide to Preparing Theses, Dissertations, and Manuscripts

Slate and LeBouef have written a "companion book" which is available at: Preparing and Presenting Your Statistical Findings: Model Write Ups

John R. Slate is a Professor at Sam Houston State University where he teaches Basic and Advanced Statistics courses, as well as professional writing, to doctoral students in Educational Leadership and Counseling. His research interests lie in the use of educational databases, both state and national, to reform school practices. To date, he has chaired and/or served over 100 doctoral student dissertation committees. Recently, Dr. Slate created a website, Writing and Statistical Help to assist students and faculty with both statistical assistance and in editing/writing their dissertations/theses and manuscripts.
Ana Rojas-LeBouef is a Literacy Specialist at the Reading Center at Sam Houston State University where she teaches developmental reading courses. She recently completed her doctoral degree in Reading, where she conducted a 16-year analysis of Texas statewide data regarding the achievement gap. Her research interests lie in examining the inequities in achievement among ethnic groups. Dr. Rojas-LeBouef also assists students and faculty in their writing and statistical needs on the Writing and Statistical website, Writing and Statistical Help
Theodore B. Creighton, is a Professor at Virginia Tech and the Publications Director for NCPEA Publications, the Founding Editor of Education Leadership Review, and the Senior Editor of the NCPEA Connexions Project.
Brad E. Bizzell, is a recent graduate of the Virginia Tech Doctoral Program in Educational Leadership and Policy Studies, and is a School Improvement Coordinator for the Virginia Tech Training and Technical Assistance Center. In addition, Dr. Bizzell serves as an Assistant Editor of the NCPEA Connexions Project in charge of technical formatting and design.
Janet Tareilo, is a Professor at Stephen F. Austin State University and serves as the Assistant Director of NCPEA Publications. Dr. Tareilo also serves as an Assistant Editor of the NCPEA Connexions Project and as a editor and reviewer for several national and international journals in educational leadership.
Thomas Kersten is a Professor at Roosevelt University in Chicago. Dr. Kersten is widely published and an experienced editor and is the author of Taking the Mystery Out of Illinois School Finance, a Connexions Print on Demand publication. He is also serving as Editor in Residence for this book by Slate and LeBouef.

Calculating Descriptive Statistics

In this set of steps, readers are provided with directions on calculating basic measures of central tendency (i.e., mean, median, and mode), measures of dispersion (i.e., standard deviation, variance, and range), and measures of normality (i.e., skewness and kurtosis). For detailed information regarding the advantages and limitations of each of the measures cited, readers are referred to the Hyperstats Online Statistics Textbook at http://davidmlane.com/hyperstat/ or to the Electronic Statistics Textbook (2011) at http://www.statsoft.com/textbook/

First check the accuracy of your dataset.
√ Analyze
* Descriptive Statistics
* Frequencies

figure1.1-thumb.png

√ Move over the independent variable/s
√ Move over the dependent variable/s
√ OK

figure1.2.PNG

  • Uncheck the display "frequency tables" so that you are not provided with the frequencies of your data every time descriptive statistics are obtained.

Now check your output to see that the values for each of the variables is within the possible limits (e.g., 1 and 2 for gender). If your dataset is inaccurate, correct any inaccuracies before calculating any statistics.

To calculate descriptive statistics:
√ Analyze
* Descriptive Statistics
* Frequencies
* Move over the dependent variable/s
* Do NOT move over the independent variable/s or any string variables
* Statistics

figure1.3.PNG

* Three basic measures of central tendency, upper right part of screen: mean, median, and mode.
* Three basic measures of variability, bottom left part of screen: variance, Standard Deviation, and range.
* Skewness [Note. Skewness refers to the extent to which the data are normally distributed around the mean. Skewed data involve having either mostly high scores with a few low ones or having mostly low scores with a few high ones.] Readers are referred to the following sources for a more detailed definition of skewness: http://www.statistics.com/index.php?page=glossary&term_id=356 and http://www.statsoft.com/textbook/basic-statistics/#Descriptive%20statisticsb
* Kurtosis [Note. Kurtosis also refers to the extent to which the data are normally distributed around the mean. This time, the data are piled up higher than normal around the mean or piled up higher than normal at the ends of the distribution.] Readers are referred to the following sources for a more detailed definition of kurtosis: http://www.statistics.com/index.php?page=glossary&term_id=326 and http://www.statsoft.com/textbook/basic-statistics/#Descriptive%20statisticsb

figure1.4.PNG

* Charts (optional, use only if you want a visual depiction of your data)
* Histograms (optional, use only if you want a visual depiction of your data)with normal curve

figure1.5.PNG

* Uncheck the display frequency tables so that you are not provided with the frequencies of your data every time descriptive statistics are obtained.
* OK

figure1.6.PNG

To obtain descriptive statistics for subgroups, do the following:
* Split File (icon middle top of screen next to the scales)

figure1.7.PNG

* Compare Groups
* Click on group (typically dichotomous in nature) and move to empty cell.

figure1.8.PNG

* OK
√ Analyze
* Descriptive Statistics
* Frequencies
* Move over the dependent variable/s
* Do NOT move over the independent variable/s or any string variables

figure1.9.PNG

√ Statistics
* Three basic measures of central tendency, upper right part of screen: mean, median, and mode.
* Three basic measures of variability, bottom left part of screen: variance, Standard Deviation, and range.
* Skewness [Note. Skewness refers to the extent to which the data are normally distributed around the mean. Skewed data involve having either mostly high scores with a few low ones or having mostly low scores with a few high ones.] Readers are referred to the following sources for a more detailed definition of skewness: http://www.statistics.com/index.php?page=glossary&term_id=356 and http://www.statsoft.com/textbook/basic-statistics/#Descriptive%20statisticsb
* Kurtosis [Note. Kurtosis also refers to the extent to which the data are normally distributed around the mean. This time, the data are piled up higher than normal around the mean or piled up higher than normal at the ends of the distribution.] Readers are referred to the following sources for a more detailed definition of kurtosis: http://www.statistics.com/index.php?page=glossary&term_id=326 and http://www.statsoft.com/textbook/basic-statistics/#Descriptive%20statisticsb
* Continue

figure1.10.PNG

* Charts (optional, use only if you want a visual depiction of your data)
* Histograms (optional, use only if you want a visual depiction of your data)with normal curve

figure1.11.PNG

* OK
To calculate a z -score for any continuous variable:
√ Analyze
* Descriptive Statistics
* Descriptives
* Send variable on which you want z-scores to be calculated to empty cell
* Check box for Save standardized values as variables

figure1.12.PNG

* OK
* You will be sent to the output window, as shown in Table 1. [Note. In some versions of SPSS, you will not be sent to the output window, but will remain in the data window.] The information in the output window is not relevant for your purposes. To see the variable that was just created, go to the SPSS data. The far right column should now be the new z-score variable that was created.
Table 2.1. Descriptive Statistics
Descriptive Statistics
 NMinimumMaximumMeanStd. Deviation
Verbal IQ (Wechsler Verbal Intelligence 3)11824612977.9713.661
Valid N (listwise)1182    
* A new variable/s will have been generated for you in the data window
To get this information in a usable output form, do the following:
√ Analyze
* Descriptive Statistics
* Frequencies
* Move over the newly created z-score variable(s) (z-scores will generally appear at the bottom of your list with the words: “Zscore: Verbal IQ (Wechsler Verbal Intelligence 3)
* Make sure the frequencies box is checked
* OK
* Copy or cut the frequency table for this z-score variable and carry it into WORD. Delete any irrelevant information.
Table 2.2. Z Scores
  Zscore: Verbal IQ (Wechsler Verbal Intelligence 3)Zscore(wiviq) Verbal IQ (Wechsler Verbal Intelligence 3)
N
Valid11821182
Missing00
To calculate a T -score for any continuous variable:
√ Analyze
* Descriptive Statistics
* Descriptives
* Send variable on which you want T scores to be calculated to empty cell
* Check box for Save standardized values as variables

figure1.13.PNG

* OK
* You will be sent to the output window. Nothing in the output window is helpful. Go to the SPSS data screen by clicking on the data button bottom of screen. A new variable(s) will have been generated for you. This variable will be inserted into a formula so that you can have T scores.
* Variable view window
Table 2.3. Descriptive Statistics
Descriptive Statistics
 NMinimumMaximumMeanStd. Deviation
Verbal IQ (Wechsler Verbal Intelligence 3)11824612977.9713.661
Valid N (listwise)1182    
√ Create a new variable for your T score variable
* Data view window
* Transform
* Compute Variable

figure1.14.PNG

* Name your target variable the name you just generated for your T score variable
* In the numeric expression window, type:
* 50 + (10 x [name of the z-score variable generated by the computer earlier])

figure1.15.PNG

* OK

figure1.16.PNG

* Respond yes to change existing variable
* You may be sent to the output screen. Nothing there is helpful.
* Go to data button and view your new T score variable.
* To get this information in a usable output form, do the following:
√ Analyze
* Descriptive Statistics
* Frequencies
* Move over the newly created T score variable
* Make sure the frequencies box is checked.

figure1.17.PNG

* OK
* Copy or cut the frequency table for this T score variable and carry it into WORD. Delete any irrelevant information.

Writing Up Your Statistics

So, how do you "write up" your Research Questions and your Results? Schuler W. Huck (2000) in his seminal book entitled, Reading Statistics and Research, points to the importance of your audience understanding and making sense of your research in written form. Huck further states:

This book is designed to help people decipher what researchers are trying to communicate in the written or oral summaries of their investigations. Here, the goal is simply to distill meaning from the words, symbols, tables, and figures included in the research report. To be competent in this arena, one must not only be able to decipher what's presented but also to "fill in the holes"; this is the case because researchers typically assume that those receiving the research report are familiar with unmentioned details of the research process and statistical treatment of data.

A Note from the Editors

Researchers and Professors John Slate and Ana Rojas-LeBouef understand this critical issue, so often neglected or not addressed by other authors and researchers. They point to the importance of doctoral students "writing up their statistics" in a way that others can understand your reporting and as importantly, interpret the meaning of your significant findings and implications for the preparation and practice of educational leadership. Slate and LeBouef provide you with a model for "writing up your descriptive statistics."

Click here to view: Writing Up Your Descriptive Staistics

References

Cohen, J. (1988). Statistical power analysis for the behavioral sciences (2nd ed.). Hillsdale, NJ: Lawrence Erbaum
Hyperstats Online Statistics Textbook. (n.d.) Retrieved from http://davidmlane.com/hyperstat/
Kurtosis. (n.d.). Definition. Retrieved from http://www.statistics.com/index.php?page=glossary&term_id=326
Kurtosis. (n.d.). Definition of normality. Retrieved from http://www.statsoft.com/textbook/basic-statistics/#Descriptive%20statisticsb
Onwuegbuzie, A. J., & Daniel, L. G. (2002). Uses and misuses of the correlation coefficient. Research in the Schools, 9(1), 73-90.
Skewness. (n.d.) Retrieved from http://www.statistics.com/index.php?page=glossary&term_id=356
Skewness. (n.d.). Definition of normality. Retrieved from