Understanding educational statistics using Microsoft Excel® and SPSS® / / Martin Lee Abbott

• Record Nr.: UNINA9910465508303321
• Autore: Abbott Martin L.
• Pubbl/distr/stampa: Hoboken, New Jersey : , : Wiley, , 2011; ©2011
• ISBN: 1-118-62718-0; 1-118-62728-8
• Descrizione fisica: 1 online resource (552 p.)
• Disciplina: 300.727
• Soggetti: Educational statistics - Data processing; Education - Research - Statistical methods; Electronic books.
• Lingua di pubblicazione: Inglese
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Note generali: Description based upon print version of record.
• Nota di bibliografia: Includes bibliographical references and index.
• Nota di contenuto: Cover ; 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; Missing 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; Ordinal 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; Percentile 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; Calculating 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; Additional Transformations Using the Standard Normal Distribution
• Sommario/riassunto: Utilizing 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