# How can I interpret a regression statistics table in Excel?

##### 1 Answer

I assume you mean this:

The "Coefficients" are the slope or y-intercept in this case. "HH SIZE" refers to the **Slope**, and of course, **Intercept** is the y-intercept.

If you multiply the **Standard Error** by **Associated Error** for either the Intercept or the Slope. The Associated Error is basically the uncertainty you have.

For example, in a standard physics lab course, bare minimum, here's what you would need to know:

**Slope****Intercept****Slope Standard Error**(#SE_"slope"# )**Slope Associated Error**(#AE_"slope"# )**Intercept Standard Error**(#SE_"int"# )**Intercept Associated Error**(#AE_"int"# )

The sample standard deviation is:

#s = sqrt(1/(N-1) sum_(i=1)^N (x_i - barx)^2)#

where

The Standard Error is:

#SE = s/sqrt(N)#

where

#AE = 1.96*SE#

Here is an example of an Ohm's law analysis I did using a similar regression statistics table:

Oftentimes, even in a quantitative analysis course, you only need to further know the **coefficient of determination** *it is only for a linear fit line.*

Other than that, I have not had to use any other quantity on the regression statistics table in my 7 University semesters.