Quantitative Data Analysis Using Microsoft Excel: A School Administrator's Guide
Paperback, 268 Pages
Prints in 3-5 business days
Using Microsoft Excel for those who work in our nation’s schools - superintendents, principals, curriculum coordinators, teachers, etc., are inundated with a multitude of data from a number of different sources each and every day of the school year. Having taught computer applications and educational research to aspiring school leaders for a number of years, we have found that the old adage “learning by doing” is the best way to learn this material. Many action research projects require the collection, tabulation, and analysis of data. Assisting the school administrators with these tasks is primarily what this book is about. Researchers utilize powerful tools such as SPSS to assist them in these tasks. However, we have found that such programs are not readily available to the school administrator and, even if they are, the skills to effectively utilize them have not been mastered. Therefore, we have based this book on the utilization of the much more familiar... More > application, Microsoft Excel.< Less
Ratings & ReviewsLog in to review this item
1 Person Reviewed This Product
Nov 12, 2015Reviewed by Theodore Creighton, Professor Retired, Virginia Tech. If your knowledge of Excel is very limited, you might want to start with Chapter 1, where authors provide some Excel basics to get you going. Additionally, they include a section on how to code qualitative data for quantitative analysis. If you are already an Excel user and have a working knowledge of quantitative analysis, browse or skip this chapter and move on to what you want to learn about. To assist you they have enclosed what we are calling an Index of Statistical Terms and Excel Functions in the Appendix. If you want to learn how to do a t-test for example, one can simply check the Index, which references the specific page number. Chapter 2 discusses some elementary concepts in descriptive data analysis, including frequency distribution, relative frequency, cumulative frequency, percentile rank, central tendency (mean, median, and mode) and graphing or charting data. In Chapter 3, authors extend the concepts of... More > descriptive data analysis and the Excel operations to determine standard deviation or how observations (scores) vary across a population. They also include a section on sorting and analyzing a large data set from a typical public school. This is followed by a little bit of probability, the normal curve, and the calculation of standardized scores in Chapter 4. The authors address the comparison of means for two groups that are either independent of each other or from the same group of subjects by using Excel to perform t-tests in Chapter 5. This is logically followed by the comparisons of more than 2 groups by using Analysis of Variance, better known as ANOVA, in Chapter 6. Chapter 7 is devoted to exploring relationships. To this end, the authors utilize Excel to develop scatter plots and calculate the Pearson r and Spearman Rho correlation coefficients. This is followed naturally by linear relationships and predictions using Excel to run simple bivariate regression and multiple regression in Chapter 8. Finally, the authors display cross tabulation tables and go into a brief exploration of nonparametric statistics by looking at the calculation of simple Chi-square (goodness of fit) and r X k Chi-square in Chapter 9. The last chapter of the book, Chapter 10, introduces the reader to how to use Excel as a large database, which might be extremely beneficial for many school administrators.< Less
There are no reviews for previous versions of this product
- NCPEA Publications (Standard Copyright License)
- NCPEA Publications
- July 27, 2015
- Perfect-bound Paperback
- Interior Ink
- Black & white
- 1.78 lbs.
- Dimensions (inches)
- 8.5 wide x 11 tall
- Product ID
Your notification has been sent
Lulu Staff has been notified of a possible violation of the terms of our Membership Agreement. Our agents will determine if the content reported is inappropriate or not based on the guidelines provided and will then take action where needed.
Thank you for notifying us. We will email you with the results and/or actions taken as a result of the investigation if you chose to receive confirmation.
We were unable to complete your request.
We were unable to complete your request.
The page you are attempting to access contains content that is not intended for underage readers.
Please verify your birth date to continue.