BIT 3434 Chapter 9: Regression Analysis
4 Mar 2017
School
Department
Course
Professor
Document Summary
Used to estimate a function that describes the relationship between a continuous dependent variable and one or more independent variables. F() describes systematic variation in the relationship. Is the estimated (of fitted) value of y at a given level of x. Error sum of squares (ess): (actual y ) sums squared: try to minimize the ess. = b0 + b1x1 + bkxk1 . Optimal values for bi can be found by minimizing ess. The more independent variables (iv) added to the model, the bigger the non-adjusted r^2 gets. Adjusted r^2 can increase or decrease with more independent. Adjusted r^2 = 1 (ess / tss) x (n-1 / n-k-1) Adding too many independent variables could overfit the model. The row-number: the row position where the value you want to lookup is located. The column-number: the column position where the value you want to lookup is located. Y-range: spreadsheet range containing the dependent (y) variable.
