Statistical Analysis with Excel For Dummies (For Dummies (Computer/Tech))

Statistically speaking, Excel^(R) does it all

Data can tell you interesting things, if you know how to ask. Statistical Analysis with Excel^(R) For Dummies will coach you through formulating the right questions. Create graphs, calculate means and medians, and whip up some conclusions with analysis of variance, regression analysis, and more. Then, when you're feeling lucky, dive into probability and modeling. We make it all come to life with step-by-step guidance, downloadable spreadsheets, and everything you need to Excel in stats.

Inside...

• Updated for Microsoft 365^(R)
• New--logistic regression
• Creating simulations
• Organizing data
• Visualizing data with charts
• Confidence intervals, sampling distributions, t-tests, and more
• Non-parametric statistics