Week 8 Stats Assignment- Performing Linear Regressions with Technology -Exel

Week 8 Stats Assignment- Performing Linear Regressions with Technology -Exel Determine the best fit linear regression equation using Technology - Excel Question The table below shows data on annual expenditure, x (in dollars), on recreation and annual income, y (in dollars), of 20 families. Use Excel to find the best fit linear regression equation. Round the slope and intercept to the nearest integer. y=11.0 X+ 14949 Yes that's right. Keep it up! Calculate the correlation coefficient using Technology - Excel 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. Correct answers: r= 0.49 Great work! That's correct. Calculate the correlation coefficient using Technology - Excel 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. Correct answers: r= −0.17 Yes that's right. Keep it up! Determine the best fit linear regression equation using Technology - Excel 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. y = 2.89 x + 4.69. Perfect. Your hard work is paying off � Determine the best fit linear regression equation using Technology - Excel