## MATH 225N Week 8 Assignment Performing Linear Regressions with Technology – Exel

**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.**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.**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.**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.**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.**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.**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.**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 or M⊙ for 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 rbetween the two data sets, rounding to two decimal places.**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.**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.

Play Video

## STATUS

**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.**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 provided below. Use Excel to calculate the correlation coefficient*r*between the two data sets. Round your answer to two decimal places.**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.**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.**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*Use Excel to find the best fit linear regression equation in thousands of dollars. Round the slope and intercept to three decimal places.**Question:**The heights (in inches) and weights (in pounds) of 25 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**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.**Question:**An amateur astronomer is researching statistical properties of known stars using a variety of databases. They collect the absolute magnitude or MVand stellar mass or M⊙ for 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.