Starting with the bottom box what is the Intercept Coefficie

Starting with the bottom box: what is the Intercept Coefficient?

What is the Age Coefficient?

What is the t Stat for the Age Coefficient?

In the ANOVA box: What is the Degrees of Freedom for Regression?

In the ANOVA box: What is the Degrees of Freedom for Residual?

In the ANOVA box: What is the Degrees of Freedom for Total?

In the ANOVA section what is the SS of the Regression?

In the ANOVA: What is the SS for Residual?

In the ANOVA: What is the SS for Total?

In the ANOVA: What is the MS for Regression?

In the ANOVA: What is the MS for Residual?

In the ANOVA: What is the F in the Regression line?

In the Regression Statistics box: What is the Multiple R?

In the Regression Statistics box: What is the R square?

In the Regression Statistics box: What is the Standard Error?

In the Regression Statistics box: What is the Observations?

Solution

consider the following data:

use EXCEL to create the Regression equation and the ANOVA table is:

From the above output to get the following:

The Age Coefficient is 55.1606.

The t Stat for the Age Coefficient 1.3799.

The Degrees of Freedom for Regression 1.

The Degrees of Freedom for Residual 2.

The Degrees of Freedom for Total 3.

The SS of the Regression 312636.3996.

The SS for Residual 328376.3504.

The SS for Total 641012.75.

The MS for Regression 312636.3996.

The MS for Residual 164188.1752.

The F in the Regression line 1.904135.

The Multiple R 0.698371385.

The R square 0.487722592.

The Standard Error 405.2014008.

The Observations 4.