All you have to do is provide the data and parameters for each analysis.
Save time by using the Analysis ToolPak for complex statistical or engineering analysis. Don’t worry, there’s a solution to this issue. For example, you can’t see Data Analysis in Excel, Data Analysis is greyed out, or Data Analysis is missing. However, you might notice that you don’t have access to this function.
The Data Analysis function is extremely useful in Microsoft Excel.