Read e-book online Understanding Educational Statistics Using Microsoft Excel PDF

Mobilizing fascinating real-world examples from the sector of schooling, Understanding academic facts utilizing Microsoft Excel and SPSS offers a unbroken presentation that identifies important connections among statistical purposes and examine layout. Class-tested to make sure an available presentation, the ebook combines transparent, step by step reasons and using software program applications which are available to either the beginner alike to offer the basic statistical practices for organizing, realizing, and drawing conclusions from academic examine data.

The publication begines with an advent to descriptive and inferential information after which proceeds to acquaint readers with a number of the features for operating with quantitative facts within the Microsoft Excel setting, similar to spreadsheet navigation; sorting and filtering; and developing pivot tables. next chapters deal with the approaches which are commonly-employed while operating with information throughout quite a few fields of social technology study, including:

• Single-sample tests
• Repeated degree tests
• Independent t-tests
• One method ANOVA and factorial ANOVA
• Correlation
• Bivariate regression
• Chi square
• Multiple regression

Individual chapters are dedicated to particular strategies, each one finishing with a lab workout that highlights the significance of that strategy by way of posing a study query, reading the query via its program in Excel and SPSS, and concluding with a short study record that outlines key findings drawn from the implications. Real-world examples and information from smooth academic learn are used in the course of the booklet, and a similar site gains extra information units, examples, and labs, permitting readers to augment their comprehension of the material.

Bridging conventional statistical subject matters with the newest software program and purposes within the box of schooling, Understanding academic statistics utilizing Microsoft Excel and SPSS is a superb booklet for classes on academic learn tools and introductory information within the social sciences on the upper-undergraduate and graduate levels. It additionally serves as a priceless source for researchers and practitioners within the fields of schooling, psychology, and the social sciences who require a statistical history to paintings with information of their daily work.