For each age group, pick the midpoint of the interval for the x value. (For the 75+ group, use 80.)
Using “ages” as the independent variable and “Number of driver deaths per 100,000” as the dependent variable, make a scatter plot of the data.
Calculate the least squares (best–fit) line. Put the equation in the form of:
Find the correlation coefficient. Is it significant?
Pick two ages and find the estimated fatality rates.
Use the two points in (e) to plot the least squares line on your graph from (b).
Based on the above data, is there a linear relationship between age of a driver and driver fatality rate?
What is the slope of the least squares (best-fit) line? Interpret the slope.
The average number of people in a family that received welfare for various years is given below. (Source:
House Ways and Means Committee, Health and Human Services Department )
Year
Welfare family size
1969
4.0
1973
3.6
1975
3.2
1979
3.0
1983
3.0
1988
3.0
1991
2.9
Using “year” as the independent variable and “welfare family size” as the dependent variable, make a scatter plot of the data.
Calculate the least squares line. Put the equation in the form of:
Find the correlation coefficient. Is it significant?
Pick two years between 1969 and 1991 and find the estimated welfare family sizes.
Use the two points in (d) to plot the least squares line on your graph from (b).
Based on the above data, is there a linear relationship between the year and the average number of people in a welfare family?
Using the least squares line, estimate the welfare family sizes for 1960 and 1995. Does the least squares line give an accurate estimate for those years? Explain why or why not.
What is the estimated average welfare family size for 1986? Does the least squares line give an accurate estimate for that year? Explain why or why not.
What is the slope of the least squares (best-fit) line? Interpret the slope.
-0.8533, Yes
No
2.93, Yes
slope = -0.0432. As the year increases by one, the welfare family size tends to decrease by 0.0432 people.
Use the AIDS data from the
practice for this section , but this time use the columns “year #” and “# new AIDS deaths in U.S.” Answer all of the questions from the practice again, using the new columns.
The height (sidewalk to roof) of notable tall buildings in America is compared to the number of stories of the building (beginning at street level). (Source:
Microsoft Bookshelf )
Height (in feet)
Stories
1050
57
428
28
362
26
529
40
790
60
401
22
380
38
1454
110
1127
100
700
46
Using “stories” as the independent variable and “height” as the dependent variable, make a scatter plot of the data.
Does it appear from inspection that there is a relationship between the variables?
Calculate the least squares line. Put the equation in the form of:
Find the correlation coefficient. Is it significant?
Find the estimated heights for 32 stories and for 94 stories.
Use the two points in (e) to plot the least squares line on your graph from (b).
Based on the above data, is there a linear relationship between the number of stories in tall buildings and the height of the buildings?
Are there any outliers in the above data? If so, which point(s)?
What is the estimated height of a building with 6 stories? Does the least squares line give an accurate estimate of height? Explain why or why not.
Based on the least squares line, adding an extra story is predicted to add about how many feet to a building?
What is the slope of the least squares (best-fit) line? Interpret the slope.
Yes
0.9436; yes
478.70 feet; 1207.73 feet
Yes
Yes;
172.98; No
11.7585 feet
slope = 11.7585. As the number of stories increases by one, the height of the building tends to increase by 11.7585 feet.
Receive real-time job alerts and never miss the right job again
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?