{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

2+Regresion+function (1) - the “best fitting” equation...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Regression Ron Konnick To use Excel to run regressions, do TOOLS, DATA ANALYSIS, REGRESSION. When you press “ok” a window will open asking for details about the regression.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
You are responsible for determining which variable is the “dependent” on, the “y” variable by convention and put the proper range in the “input Y range box.” You must do the same with the independent variable, X by convention. There are several options you may select, including having Excel compute the residual. Note the checked box in the window. This is the output from Excel. Among other things it gives the “R” value, the standard error, appropriate test values for the statistical tests that should be done and the values of
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: the “best fitting” equation. In this example the calculated equation is : Y = 9.03 + 4.79, with an “R” value of .79. (This is the same data set used in the correlation example and the correlation value is also called “R”) For discussion: Try it. Put my data into Excel and run the regression. Did you get what I got? I’d recommend that you open a blank spreadsheet and type in the numbers. Many people have trouble if they try to copy and paste the data, getting a “non-numeric entry” error. X Y 13 81.82 10 81.82 13 58.18 8 43.64 5 40.00 7 36.36 4 34.55 8 32.73 7 29.09 3 25.45...
View Full Document

{[ snackBarMessage ]}