"Express analysis" function

tata_frolova 

Your original inquiry is very precise,

Can you please tell me how to set up the "express analysis" function on MAC?

I've highlighted what I refer to as "very precise." In essence, I'm echoing the request of NikolinoDE , that you give us some background about

• "the (definitive article) 'express analysis' function" -- you seem certain that there IS a function that goes by that name
• MAC -- are you referring to an Apple Mac computer, or, since you capitalized each letter, are you referring to something else, perhaps a different software package?

tata_frolova 

You can try to enable the “Analysis ToolPak” add-in in Excel for Mac.

This add-in provides a set of data analysis tools that you can use to perform complex data analysis tasks, including regression analysis, ANOVA, and t-tests.

Here’s how you can enable the “Analysis ToolPak” add-in in Excel for Mac:

1. Open Excel for Mac.
2. Click on the “Tools” menu and select “Add-Ins”.
3. In the “Add-Ins” dialog box, check the box next to “Analysis ToolPak” and click “OK”.
4. The “Data Analysis” command should now be available in the “Data” tab of the Excel ribbon.

According to a post on the Microsoft Community Hub, the “Express Analysis” function should automatically appear when the necessary cells are selected

Please note that the Analysis ToolPak is not included in Excel LTSC for Mac 2021 for commercial customers.

I hope this helps! 🙂

*Information and formulas without guarantee.