In the upper-right corner of the application window are three buttons that allow the user to minimize, maximize, or close the window. The figure below is a screenshot of a blank sheet in the Excel 2007 application. Worksheet Basics When Excel is launched, a new file opens with a series of blank worksheets, also known as “sheets.” The file itself is called a “workbook,” which refers to the entire collection of spreadsheets, graphs, and user-developed programming code in the file. However, it will be helpful to become familiar with Excel before using it for statistical analysis. Prior Knowledge It is not necessary to have any prior knowledge of Excel to use this manual. Versions of Excel The examples in this book were written using Microsoft Excel 2007. The WHFStat Add‐In module operates with Excel 2003 or Excel 2007 under either the Windows Vista or Windows XP operating systems. It is also compatible with Excel 2004 for Macintosh. Versions of Excel prior to version 2003 cannot be used with this software. This software is described in section 0.8, and is available on StatsPortal, your Online Study Center, or packaged with this manual. The WHFStat Add-In software works within Excel to group all of the statistics functions into one menu. Excel can also perform statistical analysis using built-in functions. Using Excel Microsoft Excel, commonly referred to as just Excel, is a spreadsheet program that organizes data in columns and rows, much like an accounting worksheet or table of data. This manual describes how Microsoft Excel can be used effectively in your statistics course. Introduction Microsoft Excel is a widely used spreadsheet application that millions of people use in their personal and professional lives to store, analyze, and present information. Graphs including normal quantile plots, boxplots, and control charts Betsy Greenberg University of Texas at Austin August 2008.The module is programmed to include the following procedures and graphical analyses under the umbrella of a single menu. The WHFStat Add‐In module is available from W.H. Freeman. In addition to describing the standard features of Excel, this manual also illustrates the capabilities of the WHFStat Add‐In module. This manual helps students understand the capabilities of Excel for statistical analysis. People often use Excel as their everyday statistics software because they have already purchased it. Excel is a useful teaching and learning tool, however it is not meant to replace more sophisticated statistical tools such as SPSS or SAS. It also comes with statistical routines in the Data Analysis Toolpak, an add‐in found separately on the Microsoft Office CD. It contains some statistical functions in its basic installation. Excel is widely available as part of Microsoft Office.
This manual is intended to help student perform the analysis described in those textbooks. PREFACE This Excel Manual is a supplement to Statistics textbooks by David S.
Freeman and Company No part of this book may be reproduced by any mechanical, photographic, or electronic process, or in the form of a phonographic recording, nor may it be stored in a retrieval system, transmitted, or otherwise copied for public or private use, without written permission from the publisher. Linda Myers Harrisburg Area Community CollegeĬopyright © 2010 by W.H. The Basic Practice of Statistics Fifth Editionīetsy Greenberg University of Texas – Austin with solutions by
0 kommentar(er)
