Using Ttest for excel database criteria defined arrays

[wdonwhite]

I use excel 2013 database functions to analyze consumer research data. I would like to use an excel T-test for hypothesis testing Database Criteria defined arrays. Is it possible? Office Support says the function is not available in Excel.

 

[AhoyNC]

You should t-test under Data Analysis which is under DATA in the ribbon.
If you don't see Data Analysis you will need to load it.
Goto:
FILE
OPTIONS
ADD-INS
In Manage box choose Excel Add-ins
GO
Check Analysis ToolPak
OK

https://support.office.com/en-us/article/T-TEST-function-d4e08ec3-c545-485f-962e-276f7cbed055

 

[wdonwhite]

Thank you for your suggestions. Data Analysis sets up a Ttest in a foolproof fashion. However, I'd like to be able to use a formula(s) in a worksheet cell so that I can use the database criteria function to define the arrays. So, for example, I could validate the evaluations of specific demographic groups in the data. Thanks for your suggestions.

 

[AhoyNC]

There is a t-test function in Excel, but I don't think there is a database function for the t.test in an current ver. of Excel.