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


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
Get step-by-step solutions from verified subject matter experts
