Part III
Advanced Tools
Visit www.dummies.com/extras/exceldataanalysis for more on how to improve your Excel formula-building skills.
In this part â¦
- Use database statistical functions to analyze selected information in a table or list.
- Tap into the power of Excel’s more than 70 statistical functions to calculate averages, determine ranking and percentiles, measure dispersions, and analyze distributions.
- Gain extra insights into your data by using the Data Analysis add-on tool for creating histograms, calculating moving averages, using exponential smoothing, and performing smart sampling.
- Use the regression and correlation tools, the ANOVA data analysis tool, and the z-test, t-test, and Fourier data analysis tools to perform inferential statistics analysis.
Get Excel Data Analysis For Dummies, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
