Home > Topics > excel > How to use excel to do univariate characteristic regression analysis

How to use excel to do univariate characteristic regression analysis

王林
Release: 2019-12-21 09:41:03
Original
2452 people have browsed it

How to use excel to do univariate characteristic regression analysis

In the newly created Excel data table, create two rows of data for analysis.

How to use excel to do univariate characteristic regression analysis

Select all data and click the data analysis option in the data menu item.

How to use excel to do univariate characteristic regression analysis

#By default, Excel tables do not have data analysis options, you need to add it at this time.

Click the option in the File menu, as shown below:

How to use excel to do univariate characteristic regression analysis

In the Excel options, select the add-in option

How to use excel to do univariate characteristic regression analysis

In the add-in, select the Analysis ToolPak option and click OK

How to use excel to do univariate characteristic regression analysis

Then, return to the data form and open the data analysis option

How to use excel to do univariate characteristic regression analysis

In the data analysis dialog box, select the regression option

How to use excel to do univariate characteristic regression analysis

Click the button behind the Y input area, as shown below:

How to use excel to do univariate characteristic regression analysis

Select the Y data area in the window that appears. I selected the A2:A17 area

How to use excel to do univariate characteristic regression analysis

Click The button behind regression returns to the regression dialog box, as shown in the following figure:

How to use excel to do univariate characteristic regression analysis

Use the method of selecting the Y value input area to select the X value input area. In this example, select The area of ​​the

Excel will create a new data table, which displays various analysis results, such as standard errors, observed values, regression analysis, residuals, etc., and also displays observed values, predictions, and residual tablesHow to use excel to do univariate characteristic regression analysis

How to use excel to do univariate characteristic regression analysis

On the right side of the table, the linear fitting plot will be displayed

How to use excel to do univariate characteristic regression analysis

We can Select the table and change the style of the table in Chart Style and Chart Layout in the Design menuHow to use excel to do univariate characteristic regression analysis

Recommended related article tutorials:How to use excel to do univariate characteristic regression analysisexcel tutorial

The above is the detailed content of How to use excel to do univariate characteristic regression analysis. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template