This text is essential to professionals and beginning-to-intermediate users who need to keep up-to-date with using the Data Analysis toolset for doing statistically-based business analysis. This book covers it all, with topics that include product testing, decision making, forecasting, model building, and prediction.
The logical hands-on approach shows the reader how to:
- Use Pivot Tables and Pivot Charts to make informed business decisions.
- Use regression and other prediction models to make better short term and long-term predictions.
- Use Solver to solve transportation or distribution problems.
- Use Goal Seek for prediction and analysis.
- Create P, R, and X-bar Charts for quality analysis.
- Use Excel to make more informed business decisions with less risk.
- Use the completely redesigned charting tools.
- Harness the power of the Data Analysis statistical tools.