Regression Example

Regression Example - 1. Place data columns with X variables...

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

View Full Document Right Arrow Icon
1. Place data columns with X variables to the left of Y. 2. Plot the data using XY scatter(s). Look for extreme data values that are not indicative of the phenomenon being studied. 3. Excel requires numeric values for all cells of each variable. 4. All of the X variables MUST be in adjacent columns. 5. No X variable can be a linear function of other X variables. (i.e. X1 = 10 + X2 + .3*X3)
Background image of page 1

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

View Full DocumentRight Arrow Icon
Example 9.2, Page 398 Years Salary ($000) X Y 1 23 2 27 4 29 5 34 6 38 9 46 11 48 14 54 16 54 20 59 22 58 24 59 25 61 27 63 29 59 30 60 0 5 10 15 20 25 30 35 0 10 20 30 40 50 60 70
Background image of page 2
Slope for S Independent variables Area # Complaints # of Beds Location Program # of Beds State Rural Urban # of Beds 8 176 3388 Mixed Local 3388 0 0 0 3388 15 273 3117 Mixed Local 3117 0 0 0 3117 18 4 810 Mixed State 810 1 0 0 810 19 17 3292 Mixed State 3292 1 0 0 3292 20 5 356 Mixed State 356 1 0 0 356 1 36 412 Rural Local 412 0 1 0 412 2 22 280 Rural Local 280 0 1 0 280 4 5 650 Rural State 650 1 1 0 650 6 1 1259 Rural
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 06/20/2011 for the course MGMT 524 taught by Professor Andrews,r during the Spring '08 term at VCU.

Page1 / 7

Regression Example - 1. Place data columns with X variables...

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

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