Mathematics > STUDY GUIDE > MATH 225N Week 8 Stats Assignment-Performing Linear Regressions with Technology | Performing Linear (All)
MATH 225N Week 8 Stats Assignment-Performing Linear Regressions with Technology | Performing Linear Regressions with Technology
Document Content and Description Below
MATH 225N Week 8 Stats Assignment-Performing Linear Regressions with Technology Week 8 Stats Assignment- Performing Linear Regressions with Technology 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 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: 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. - - - - - - - - - - - - - - - -- The correlation coefficient can be calculated easily with Excel using the built-in CORREL function. 1. Open the accompanying data set in Excel. 2. In an open cell, type "=CORREL(A2:A31,B2:B31)", and then hit ENTER. You could label the result of this cell by writing "Correlation coefficient" or "r" in an adjacent open cell. The correlation coefficient, rounded to two decimal places, is r≈0.50. [Show More]
Last updated: 2 years ago
Preview 1 out of 5 pages
Buy this document to get the full access instantly
Instant Download Access after purchase
Buy NowInstant download
We Accept:
Reviews( 0 )
$11.00
Can't find what you want? Try our AI powered Search
Document information
Connected school, study & course
About the document
Uploaded On
Dec 17, 2020
Number of pages
5
Written in
Additional information
This document has been written for:
Uploaded
Dec 17, 2020
Downloads
0
Views
109
