

Video 2.B – Calculating the Mean - Windows - Mac Video 2.A – Calculating the Range - Windows - Mac Video 1.C - Revising Your Spreadsheet - Windows - Mac Video 1.B - Entering and Working with Data - Windows - Mac Video 1.A - Spreadsheet Basics - Windows - Mac

NOTE: the videos are formatted in both Windows and Mac versions. Here as downloadable attachments, are each of the chapter's accompanying Excel Worksheet Files and Interactive Videos. We apologize for this inconvenience and hope that you find the revision acceptable and helpful.ĬLICK HERE to download 8 Page revised Chapter 5 You can download this 8 page insert by clicking on the link below this narrative. Consequently, we have re-written the first 8 pages of Chapter 5 (pages 107 – 114) instructing the user how to calculate these statistical tests accurately and properly. If your sample mean is less than the comparative population mean the Z.TEST function does not calculate the correct p value for either a z-Test or a Single Sample t-Test computation. It has come to our attention that the Z.TEST function in Excel only provides the user with the correct p value (level of statistical significance) when the sample mean is GREATER THAN the population mean.


UP FRONT and PERSONAL: CLICK HERE to Meet the AuthorsĪTTENTION: To those individuals who purchased Quantitative Data Analysis Using Microsoft ® Excel: A School Administrator’s Guide prior to July 23, 2015. ORDER PRINT COPY: Windows Edition CLICK HERE (Preview Available) Note: This book is offered in either a Windows Edition or a Mac Edition - clcik on the desired links below. This is not a traditional graduate student textbook - it is not so much a book to read, but one that provides students the opportunities to "practice" leadership with activies, simulations, and other more realistic ways to study effective school leadership. The purpose here is to provide supplemental materials for students and professors who are using Quantitative Data Analysis Using Microsoft® Excel: A School Administrator's Guide for their graduatate classes. This site is an online support system for a new book published by NCPEA Press, and authored by Gerard Babo, Seton Hall University and Leonard Elovitz, Kean University.
