HOW TO USE EXCEL FOR DATA ANALYSIS

First, add the data analysis plugin, click the button in the upper left corner, the menu page appears, select the "Excel Options" button in the lower right corner, click and then click on the "Add-ins" option, check the "Analysis Tool Library", and click below"Go to"button, and then the excel loading macro interface appears, tick the box in front of the "Analysis Tools Library", and click OK.

After the previous step, the "Data Analysis Plugin" has been successfully added, which can be found under "Data" - "Data Analysis", 6

Then click "Data Analysis", you can find related analysis methods, such as regression analysis, ANOVA, correlation analysis, etc.

1. Open Excel, switch to the "Data" ribbon, and click the "Self" button.

3. Next, find the data area, and click the "yellow arrow" on the left to select the data area, and click the "Import" button to import the data into Excel.

4. In the opening "Import Data" window, select "Existing Data Table" and set the starting cell for data placement, and then click "OK" button to complete the data import operation.

6. Then you can analyze the generated data, which depends on the specific business requirements. Here, we plan to visualize the sales of each model in the form of a graph. Select the entire data region, switch to the Insert ribbon, and click on one of the line chart styles.

7. Next, the line removal chart will be automatically generated to reflect the sales data in a more intuitive way.

**How-to tutorials.

Here's how:1First of all, you need to install a data analysis tool, the specific method is to click the office button, then the excel option, and then click the add-in in the left menu, after clicking on, there is a management below, click to (excel add-in).

Then check the analysis tool library, and it's OK (there is also an analysis tool library - VBA, this is for programming, generally not used, no need to check).

2.After installation, click on the data, and there is a column at the end of the menu, and the data analysis will appear. Point data analysis, select the histogram and then determine, a dialog box will pop up, the input area is the data you want to analyze, the receiving area is the classification, the output area is just choose a piece by yourself, and then click OK.

As for Plato, the cumulative percentage and the icon output need to be ticked, and if you don't, you don't need to tick. The output result can also be modified according to your own needs, such as changing the name or something.

The diagram is shown below, and the range of each area can be seen in the grid of the dialog box.

1. Excel data analysis, you can use pivot table data to make.

2. Operation process, insert the --- pivot table, and click OK.

3. Set columns and rows of data, and the data will be quickly analyzed.

This is something that needs to be used.

After installing the Excel add-in, in the "Data" menu, there is a "Data Analysis" column, which can be used to analyze more professional data.

The specific setting methods and steps are as follows (take Excel2007 as an example):

1. Enter the excel option;

2. Add-ons - Go to.

3. Select the required "load macro", according to the actual needs, you can select multiple or all of them to determine;

4. In the "Data" menu, find "Data Analysis" and click it;

5. Select the necessary analysis tools, enter the parameters according to the prompts, analyze your data, and after the analysis, the data analysis report can be automatically generated, and the data will be interpreted according to the report.

6. According to the content of the report, make necessary interpretations of the report and data.

First of all, you have to study probability theory and other related courses, and then collect data and enter it.

Finally, there is the analysis.

In data analysis, the fitting of pairs of data is often encountered, involving tasks such as linear description, trending**, and residual analysis. When many professional readers encounter such problems, they often seek professional software, such as ORIGIN, which is often used in chemical engineering, and MATLAB, which is common in mathematics. Although they are very professional, Excel is more than enough.

We already know that there is a linear fitting tool in the database that comes with Excel, but it is still a little thin, and today we will try to use a more professional fitting tool to process this kind of data.

Note: This function needs to use the Excel extension function, if your Excel has not yet installed data analysis, please select "Tools" - "Load Macros" in turn, and load "Analysis Database" with the support of the installation CD. Once the load is successful, you can see the "Data Analysis" option in the "Tools" drop-down menu.

Example: The concentration of a solution is proportional to the peak area in the chromatographic instrument, and a standard curve of the corresponding peak area at different concentrations is now to be established for testing the actual concentration of the unknown sample. Eight sets of corresponding data were known, a standard curve was established, and the curve was evaluated, and the analysis data such as residuals were given.

This is a typical linear fitting problem, and the manual calculation is to use the least squares method to find the undetermined parameters of the fitting line, and at the same time, the value of r can be obtained, that is, the magnitude of the correlation coefficient. In Excel, you can use the method of drawing first and then adding trend lines to complete the requirements of the first two steps.

Select pairs of data columns and make them into a scatter plot using "x, y scatter plot".

Right-click on the data point, select "Add Trend Line" - "Linear", and ask for the formula and correlation coefficient in the option label to get the fitted line.