Excel 2010 for Educational and Psychological Statistics

.Excel 2010 for Educational and Psychological Statistics
Mô tả cơ bản về tài liệu:
Excel 2010 cho các thống kê giáo dục và tâm lý: Một hướng dẫn để giải quyếtVấn đề thực tế sẽ giúp bất cứ ai muốn tìm hiểu những điều cơ bản của việc áp dụng của Excelmạnh mẽ các công cụ thống kê tình hình công việc của họ hoặc các lớp học của họ. Nếu sự hiểu biếtsố liệu thống kê là không phù hợp với mạnh của bạn, bạn không phải là toán học nghiêng, hoặc bạn làcảnh giác với máy tính, sau đó đây là cuốn sách cho bạn....
Nội dung trích xuất từ tài liệu:
.Excel 2010 for Educational and Psychological Statistics Excel 2010 for Educationaland Psychological StatisticsThomas QuirkExcel 2010 for Educationaland Psychological StatisticsA Guide to Solving Practical ProblemsThomas QuirkSchool of Business and TechnologyWebster UniversitySt. Louis, MO 63119, USAquirkto@webster.eduISBN 978-1-4614-2070-5 e-ISBN 978-1-4614-2071-2DOI 10.1007/978-1-4614-2071-2Springer New York Dordrecht Heidelberg LondonLibrary of Congress Control Number: 2011941800# Springer Science+Business Media, LLC 2012All rights reserved. This work may not be translated or copied in whole or in part without the writtenpermission of the publisher (Springer Science+Business Media, LLC, 233 Spring Street, New York,NY 10013, USA), except for brief excerpts in connection with reviews or scholarly analysis. Use inconnection with any form of information storage and retrieval, electronic adaptation, computer software,or by similar or dissimilar methodology now known or hereafter developed is forbidden.The use in this publication of trade names, trademarks, service marks, and similar terms, even if theyare not identified as such, is not to be taken as an expression of opinion as to whether or not they aresubject to proprietary rights.Printed on acid-free paperSpringer is part of Springer Science+Business Media (www.springer.com)This book is dedicated to the more than3,000 students I have taught at WebsterUniversity’s campuses in St. Louis, London,and Vienna; the students at PrincipiaCollege in Elsah, Illinois; and the studentsat the Cooperative State Universityof Baden-Wuerttemburg in Heidenheim,Germany. These students taught me a greatdeal about the art of teaching. I salute themall, and I thank them for helping me tobecome a better teacher.PrefaceExcel 2010 for Educational and Psychological Statistics: A Guide to SolvingPractical Problems helps anyone who wants to learn the basics of applying Excel’spowerful statistical tools to their work situation or to their classes. If understandingstatistics is not your strongest suit, you are not mathematically inclined, or you arewary of computers, then this is the book for you. You will learn how to perform key statistical tests in Excel without beingoverwhelmed by statistical theory. This book clearly and logically shows how torun statistical tests to solve practical problems in education and psychology. Excel is a widely available computer program for students, instructors, andmanagers in education and in business. It is also an effective teaching and learningtool for quantitative analyses in statistics courses. Its powerful computationalability and graphical functions make learning statistics much easier than in yearspast. However, this is the first book to showcase Excel’s usefulness in teachingeducational and psychological statistics. And it focuses exclusively on this topicin order to render the subject matter applicable and practical – and, easy tocomprehend and apply. Unique features of this book: Includes 163 color screen shots so you can be sure you are performing Excell steps correctly. You will be told each step of the way, not only how to use Excel, but also whyl you are doing each step. Includes specific objectives embedded in the text for each concept, so you canl know the purpose of the Excel steps. You will learn both how to write statistical formulas using Excel and how to usel Excel’s drop-down menus that will create the formulas for you. Statistical theory and formulas are explained in clear language without boggingl you down in mathematical fine points. Practical examples of problems are taken from both education and psychology.l viiviii Preface Each chapter presents key steps to solve practical problems using Excel.l In addition, three practice problems at the end of each chapter enable you to test your new knowledge. Answers to these problems appear in Appendix A. A “Practice Test” is given in Appendix B to test your knowledge at the end of thel book. Answers to this test appear in Appendix C. This book does not come with a CD of Excel files which you can upload to yourl computer. Instead, you will be shown how to create each Excel file yourself. In a work or classroom situation, your colleagues and professors will not give you an Excel file. You will be expected to create your own. This book will give you ample practice in developing this important skill. This book is a tool that can be used either by itself or along with any goodl statistics book. This book is appropriate for use in any course – graduate of ...