There are four related variance functions available in Excel. Use the Insert Function dialog box to find out more information about each one.
If you're not sure which function you should use, there's only so much help that Excel can give you. You need to know enough about statistics to be able to analyze your data.
Even when you think you know which statistical function you want, it's not all plain sailing.
There are many functions in Excel with similar names that are related to one another. Perhaps you've picked a function that does something slightly different from what you intended. To make sure you've got the right one:
- Check the purpose of each individual function in the Insert Function dialog box and use the link to the Help topics.
Note If a function you're looking for isn't available, you may need to install the Analysis ToolPak. For more information, including installation instructions, see the Quick Reference Card.