StatisticalAnalysisWithExcelForDummies2ndEditionBookExcelFormulasTutorial.pdf 英文

Statistical Analysis With Excel For Dummies 2nd Edition Book, Excel Formulas TutorialStatistical Analysiswith excelFORDUMMIES2ND EDITION01 454060-ffirs indd I4/21/097:13:09PM01 454060-ffirs indd li4/21/097:13:10PMStatistical Analysiswith excelFORDUⅠMMIE2ND EDITIONJoseph schmuller, PhD(WILEYWiley publishing Inc01454060-firs.inddⅢ4/21/097:13:10PMStatistical Analvsis with excel For dummies 2nd editionPublished bWiley Publishing, Inc.111 River streetHoboken. NJ07030-5774www.Wwlley.comCopyright c 2009 by Wiley Publishing, Inc, Indianapolis, IndianaPublished by Wiley Publishing, InC, Indianapolis, IndianlaPublished simultaneously in CanadaNo part of this publication may be reproduced, stored in a retrieval system or transmitted in any form orby any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permit-ted under Sections 107or 108 of the 1976 United States Copyright Act, without either the prior writtenpermission of the Publisher, or authorization through payment of the appropriate per-copy fee to theCopyright Clearance center, 222 Rosewood Drive, Danvers, MA 01923, (978)750-8400, fax(978)646-8600Requests to the publisher for permission should be addressed to the permissions department, John wiley&sons,inc.,1llRiverStreet,Hoboken,Nj07030,(201)748-601l,fax(201)748-6008,oronlineathttp://www.wiley.com/go/pe-missionsTrademarks: Wiley, the Wiley Publishing logo, For Dummies, the dummies Man logo, A Reference for theRestofUs!,TheDummiesWay,DummiesDaily,TheFunandEasyWay,Dummies.com,MakingEverythingEasier, and related trade dress are trademarks or registered trademarks of John Wiley Sons, InC and orits affiliates in the United States and other countries, and may not be used without written permissionExcel is a registered trademark of microsoft Corporation in the United states and/or other countries allother trademarks are the property of their respective owners. Wiley Publishing, Inc, is not associatedwith any product or vendor mentioned in this bookLIMIT OF LIABILITY/DISCLAIMER OF WARRANTY: THE PUBLISHER AND THE AUTHOR MAKE NOREPRESENTATIONS OR WARRANTIES WITH RESPECT TO THE ACCURACY OR COMPLETENESS OFTHE CONTENTS OF THIS WORK AND SPECIFICALLY DISCLAIM ALL WARRANTIES. INCLUDING WITHOUT LIMITATION WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE. NO WARRANTY MAY BECREATED OR EXTENDED BY SALES OR PROMOTIONAL MATERIALS. THE ADVICE AND STRATEGIESCONTAINED HEREIN MAY NOT BE SUITABLE FOR EVERY SITUATION. THIS WORK IS SOLD WITH THEUNDERSTANDING THAT THE PUBLISHER IS NOT ENGAGED IN RENDERING LEGAL ACCOUNTING OROTHER PROFESSIONAL SERVICES. IF PROFESSIONAL ASSISTANCE IS REQUIRED, THE SERVICES OFA COMPETENT PROFESSIONAL PERSON SHOULD BE SOUGHT. NEITHER THE PUBLISHER NOR THEAUTHOR SHALL BE LIABLE FOR DAMAGES ARISING HEREFROM. THE FACT THAT AN ORGANIZA-TION OR WEBSITE IS REFERRED TO IN THIS WORK AS A CITATION AND/OR A POTENTIAL SOURCEOF FURTHER INFORMATION DOES NOT MEAN THAT THE AUTHOR OR THE PUBLISHER ENDORSESTHE INFORMATION THE ORGANIZATION OR WEBSITE MAY PROVIDE OR RECOMMENDATIONS ITMAY MAKE FURTHER. READERS SHOULD BE AWARE THAT INTERNET WEBSITES LISTED IN THISWORK MAY HAVE CHANGED OR DISAPPEARED BETWEEN WHEN THIS WORK WAS WRITTEN ANDWHEN IT IS READFor general information on our other products and services, please contact our Customer CareDepartment within the U.s. at 877-762-2974, outside the U.s. at 317-572-3993, or fax 317-572-4002For technical support, please visitWiley also publishes its books in a variety of electronic formats. Some content that appears in print maynot be available in electronic booksLibrary of congress control Number: 2009926356lSBN:978-0470-45406-0Manufactured in the united state1098765432101 454060-ffirs indd iv4/21/097:13:11PMAbout the authorJoseph Schmuller is a veteran of over 25 years in Information TechnologyHe is the author of several books on computing, including the three editionsof Teach Yourself UML in 24 Hours (sams), and the first edition of statisticalAnalysis with Excel For Dummies. He has written numerous articles onadvanced technology. From 1991 through 1997, he was Editor-in-Chief ofPC Al magazineHe is a former member of the american statistical association and he hastaught statistics at the undergraduate and graduate levels. He holds a bsfrom Brooklyn College, an M A from the University of Missouri-Kansas Cityand a Ph. D from the University of Wisconsin, all in psychology He and hisfamily live in Jacksonville, Florida, where he is an Adjunct Professor at theUniversity of North Florida.01 454060-ffirs indd v4/21/097:13:11PM01 454060-ffirs indd vi4/21/097:13:11PMDedicationIn loving memory of Jesse Edward Sprague, my best friend in the wholeworld - a man who never met a stranger“ Friends have all things in common”- PlatoAuthor s AcknowledgmentsOne thing I have to tell you about writing a For Dummies book-it's anincredible amount of fun. You get to air out your ideas in a friendly, conversational way, and you get a chance to throw in some humor, too To write asecond edition is almost more fun than one writer should be allowed to haveI worked again with a terrific team. Acquisitions Editor Stephanie McComband Project Editor Beth Taylor of Wiley Publishing have been encouraging,cooperative, and patient Technical editor Namir Shammas helped make thisbook as technically bulletproof as possible. Any errors that remain are underthe sole proprietorship of the author. My deepest thanks to stephanie andBeth. My thanks to Waterside Productions for representing me in this effortAgain I thank mentors in college and graduate school who helped shape mystatistical knowledge: Mitch Grossberg Brooklyn College); Mort Goldman,Al Hillix, Larry Simkins, and Jerry Sheridan ( University of Missouri-KansasCity); and Cliff Gillman and John Theios(University of Wisconsin-Madison)A long time ago at the University of missouri-Kansas City, Mort goldmanexempted me from a graduate statistics final on one condition-that I learnthe last course topic, Analysis of Covariance, on my own. I hope he's happywith Appendix BI thank my mother and my brother David for their love and support and foralways being there for me, and Kathryn for so much more than I can sayFinally, a special note of thanks to my friend Brad, who suggested this wholething in the first place01 454060-ffirs indd vii4/21/097:13:11PMPublisher's AcknowledgmentsWe're proud of this book; please send us your comments through our online registration form locatedathttp://dummies.custhelp.comForothercommentspleasecontactourCustomerCareDepartment within the U.s. at 877-762-2974, outside the U.S. at 317-572-3993, or fax 317-572-4002Some of the people who helped bring this book to market include the followingAcquisitions, Editorial, andComposition ServicesMedia DevelopmentProject Coordinator: Kristie ReesProject Editor: Beth TaylorLayout and graphics: Carrie A. Cesavice(Previous Edition. Sarah Heller)Shawn Frazier. Melissa K. jesterSenior Acquisitions Editor: Stephanie McComb Proofreaders: Melissa CossellCopy Editor: Beth taylorBonnie mikkelsonTechnical editor: namir shammasIndexer: Steve rathEditorial Manager: Cricket KrengelEditorial assistant laura siniseCartoons:RichTennant(www.the5thwave.comPublishing and Editorial for Technology dummiesRichard Wadley, vice President and executive group publishBarry pruett, Vice President and Executive PublisherAndy Cummings, Vice President and PublisherMary Bednarek, Executive Acquisitions DirectorRobyn Siesky, Editorial DiSandy smith, Senior Marketing DirectorAmy Knies, Business managerPublishing for Consumer dummiesDiane Graves Stccle, vice president and publisherosition servicesDebbie stailey, Director of Composition Services01 454060-ffirs indd viii4/21/097:13:11PM