Menu
The Excel Data Analysis add-in provides three tools for working with t-values and t-tests, which can be very useful when you want to make inferences about very small data sets:
I documented my experiences via a blog 'Financial modelling techniques between Microsoft Excel and Excel for Mac' on my website. The features to watch out for were namely: ActiveX macros won’t work on a Mac Data Analysis Toolpak is not officially supported currently Inserting Adobe Objects in Excel for Mac does not exist currently,.
Briefly, here’s how these three tools work. For sake of illustration, assume that you’re working with these values. The worksheet range A1:A21 contains the first set of values. The worksheet range B1:B21 contains the second set of values.
To perform a t-test calculation, follow these steps:
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |