![]() By default, the results will return the 95% confidence intervals without having to change any options. It is also possible to specify the confidence level for the test. ![]() Generally, for linear regression, this option is not selected, so I will leave it unchecked for this example. Doing so would mean there is no Y intercept in the model. The next option called Constant is Zero is used if you want the regression line to start at 0, otherwise known as the origin. If you didn’t have any labels when you selected your data, then you should not tick this option. If you have highlighted the labels of the columns when selecting the data, then tick the Labels options. Input X Range – this is the data for the X variable, otherwise known as the independent variable.The Y variable is the one that you want to predict in the regression model. Input Y Range – this is the data for the Y variable, otherwise known as the dependent variable.To perform the linear regression, click on the Data Analysis button. ![]() Performing the linear regression in Excel We are now ready to perform the linear regression in Excel. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |