Data Analysis with Microsoft Excel: Updated for Office 2007 pdf.
Data Analysis with Microsoft Excel: Updated for Office 2007.
Chapter 1: GETTING STARTED WITH EXCEL
Chapter 2: WORKING WITH DATA
Chapter 3: WORKING WITH CHARTS
Chapter 4: DESCRIBING YOUR DATA
Chapter 5: PROBABILITY DISTRIBUTIONS
Chapter 6: STATISTICAL INFERENCE
Chapter 7: TABLES
Chapter 8: REGRESSION AND CORRELATION
Chapter 9: MULTIPLE REGRESSION
Chapter 10: ANALYSIS OF VARIANCE
Chapter 11: TIME SERIES
Chapter 12: QUALITY CONTROL
Data Analysis with Microsoft® Excel: Updated for Office 2007® harnesses the power of Excel and transforms it into a tool for learning basic statistical analysis. Students learn statistics in the context of analyzing data. We feel that it is important for students to work with real data, analyzing real-world problems, so that they understand the subtleties and complexities of analysis that make statistics such an integral part of understanding our world. The data set topics range from business examples to physiological studies on NASA astronauts. Because students work with real data, they can appreciate that in statistics no answers are completely final and that intuition and creativity are as much a part of data analysis as is plugging numbers into a software package. This text can serve as the core text for an introductory statistics course or as a supplemental text. It also allows nontraditional students outside of the classroom setting to teach themselves how to use Excel to analyze sets of real data so they can make informed business forecasts and decisions.
Users of this book need not have any experience with Excel, although previous experience would be helpful. The first three chapters of the book cover basic concepts of mouse and Windows operation, data entry, formulas and functions, charts, and editing and saving workbooks. Chapters 4 through 12 emphasize teaching statistics with Excel as the instrument.