Understanding Educational Statistics Using Microsoft Excel and SPSS

Detalles Bibliográficos
Autor principal: Abbott, Martin Lee
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Newark : John Wiley & Sons, Incorporated, 2011.
Colección:New York Academy of Sciences Ser.
Temas:
Electronic books.
Acceso en línea:Texto completo
Tabla de Contenidos:
  • 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

Ejemplares similares