Microsoft Excel for Mac computers contains many of the same functions as Excel for Windows , including the t-test function. To perform a t-test, you need two sets of data to compare; the data ...

How to do a T-test in Excel Before you can apply a T-test to determine whether there is a statistically significant difference between the means of two samples, you must first perform an F-test.

How to Calculate Variance in Excel To calculate variance in Excel, you will need to have your data set already entered into the software. Once you have your data, you can choose your formula based ...

Averaging in Microsoft Excel is easy, until you start excluding specific values. Here are three ways to average a data set when giving special consideration to the highest and lowest values.