Center Home -> Content Areas Home -> Math Home -> Project Activities -> Excel Activities -> Analyzing Smoking and Lung Cancer Recommended Explorations of Correlation Coefficient: (Resource #1 for use during the activity) Visit http://sunsite.univie.ac.at/Spreadsite/statexamp and open the Correlation Visualized file. When the dialog box appears, choose Pick Application and open Microsoft Excel (or save to a local disk and open with Excel later). Use the application to explore scatterplots and the associated correlation coefficients. Visit http://www.stat.uiuc.edu/~stat100/java/GCApplet/GCAppletFrame.html . Use this java applet to test your ability to estimate correlation coefficients given a scatterplot image. Recommended Explorations of Least Squares Regression: (Resource #2 for use during the activity) Visit http://www.exploremath.com/activities/Activity_page.cfm?ActivityID=6  Use this web page to explore what is meant by a least squares linear regression line. OR Visit http://forum.swarthmore.edu/dynamic/java_gsp/squares.html . Use this JavaSketchpad application to explore what is meant by a least squares linear regression line. (This "Least Squares" activity can also be found in the Algebra and Analytic Geometry folder in the Sample Sketch folder of The Geometer Sketchpad.) Visit http://www.math.uah.edu/stat/sample/sample9.html .  Scroll down to #14 on the page and use the Interactive Scatterplot (click on the red die) to explore the effect of data points on the correlation and the best fit line. Visit http://www.stat.sc.edu/~west/javahtml/Regression.html . Use this site to explore the effect of an additional data point on the least squares regression line. Visit http://www.stat.uiuc.edu/~stat100/java/guess/PPApplet.html. Use this site to explore regression lines and residuals. Back to Project Activities | Back to Math Homepage Send questions or comments here. Last modified on July 27, 2001.