How Excel data analysis functions are added and used

1, take the office07 version as an example; Create and open an Excel table, as shown in

2, first add data Analysis plug-in, click on the top left corner button, appear menu page, select the lower right corner "Excel Options" button, click, as shown

3, then click the "Add-ins" option, select the "Analysis Tool Library", click the "Go to" button below, as shown

4, then appear Excel add-in interface, in the "Analysis ToolPak" in front of the box tick, click OK.

5, after the previous step has been successfully added "data Analysis plug-in", "Data"-"data analysis" can be found, as shown in

6, then click on "Data Analysis", you can find the relevant analytical methods, such as regression analysis, variance analysis, correlation analysis and so on.