Data Analysis with Microsoft Excel


Data Analysis with Microsoft Excel hadbook


I present to you a book about ( Data Analysis with Microsoft Excel )






Contents



























Chapter1 getting started with EXCEL
Chapter 2 Working with data 
Chapter 3 Working with Charts
Chapter 4 Describing Your Data
Chapter 5 Probability Distributions 
Chapter 6Statistical 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 



This book includes additional fi les to help you learn statistics. There are three types of fi les you’ll work with: StatPlus fi les, Explore workbooks, and Data (or Student) files.
Excel has many statistical functions and commands. However, there are some things that Excel does not do (or does not do easily) that you will need to do in order to perform a statistical analysis. To solve this problem, this book includes StatPlus, a software package that provides additional statistical commands accessible from within Excel.
The Explore workbooks are self-contained tutorials on various statistical concepts. Each workbook has one or more interactive tools that allow you to see these concepts in action.
The Data or Student fi les contain sample data from real-life problems. In each chapter, you’ll analyze the data in one or more Data fi le, employing various statistical techniques along the way. You’ll use other Data fi les in the exercises provided at the end of each chapter.




Excel is a software program designed to help you evaluate and present information in a spreadsheet format. Spreadsheets are most often used by business for cash-fl ow analysis, fi nancial reports, and inventory management. Before the era of computers, a spreadsheet was simply a piece of paper with a grid of rows and columns to facilitate entering and displaying information as shown in Figure 1-2.






Computer spreadsheet programs use the old hand-drawn spreadsheets as their visual model but add a few new elements, as you can see from the Excel worksheet shown in Figure 1-3.



launching Excel.



When Excel 2007 is installed on your computer, the installation program automatically inserts a shortcut icon to Excel 2007 in the Programs menu located under the Windows Start button. You can click this icon to launch Excel.


To start Excel:
  •  Click the Start button on the Windows Taskbar and then click All Programs.
  •  Click Microsoft Offi ce and then click Microsoft Offi ce Excel 2007 as shown in Figure 1-4 .
  • Excel starts up, displaying the window shown in Figure 1-5.
Note: Depending on how Windows has been configured on your computer, your Start menu may look different from the one shown in Figure 1-4. Talk to your instructor if you have problems launching Excel 2007.

Figure 1-4 Starting Excel 2007









Viewing the Excel


The Excel window shown in Figure 1-5 is the environment in which you’ll analyze the data sets used in this textbook. Your window might look different depending on how Excel has been set up on your system. Before proceeding, take time to review the various elements of the Excel window. A quick description of these elements is provided in Table 1-1.