Continuing on with our “What’s inside Excel Everest?” series, which showcases the introductory, “Why is this important?” paragraphs found within Excel Everest.
…why is it important to learn?…
Excel has dozens of statistical formulas to do some highly complicated tests. Six of these stand out as the most essential (unless you’re a master statistician chugging away at some serious stats. In the world of Excel, business, and probably life, you should be familiar with how to use the Median, Mode, Max, Min, Correl, and Stdev formulas, as well as what their results mean. Don’t worry, there is no need to brush up on your stats reading. The hardest concepts you need to be aware of are correlations and standard deviations, which we’ll spend a bit of time talking about.