Shop

Ratings & Reviews

Log in to review this item
Lulu Sales Rank: 2438
1 Person Reviewed This Product
  • By Theodore Creighton
    Nov 12, 2015
    Reviewed 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
Refreshing...
There are no reviews for previous versions of this product
Refreshing...

Product Details

Publisher
NCPEA Publications
Published
July 27, 2015
Language
English
Pages
268
Binding
Perfect-bound Paperback
Interior Ink
Black & white
Weight
1.78 lbs.
Dimensions (inches)
8.5 wide x 11 tall
Report This Content to Lulu >

Moderation of Questionable Content

Thank you for your interest in helping us moderate questionable content on Lulu. If you need assistance with an order or the publishing process, please contact our support team directly.

How does this content violate the Lulu Membership Agreement?