1. Question: The table below shows data on annual expenditure, x(in dollars), on recreation and annual income, y (in dollars), of 20 Use Excel to find the best fit linear regression equation. Round the slope and intercept to the nearest integer.
2. Question: An economist is studying the link between the total value of a country's exports and that country's gross domestic product, or GDP. The economist recorded the GDP and Export value (in millions of $'s) for 30nations for the same fiscal year. This sample data is provided below. 
3. Question: An economist is trying to understand whether there is a strong link between CEO pay ratio and corporate revenue. The economist gathered data including the CEO pay ratio and corporate revenue for30 companies for a particular year. The pay ratio data is reported by the companies and represents the ratio of CEO compensation to the median employee salary. The data are provided below. Use Excel to calculate the correlation coefficient r between the two data sets. Round your answer to two decimal places.
4. Question: The table below gives the average weight (in kilograms) of certain people ages1–20. Use Excel to find the best fit linear regression equation, where age is the explanatory variable. Round the slope and intercept to two decimal places.
5. Question: In the following table, the age (in years) of is given as thex value, and the earnings (in thousands of dollars) of the respondents the respondents are given as the y  Use Excel to find the best fit linear regression equation in thousands of dollars. Round the slope and intercept to three decimal places.
6. Question: The heights (in inches) and weights (in pounds) of25 baseball players are given below. Use Excel to find the best fit linear regression equation, where height is the explanatory variable. Round the slope and intercept to two decimal places.
7. Question: A market researcher looked at the quarterly sales revenue for a large e-commerce store and for a large brick-and-mortar retailer over the same period. The researcher recorded the revenue in millions of dollars for30  The data are provided below. Use Excel to calculate the correlation coefficient rbetween the two data sets. Round your answer to two decimal places.
8. Question: An amateur astronomer is researching statistical properties of known stars using a variety of databases. They collect the absolute magnitude orMV and stellar mass ..... of light that would be observed from the star at a distance of 10 parsecs from the star. This is measured in terms of a particular band of the light spectrum, indicated by the subscript letter, which in this case is V for the visual light spectrum. The scale is logarithmic and an MV that is 1 less than another comes from a star that is 10 times more luminous than the other. The stellar mass of a star is how many times the sun's mass it has. The data is provided below. Use Excel to calculate the correlation coefficient rbetween the two data sets, rounding to two decimal places.
9. Question: An owner of a large car lot believes that fuel prices are going to rise significantly and wonders how this rise might affect demand for the high performance vehicles. Specifically, the owner is investigating a link between how fast a car can go from0 to 60 miles per hour (measured in seconds) and the car's economy as measured in miles traveled per gallon used (mpg). If fast cars, which are normally high in demand, are associated with higher mpg then there will be much less demand if gas prices rise as predicted. The owner gathers data on 20  The data is provided below. Use Excel to calculate the correlation coefficient rbetween the two data sets. Round your answer to two decimal places.
10. Question: A researcher is interested in whether the variation in the size of human beings is proportional throughout each part of the human. To partly answer this question they looked at the correlation between the foot length (in millimeters) and height (in centimeters) of30 randomly selected adult males. The data is provided below. Use Excel to calculate the correlation coefficient r between the two data sets. Round your answer to two decimal places.

1. Question: An economist is studying the link between the total value of a country's exports and that country's gross domestic product, or GDP. The economist recorded the GDP and Export value (in millions of $'s) for 30 nations for the same fiscal year. This sample data is provided below. 
2. Question: An economist is trying to understand whether there is a strong link between CEO pay ratio and corporate revenue. The economist gathered data including the CEO pay ratio and corporate revenue for 30 companies for a particular year. The pay ratio data is reported by the companies and represents the ratio of CEO compensation to the median employee salary. The data are ... Use Excel to calculate the correlation coefficient r between the two data sets. Round your answer to two decimal places.
3. Question: The table below shows data on annual expenditure, x (in dollars), on recreation and annual income, y (in dollars), of 20 Use Excel to find the best fit linear regression equation. Round the slope and intercept to the nearest integer.
4. Question: The table below gives the average weight (in kilograms) of certain people ages 1–20. Use Excel to find the best fit linear regression equation, where age is the explanatory variable. Round the slope and intercept to two decimal places.
5. Question: In the following table, the age (in years) of the respondents is ... as the x value, and the earnings (in thousands of dollars) of the respondents are ... as the y Use Excel to find the best fit linear regression equation in thousands of dollars. Round the slope and intercept to three decimal places.
6. Question: The heights (in inches) and weights (in pounds) of 25 baseball players are ... Use Excel to ... the best fit linear regression equation, where height is the explanatory variable. Round the slope and intercept to two decimal places
7. Question: A market researcher looked at the quarterly sales revenue for a large e-commerce store and for a large brick-and-mortar retailer over the same period. The researcher recorded the revenue in millions of dollars for 30 The data are provided below. Use Excel to calculate the correlation coefficient r between the two data sets. Round your answer to two decimal places.
8. Question: An amateur astronomer is researching statistical properties of known stars using a variety of databases. ....... 30 The absolute magnitude of a star is the intensity of light that would be observed from the star at a distance of 10 parsecs from the star. This is measured in terms of a particular band of the light spectrum, indicated by the subscript letter, which in this case is V for the visual light spectrum. The scale is logarithmic and an MV that is 1 less than another comes from a star that is 10 times more luminous than the other. The stellar mass of a star is how many times the sun's mass it has. The data is provided below. Use Excel to calculate the correlation coefficient r between the two data sets, rounding to two decimal places.

Calculate the Correlation Coefficient Using Technology - Excel

1. Question: A political scientist wants to establish a link between the approval rating for a certain state governor's office and the state's unemployment rate. Below is data listing both the approval rating and the unemployment rate over 30 years. Use Excel to calculate the correlation coefficient r between the two data sets. Round your answer to two decimal places.
2. Question: In the ... table, the age (in years) of the respondents is ... as the x value, and the earnings (in thousands of dollars) of the respondents are ... as the y value. Use Excel to find the best fit linear regression equation in thousands of dollars. Round the slope and intercept to three decimal places.
3. Question: A market researcher looked at the quarterly sales revenue for a large e-commerce store and for a large brick-and-mortar retailer over the same period. The researcher recorded the revenue in millions of dollars for 30 quarters. The data are provided below. Use Excel to calculate the correlation coefficient r between the two data sets. Round your answer to two decimal places.
4. Question: The table below shows primary school enrollment for a certain country. Here, x represents the number of years after 1820, and y represents the enrollment percentage. Use Excel to find the best fit linear regression equation. Round the slope and intercept to two decimal places.
5. Question: The table below contains the geographic latitudes, x, and average January temperatures, y, of 20 cities. Use Excel to find the best fit linear regression equation. Round the slope and intercept to two decimal places.
6. Question: A government lobby that supports government regulation of the snack industry is looking into snack foods. Looking at a sample of 20 unhealthy snacks (e.g., sweets) they recorded the typical portion size in ounces and the calories per ounce of each snack. This data has been ... Use Excel to calculate the correlation coefficient r between the two data sets. Round your answer to two decimal places.
7. Question: An economist is studying the link between the total value of a country's exports and that country's gross domestic product, or GDP. The economist recorded the GDP and Export value (in millions of $'s) for 30 nations for the same fiscal year. This sample data is provided below. Answer Explanation

Performing Linear Regressions with Technology 

1. Question: An amateur astronomer is researching statistical properties of known stars using a variety of databases. They collect the absolute magnitude or MV and stellar mass or M for 30 stars. The absolute magnitude of a star is the intensity of light that would be observed from the star at a distance of 10 parsecs from the star. This is measured in terms of a particular band of the light spectrum, indicated by the subscript letter, which in this case is V for the visual light spectrum. The scale is logarithmic and an MV that is 1 less than another comes from a star that is 10 times more luminous than the other. The stellar mass of a star is how many times the sun's mass it has. The data is provided below. Use Excel to calculate the correlation coefficient r between the two data sets, rounding to two decimal places.
2. Question: A researcher is interested in whether the variation in the size of human beings is proportional throughout each part of the human. To partly answer this question they looked at the correlation between the foot length (in millimeters) and height (in centimeters) of 30 randomly selected adult males. The data is provided below. Use Excel to calculate the correlation coefficient r between the two data sets. Round your answer to two decimal places.
3. Question: In the following table, the age (in years) of the respondents is given as the x value, and the earnings (in thousands of dollars) of the respondents are given as the y value. Use Excel to find the best fit linear regression equation in thousands of dollars. Round the slope and intercept to three decimal places.
4. Question: The table shows data collected on the relationship between the time spent studying per day and the time spent reading per day. The line of best fit for the data is yˆ=0.16x+36.2. Assume the line of best fit is significant and there is a strong linear relationship between the variables. Studying (Minutes) 507090110 Reading (Minutes) 44485054
5. Question: The table shows data collected on the relationship between the time spent studying per day and the time spent reading per day. The line of best fit for the data is yˆ=0.16x+36.2. Studying (Minutes) 507090110 Reading (Minutes) 44485054
6. Question: Erin is studying the relationship between the average number of minutes spent reading per day and math test scores and has collected the data shown in the table. The line of best fit for the data is yˆ=0.8x+51.2. According to the line of best fit, what would be the predicted test score for someone who spent 70 minutes reading? Is it reasonable to use this line of best fit to make this prediction? Minutes 3035404550 Test Score 7578858890
7. Question: Data is collected on the relationship between the average number of minutes spent exercising per day and math test scores. The data is shown in the table and the line of best fit for the data is yˆ=0.42x+64.6. Minutes 25303540 Test Score 75778081
8. Question: Data is collected on the relationship between the average daily temperature and time spent watching television. The data is shown in the table and the line of best fit for the data is y^=−0.81x+96.7.  Temperature (Degrees) 30405060 Minutes Watching Television 73635748
9. Question: Homer is studying the relationship between the average daily temperature and time spent watching television and has collected the data shown in the table. The line of best fit for the data is yˆ=−0.6x+94.5. Assume the line of best fit is significant and there is a strong linear relationship between the variables. Temperature (Degrees) 40506070 Minutes Watching Television 70655952
10. Question: Homer is studying the relationship between the average daily temperature and time spent watching television and has collected the data shown in the table. The line of best fit for the data is yˆ=−0.6x+94.5.   Temperature (Degrees) 40506070 Minutes Watching Television 70655952
11. Question: Daniel owns a business consulting service. For each consultation, he charges $95 plus $70 per hour of work. A linear equation that expresses the total amount of money Daniel earns per consultation is y=70x+95. What are the independent and dependent variables? What is the y-intercept and the slope?
12. Question: Given the following line, find the value of y when x=2.   y=−4x−12
13. Question: Evaluate the linear equation, y=4x−7, at the value x=2.
14. Question: Evan owns a house cleaning service. For each house visit, he charges $55 plus $30 per hour of work. A linear equation that expresses the total amount of money Evan earns per visit is y=55+30x. What are the independent and dependent variables? What is the y-intercept and the slope?
15. Question: Using a calculator or statistical software, find the linear regression line for the data in the table below. Enter your answer in the form y=mx+b, with m and b both rounded to two decimal places.
16. Question: Using a calculator or statistical software, find the linear regression line for the data in the table below. Enter your answer in the form y=mx+b, with m and b both rounded to two decimal places.
17. Question: A least squares regression line (best-fit line) has the equation, yˆ=2.87x−43.5. What is the slope of this linear regression equation?
18. Question: Researchers want to find the relationship between age and average weight in female children. Using a calculator or statistical software, find the linear regression line for the 2012 CDC data below for average weights of female children by age.
19. Question: Given that n=31 data points are collected when studying the relationship between average daily temperature and time spent sleeping, use the critical values table below to determine if a calculated value of r=−0.324 is significant or not.
20. Question: In studying the relationship between age and eating fast food, suppose you computed r=0.133 using n=19 data points. Using the critical values table below, determine if the value of r is significant or not.
21. Question Data is collected on the relationship between the time spent doing homework per day and the time spent taking notes per day. The data is shown in the table and the line of best fit for the data is yˆ=0.175x+31.0. Assume the line of best fit is significant and there is a strong linear relationship between the variables.
22. Question: Michelle is studying the relationship between the hours worked (per week) and time spent reading (per day) and has collected the data shown in the table. The line of best fit for the data is yˆ=−0.79x+98.8. Assume the line of best fit is significant and there is a strong linear relationship between the variables.  Hours Worked (per week) 30405060 Minutes Reading (per day) 75685852
23. Question: Michelle is studying the relationship between the hours worked (per week) and time spent reading (per day) and has collected the data shown in the table. The line of best fit for the data is yˆ=−0.79x+98.8….. Hours Worked (per week) 30405060 Minutes Reading (per day) 75685852
24. Question: The table shows data collected on the relationship between time spent playing video games and time spent with family. The line of best fit for the data is yˆ=−0.24x+71.7. Assume the line of best fit is significant and there is a strong linear relationship between the variables. Video Games (Minutes) 45607590 Time with Family (Minutes) 61575450
25. Question: The table shows data collected on the relationship between time spent playing video games and time spent with family. The line of best fit for the data is yˆ=−0.24x+71.7. …. Video Games (Minutes) 45607590 Time with Family (Minutes) 61575450
26. Question: A scientific study on calorie intake gives the following data table. Using technology, it was determined that the total sum of squares (SST) was 76, the sum of squares regression (SSR)was 54.850, and the sum of squares due to error (SSE) was 21.150. Calculate R2 and determine its meaning. Round your answer to four decimal places?
27. Question: A non-profit finds that donations decrease when the economy measured by GDP decreases.  Identify the relation between donations and GDP.
28. Question: Which of the following data sets or plots could have a regression line with a negative slope.
29. Question: What percent of aluminum in the soil must there be for the daffodils to grow only by 5 centimeters? 
30. Question: A gym teacher finds that the distance students run in miles per week in gym class, D, is dependent on the time students warm-up beforehand in minutes per week, x, and can be modeled by the function
31. Question: A random sample of 11 university students produced the following data where x is the minutes spent studying per day, and y is the first exam score (out a maximum of 100 points). What is the value of the intercept of the regression line, b rounded to one decimal place.  
32. Question: Which of the following data sets or plots could have a regression line with a negative y-intercept?

Calculate the Correlation Coefficient Using Technology - Excel

1. Question: A political scientist wants to establish a link between the approval rating for a certain state governor's office and the state's unemployment rate. Below is data listing both the approval rating and the unemployment rate over 30 years. Use Excel to calculate the correlation coefficient r between the two data sets. Round your answer to two decimal places.
2. Question: In the following table, the age (in years) of the respondents is given as the x value, and the earnings (in thousands of dollars) of the respondents are given as the y value. Use Excel to find the best fit linear regression equation in thousands of dollars. Round the slope and intercept to three decimal places.
3. Question: A market researcher looked at the quarterly sales revenue for a large e-commerce store and for a large brick-and-mortar retailer over the same period. The researcher recorded the revenue in millions of dollars for 30 quarters. The data are provided below. Use Excel to calculate the correlation coefficient r between the two data sets. Round your answer to two decimal places.
4. Question: The table below shows primary school enrollment for a certain country. Here, x represents the number of years after 1820, and y represents the enrollment percentage. Use Excel to find the best fit linear regression equation. Round the slope and intercept to two decimal places.
5. Question: The table below contains the geographic latitudes, x, and average January temperatures, y, of 20 cities. Use Excel to find the best fit linear regression equation. Round the slope and intercept to two decimal places.
6. Question: A government lobby that supports government regulation of the snack industry is looking into snack foods. Looking at a sample of 20 unhealthy snacks (e.g., sweets) they recorded the typical portion size in ounces and the calories per ounce of each snack. This data has been included below. Use Excel to calculate the correlation coefficient r between the two data sets. Round your answer to two decimal places.
7. Question: An economist is studying the link between the total value of a country's exports and that country's gross domestic product, or GDP. The economist recorded the GDP and Export value (in millions of $'s) for 30 nations for the same fiscal year. This sample data is provided below. Answer Explanation