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

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 DocumentRight 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? Id 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

This note was uploaded on 04/14/2009 for the course BUSINESS Res 320 taught by Professor Diaz during the Spring '09 term at University of Phoenix.

Page1 / 3

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

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online