|
Hand in next class: More regression (esp. Fact 4) C. Use the Excel RSquared page.
(Using Excel 2007 (in the labs )R-Squared07 (ClassMaterial\Math151BPS4e\RegressionDemosExcel07) Using an older Excel? R-Squared
(or RSquared.xls: ClassMaterial\Math151BPS4e\RegressionDemos
OlderExcel)). Shift points around, by
typing new values (Excel 07) or dragging points (older Excel)
and get an r2 close to .8 (80%) (Between .75 and .85
is good enough.Try the same x's, and y's 4,17,15,32
). Note that if r = +.9, then
r2 = .81. Now shift the points so that r is negative
and r2 is close to .8.Try the same
x's, and y's going high to low. Adjust. Print the resulting page to hand in. (Data and graph)
|
Read to discuss Regression: Use http://www.whfreeman.com/bps4e, Correlation and Regression applet to do p. 148, 5.55 , guessing lines Look at this, especially with reference to the r standard deviations in y for every 1 standard deviation in x: A. Open the Excel file.Using Excel 2007 (in the labs)? RegressionSlope07 Using an older Excel? RegressionSlope (or in the folders RegressionDemosExcel07, or RegressionDemos OlderExcel in ClassMaterial\Math151-BPS4e). Change x-y values in the yellow boxes and watch the line change. Change x-values in col. F and watch the "run" (red line) change, in the rightmost 2 graphs. Notice the slope = the coefficient of x = the rise/run = increase in y per unit increase in x. Fix it so the increase in x (the "run") is exactly 1. Also, look at the leftmost graph, where the length of the standard deviations are shown, and note that in standard-deviation units, the rise is r s.d.'s in y for each s.d. run in x. (Fact 2) |
Optional
p. 179, 7.27 (review Normal) |
= = = = Continue today with regression.
= = =
review Regression line: Ch. 5, Predicts or estimates a y (vertical)
value for a given x (horizontal) value: Straight line! Details Day
13 (Cornplants: P110,
4.28, predicting with a curve (broken line))
Experimenting http://www.whfreeman.com/bps4e,
Correlation and Regression Applet.
SPSS--graph line, p. 2 top of handout link.
formula p. 4 of handout link. . Read off
"coefficients" (intercept and slope) from table.
Govsal on avgpay
Formula yhat = a + b x. (yhat means we're finding a sort
of average y for each particular x).
Govsal = a + b avgpay
a is y-intercept. b is
slope: If x increases one unit, yhat increases b units.
(b multiplies the x-variable.)
Predicting a y for a given x: Plug in to formula. (Graphical:
"Up and over")
Graphing line: Pick an (easy) x-value at one end of
the useful range. Plug in to the formula and calculate the corresponding
y. Graph the (x,y) pair. Repeat with an x value at the other end
of the range. Connect the 2 dots with a line (see pretest). Insurance:
Pick a third x and calculate the y. This point must also lie on the line,
if you did it right.) Table x | y is
good to organize work.
Homework questions? Day 14
In-class work: Handout, Kneeheight.doc: Do 1 thru 5. Each gets a paper, but work together. Put your name; put your co-workers' name(s) in parentheses ( ). Solutions.
Facts: 1& 2 lite, & 3 first. Then 4. Next 2 &Formulas p. 120, from 2&3.
| Sievers home | Math151-Sp09/Daysp15.htm | 3pm | 2/27/09 |