Introduction to the Practice of Statistics Excel Manual with Macros
Macmillan, Mar 4, 2005 - Mathematics - 224 pages
An easy-to-use software package with excellent graphical capabilities, Excel is an ideal way to teach and learn statistics at the introductory level. By organizing data into spreadsheets, Excel allows for easy analysis and graphic exploration. Its versatility, convenience, and reliability make it an attractive alternative to specialized statistical software. This manual was written specifically for using Excel with David Moore and George McCabe's Introduction to the Practice of Statistics, Fifth Edition (IPS) - a text that advocates using statistical software to free students from computations, allowing them to focus on the more practical matters of data gathering and analysis. No prior knowledge of the software is necessary. The manual provides a detailed introduction to Excel in the context of IPS and follows the text chapter by chapter to show how to use Excel to work through specific examples and exercises. In addition, the author developed add-in macros to assist in creating boxplots and normal quantile plots, a capability that does not exist in standard Excel. The macros are available on the textbook companion Web sit and can be downloaded and used on your own computer. This manual is compatible with Excel 2000 (Windows) and Excel 2001 (Macintosh), and the code successfully operates under all subsequent versions of the software, It is also easily adaptable for students using eXcel 97 (Windows) or Excel 98 (Macintosh). - Back cover.
What people are saying - Write a review
We haven't found any reviews in the usual places.
Introduction to Inference
Analysis Tools ANOVA axis label binomial distribution bins boxplot button calculated Cancel Chapter Click Finish Click inside Click OK column confidence interval Copy and paste Copy the formula correlation Count created Data Analysis data points Data Range data set defined Delete Descriptive Statistics dialog box displayed empty cell empty worksheet equation estimate explanatory variable five-number summary frequent binge drinker graph gridlines histogram Input the following input the function IPS Example linear lnput macro margin of error Maximum median menu method normal distribution Normal Quantile Plot null hypothesis Open the file outliers Output options Output Range P-value Percent population mean press Enter probability proportion Quantile random number random sample random variable regression line Remarks residual plot resulting Right-click sample mean sample statistic scatterplot scores select Edit Select Tools shown standard deviation standard error Subject 18 Summary Data toolbar tosses Total trendline Two-Sample Wizard Z-Score