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 ...

Calculate R-squared in Microsoft Excel by creating two data ranges to correlate. Use the correlation formula to correlate both sets of data, or x and y.