<< Chapter < Page Chapter >> Page >

The next three questions use the following state information.

State # letters in name Year entered the Union Rank for entering the Union Area (square miles)
Alabama 7 1819 22 52,423
Colorado 1876 38 104,100
Hawaii 1959 50 10,932
Iowa 1846 29 56,276
Maryland 1788 7 12,407
Missouri 1821 24 69,709
New Jersey 1787 3 8,722
Ohio 1803 17 44,828
South Carolina 13 1788 8 32,008
Utah 1896 45 84,904
Wisconsin 1848 30 65,499

We are interested in whether or not the number of letters in a state name depends upon the year the state entered the Union.

  • 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. What does it imply about the significance of the relationship?
  • Find the estimated number of letters (to the nearest integer) a state would have if it entered the Union in 1900. Find the estimated number of letters a state would have if it entered the Union in 1940.
  • 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 number of letters a new state that enters the Union this year would have. Can the least squares line be used to predict it? Why or why not?
  • No
  • y ^ = 47 . 03 0 . 0216 x size 12{y="47" "." "03" - 0 "." "216"x} {}
  • -0.4280
  • 6; 5

We are interested in whether there is a relationship between the ranking of a state and the area of the state.

  • Let rank be the independent variable and area be the dependent variable.
  • What do you think the scatter plot will look like? 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. What does it imply about the significance of the relationship?
  • Find the estimated areas for Alabama and for Colorado. Are they close to the actual areas?
  • 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?
  • Use the least squares line to estimate the area of a new state that enters the Union. Can the least squares line be used to predict it? Why or why not?
  • Delete “Hawaii” and substitute “Alaska” for it. Alaska is the fortieth state with an area of 656,424 square miles.
  • Calculate the new least squares line.
  • Find the estimated area for Alabama. Is it closer to the actual area with this new least squares line or with the previous one that included Hawaii? Why do you think that’s the case?
  • Do you think that, in general, newer states are larger than the original states?

We are interested in whether there is a relationship between the rank of a state and the year it entered the Union.

  • Let year be the independent variable and rank be the dependent variable.
  • What do you think the scatter plot will look like? Make a scatter plot of the data.
  • Why must the relationship be positive between the variables?
  • 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. What does it imply about the significance of the relationship?
  • Let’s say a fifty-first state entered the union. Based upon the least squares line, when should that have occurred?
  • Using the least squares line, how many states do we currently have?
  • Why isn’t the least squares line a good estimator for this year?
  • y ^ = 480 . 5845 + 0 . 2748 x size 12{y= - "480" "." "5845"+0 "." "2748"x} {}
  • 0.9553
  • 1934

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