<< Chapter < Page Chapter >> Page >

The following are advertised sale prices of color televisions at Anderson’s.

Size (inches) Sale Price ($)
9 147
20 197
27 297
31 447
35 1177
40 2177
60 2497

  • Decide which variable should be the independent variable and which should be the dependent variable.
  • Make a scatter plot of the data.
  • Does it appear from inspection that there is a relationship between the variables? Why or why not?
  • Calculate the least squares line. Put the equation in the form of: y ^ = a + bx size 12{y=a+ ital "bx"} {}
  • Find the correlation coefficient. Is it significant?
  • Find the estimated sale price for a 32 inch television. Find the cost for a 50 inch television.
  • Use the two points in (f) to plot the least squares line on your graph from (b).
  • Does it appear that a line is the best way to fit the data? Why or why not?
  • Are there any outliers in the above data?
  • What is the slope of the least squares (best-fit) line? Interpret the slope.

Below are the average heights for American boys. (Source: Physician’s Handbook, 1990 )

Age (years) Height (cm)
birth 50.8
2 83.8
3 91.4
5 106.6
7 119.3
10 137.1
14 157.5

  • Decide which variable should be the independent variable and which should be the dependent variable.
  • Make a scatter plot of the data.
  • Does it appear from inspection that there is a relationship between the variables? Why or why not?
  • Calculate the least squares line. Put the equation in the form of: y ^ = a + bx size 12{y=a+ ital "bx"} {}
  • Find the correlation coefficient. Is it significant?
  • Find the estimated average height for a one year–old. Find the estimated average height for an eleven year–old.
  • Use the two points in (f) to plot the least squares line on your graph from (b).
  • Does it appear that a line is the best way to fit the data? Why or why not?
  • Are there any outliers in the above data?
  • Use the least squares line to estimate the average height for a sixty–two year–old man. Do you think that your answer is reasonable? Why or why not?
  • What is the slope of the least squares (best-fit) line? Interpret the slope.
  • Yes
  • y ^ = 65 . 0876 + 7 . 0948 x size 12{y="65" "." "0876"+7 "." "0948"x} {}
  • 0.9761; yes
  • 72.2 cm; 143.13 cm
  • Yes
  • No
  • 505.0 cm; No
  • slope = 7.0948. As the age of an American boy increases by one year, the average height tends to increase by 7.0948 cm.

The following chart gives the gold medal times for every other Summer Olympics for the women’s 100 meter freestyle (swimming).

Year Time (seconds)
1912 82.2
1924 72.4
1932 66.8
1952 66.8
1960 61.2
1968 60.0
1976 55.65
1984 55.92
1992 54.64
2000 53.8
2008 53.1

  • Decide which variable should be the independent variable and which should be the dependent variable.
  • Make a scatter plot of the data.
  • Does it appear from inspection that there is a relationship between the variables? Why or why not?
  • Calculate the least squares line. Put the equation in the form of: y ^ = a + bx size 12{y=a+ ital "bx"} {}
  • Find the correlation coefficient. Is the decrease in times significant?
  • Find the estimated gold medal time for 1932. Find the estimated time for 1984.
  • Why are the answers from (f) different from the chart values?
  • Use the two points in (f) to plot the least squares line on your graph from (b).
  • Does it appear that a line is the best way to fit the data? Why or why not?
  • Use the least squares line to estimate the gold medal time for the next Summer Olympics. Do you think that your answer is reasonable? Why or why not?

Get Jobilize Job Search Mobile App in your pocket Now!

Get it on Google Play Download on the App Store Now




Source:  OpenStax, Collaborative statistics using spreadsheets. OpenStax CNX. Jan 05, 2016 Download for free at http://legacy.cnx.org/content/col11521/1.23
Google Play and the Google Play logo are trademarks of Google Inc.

Notification Switch

Would you like to follow the 'Collaborative statistics using spreadsheets' conversation and receive update notifications?

Ask