Significance f in regression analysis excel

Multiple linear regression is one of the most commonly used techniques in all of statistics.

This tutorial explains how to interpret every value in the output of a multiple linear regression model in Excel.

Example: Interpreting Regression Output in Excel

Suppose we want to know if the number of hours spent studying and the number of prep exams taken affects the score that a student receives on a certain college entrance exam.

To explore this relationship, we can perform multiple linear regression using hours studied and prep exams taken as predictor variables and exam score as a response variable.

The following screenshot shows the regression output of this model in Excel:

Here is how to interpret the most important values in the output: 

Multiple R: 0.857.

How to interpret significance f in regression

This represents the multiple correlation between the response variable and the two predictor variables.

R Square: 0.734. This is known as the coefficient of determination. It is the proportion of the variance in the response variable that can be explained by the explanatory var

how to get regression output in excel

how to read a multiple regression analysis in excel