Data Analysis Using Microsoft Excel: Updated for Office XP
Spreadsheet skills are important for a first job, and DATA ANALYSIS USING MICROSOFT EXCEL prepares students to enter the world of work with stronger spreadsheet skills. Designed as a supplement to a main statistics text or as a reference for professionals, this handbook helps students build their proficiency in Microsoft Excel and shows them how to use the built-in capabilities of Excel to analyze data and make decisions. Although many of the examples are business oriented, the step-by-step...
Search in google:
This tutorial reference provides lessons on simple and advanced data analysis methods, statistical graphics, and their managerial interpretation. Focus is on statistical analysis, regression models, and forecasting methods as they relate to decision support. Discussions of fundamental concepts help users choose which analytical method is appropriate to the problem. Middleton teaches business at the University of San Francisco. Annotation (c)2003 Book News, Inc., Portland, OR
Ch. 1Introduction to Excel1Ch. 2Managing Files and Printing13Ch. 3Basic Charts25Ch. 4Univariate Numerical Data35Ch. 5Categorical Data49Ch. 6Bivariate Numerical Data61Ch. 7Probability Distributions71Ch. 8Sampling and Simulation85Ch. 9One-Sample Inference for the Mean97Ch. 10Quality Control Charts113Ch. 11Two-Sample Inference for Means123Ch. 12Chi-Square Tests139Ch. 13Analysis of Variance149Ch. 14Simple Linear Regression167Ch. 15Simple Nonlinear Regression183Ch. 16Multiple Regression197Ch. 17Regression Using Categorical Variables207Ch. 18Autocorrelation and Autoregression219Ch. 19Time Series Smoothing233Ch. 20Time Series Seasonality249AppExcel on the Macintosh271References273Index275
