Question: i did add excel data please check well Exercise 3-20 Static The accompanying data file shows, among other variables, median household income and median house

 i did add excel data please check well Exercise 3-20 Static
The accompanying data file shows, among other variables, median household income and
median house value for the 50 states. Click here for the Excel
i did add excel data please check well

Exercise 3-20 Static The accompanying data file shows, among other variables, median household income and median house value for the 50 states. Click here for the Excel Data File a. Calculate the range of household income and house value. b. Calculate the mean absolute deviation (MAD) and the standard deviation of household income and house value. Note: Round final answers to 2 decimal places. d-1. Calculate the correlation coefficient between household income and house value. Note: Round final answer to 3 decimal places. d-2. Interpret the correlation coefficient between household income and house value. Strong negative linear relationship between the household income and household value. Strong positive linear relationship between the household income and household value. Positive linear relationship between the household income and household value. Negative linear relationship between the household income and household value. Exercise 3-20 Static The accompanying data file shows, among other variables, median household income and median house value for the 50 states. Click here for the Excel Data File a. Calculate the range of household income and house value. b. Calculate the mean absolute deviation (MAD) and the standard deviation of household income and house value. Note: Round final answers to 2 decimal places. d-1. Calculate the correlation coefficient between household income and house value. Note: Round final answer to 3 decimal places. d-2. Interpret the correlation coefficient between household income and house value. Strong negative linear relationship between the household income and household value. Strong positive linear relationship between the household income and household value. Positive linear relationship between the household income and household value. Negative linear relationship between the household income and household value

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!