Correlation, regression line

 To start, click here:
 
  • Confidence interval
  • regression line
 Excel tools for linear regression :
  • The most simple: The trendline ,but there miss informations, in particular the standard deviation (and so uncertainty) of the slope...
  • Less convivial but more completeLINEST (droitereg in french)




The general theory of least squares...
The particular case of the linear hypothesis:
 2 ways for minimizing the error, corresponding to 2 possible hypothesis on the source of the random errors: They are brought either by X variables, or by Y variables.

Useless to retain these formulas, low cost scientific calculator, and of course Excel do that very well...

Useless to retain these formulas, low cost scientific calculator, and of course Excel do that very well...