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 approach makes this book appropriate for statistical analysis in other courses and academic disciplines.
"synopsis" may belong to another edition of this title.
About the Author:
Michael R. Middleton is a Professor of Decision Sciences at the School of Business and Management, University of San Francisco, where he has taught since 1977. He is a member of the Decision Sciences Institute, the Institute for Operations Research and the Management Sciences, and the American Statistical Association. He has published three books with Duxbury, delivered a variety of seminars and workshops in decision science, and authored two decision science software programs.
Review:
1. Introduction to Excel. 2. Managing Files and Printing. 3. Basic Charts. 4. Univariate Numerical Data. 5. Categorical Data. 6. Bivariate Numerical Data. 7. Probability Distributions. 8. Sampling and Simulation. 9. One-Sample Inference for the Mean. 10. Quality Control Charts. 11. Two-Sample Inference for the Mean. 12. Chi-Square Tests. 13. Analysis of Variance. 14. Simple Linear Regression. 15. Simple Nonlinear Regression. 16. Multiple Regression. 17. Regression using Categorical Data. 18. Autocorrelation and Autoregression. 19. Time Series Smoothing. 20. Time Series Seasonality. Appendix. References. Index.
"About this title" may belong to another edition of this title.
- PublisherCengage Learning
- Publication date2003
- ISBN 10 0534402933
- ISBN 13 9780534402938
- BindingPaperback
- Edition number3
- Number of pages296