Linear Regression
Data Analysis Home

Data Set 1

Problem 2

Return to Introduction


On-Line Glossary

Excel How To...

last modified on 1/23/07

email comments to harvey@depauw.edu or william.otto@maine.edu

Problem 1

Open Data Set 1, using the link on the left, which is an Excel file containing 11 paired X and Y values.

Task 1. Calculate the mean and standard deviation for the 11 X values and for the 11 Y values. Briefly explain the meaning of these values.

Task 2. Prepare a scatterplot of the data and model the data by adding a linear trendline (a linear regression); be sure to display both the equation and the R-squared value on your scatterplot. How well does this model appear to explain the data?

After completing these tasks, proceed to Problem 2.