How to add and use the excel table data analysis function

1. Create and open an excel table

2. First, add the data analysis plug-in. Click the button in the upper left corner to display the menu page. Select "EXCEL options" in the lower right corner and click

3. Click the "add-on" option, select the "Analysis Tool Library", and click the "go to" button below.

4. Then, an excel worksheet is displayed, and the Macro interface is loaded. In the box before "analysis tool library", check and click "OK.

5. After you have successfully added the data analysis plug-in the previous step, you can find it under "data"-"data analysis".

6. Click "data analysis" to find related analysis methods, such as regression analysis, variance analysis, and correlation analysis.