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

This study source was downloaded by 100000802832151 from CourseHero.com on 11-07-2022 06:20:38 GMT -06:00https://www.coursehero.com/file/60135772/Week-8-Stats-Assignment-Performing-Linear-Regressions-with-Technology-Exel-docx/ Week 8 Stats Assignment- Performing Linear Regressions with Technology -Exel Determine the best fit linear regression equation using Technology - ExcelQ uestionThe 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 linearregression 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 - ExcelQuestionAn economist is studying the link between the total value of a country's exports andthat 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. Correct answers:r= 0.49 Great work! That's correct.Calculate the correlation coefficient using Technology - ExcelQuestionAn 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