LEADER 05483nam 2200661 450 001 9910465508303321 005 20200520144314.0 010 $a1-118-62718-0 010 $a1-118-62728-8 035 $a(CKB)3710000000224919 035 $a(EBL)1771576 035 $a(OCoLC)889675105 035 $a(SSID)ssj0001334984 035 $a(PQKBManifestationID)12537686 035 $a(PQKBTitleCode)TC0001334984 035 $a(PQKBWorkID)11272976 035 $a(PQKB)10303719 035 $a(MiAaPQ)EBC1771576 035 $a(Au-PeEL)EBL1771576 035 $a(CaPaEBR)ebr10915826 035 $a(CaONFJC)MIL639065 035 $a(OCoLC)891383637 035 $a(EXLCZ)993710000000224919 100 $a20140902h20112011 uy 0 101 0 $aeng 135 $aurcnu|||||||| 181 $ctxt 182 $cc 183 $acr 200 10$aUnderstanding educational statistics using Microsoft Excel® and SPSS® /$fMartin Lee Abbott 210 1$aHoboken, New Jersey :$cWiley,$d2011. 210 4$d©2011 215 $a1 online resource (552 p.) 300 $aDescription based upon print version of record. 311 $a0-470-88945-4 311 $a1-322-07814-9 320 $aIncludes bibliographical references and index. 327 $aCover ; Title Page ; Copyright ; Contents ; Preface ; Acknowledgments ; 1 Introduction ; Approach of the Book ; Project Labs ; Real-world Data ; Research Design ; ''Practical Significance''-implications of Findings ; Coverage of Statistical Procedures ; 2 Getting Acquainted with Microsoft Excel® ; Data Management ; Rows and Columns ; Data Sheets ; The Excel® Menus ; Home ; Insert Tab ; Page Layout ; Formulas ; Data ; Review and View Menus ; 3 Using Statistics in Excel® ; Using Statistical Functions ; Entering Formulas Directly ; Data Analysis Procedures 327 $aMissing Values and ''0'' Values in Excel® Analyses Using Excel® with Real Data ; School-level Achievement Database ; Taglit Data ; The STAR Classroom Observation ProtocolTM Data4; 4 SPSS® Basics ; Using SPSS® ; General Features ; Management Functions ; Reading and Importing Data ; Sort ; Additional Management Functions ; Split File ; Transform/compute (creating Indices) ; Merge ; Analysis Functions ; 5 Descriptive Statistics- Central Tendency ; Research Applications-spuriousness ; Descriptive and Inferential Statistics ; The Nature of Data-scales of Measurement ; Nominal Data 327 $aOrdinal Data Interval Data ; Ratio Data ; Choosing the Correct Statistical Procedure for the Nature of Research Data ; Descriptive Statistics-central Tendency ; Mean ; Median ; Mode ; Using Excel® and SPSS® to Understand Central Tendency; Excel® ; SPSS® ; Distributions ; Describing the Normal Distribution ; Central Tendency ; Skewness ; Kurtosis ; Descriptive Statistics-using Graphical Methods ; Frequency Distributions ; Histograms ; Terms and Concepts ; Real-world Lab I: Central Tendency ; Real-world Lab I: Solutions ; Results ; Results ; 6 Descriptive Statistics- Variablity ; Range 327 $aPercentile Scores Based on Percentiles ; Using Excel® and SPSS® to Identify Percentiles ; Note ; Standard Deviation and Variance ; Calculating the Variance and Standard Deviation ; The Deviation Method ; The Computation Method ; The Sum of Squares ; Sample Sd and Population Sd ; Obtaining Sd from Excel® and SPSS® ; Terms and Concepts ; Real-world Lab II: Variability ; Real-world Lab II: Solutions ; Results ; 7 The Normal Distribution ; The Nature of the Normal Curve ; The Standard Normal Score: Z Score ; The Z-score Table of Values ; Navigating the Z-score Distribution 327 $aCalculating Percentiles Creating Rules for Locating Z Scores ; Calculating Z Scores ; Working with Raw Score Distributions ; Using Excel® to Create Z Scores and Cumulative Proportions ; STANDARDIZE Function ; NORMSDIST Function ; NORMSDIST Function ; Using SPSS® to Create Z Scores ; Terms and Concepts ; Real-world Lab Iii: the Normal Curve and Z Scores ; Real-world Lab Iii: Solutions ; 8 The Z Distribution and Probability ; Transforming a Z Score to a Raw Score ; Transforming Cumulative Proportions to Z Scores ; Deriving Sample Scores from Cumulative Percentages 327 $aAdditional Transformations Using the Standard Normal Distribution 330 $aUtilizing the latest software, this book presents the essential statistical procedures for drawing valuable results from data in the social sciences. Mobilizing interesting real-world examples from the field of education, Understanding Educational Statistics Using Microsoft Excel and SPSS supplies a seamless presentation that identifies valuable connections between statistical applications and research design. Class-tested to ensure an accessible presentation, the book combines clear, step-by-step explanations and the use of software packages that are accessible to both the novice and profession 606 $aEducational statistics$xData processing 606 $aEducation$xResearch$xStatistical methods 608 $aElectronic books. 615 0$aEducational statistics$xData processing. 615 0$aEducation$xResearch$xStatistical methods. 676 $a300.727 700 $aAbbott$b Martin L.$0971721 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910465508303321 996 $aUnderstanding educational statistics using Microsoft Excel® and SPSS®$92209277 997 $aUNINA