Using Data > Data Analytics in Excel, do a linear regression for each type of car. Put this output on the same page as your scatter plot. NOTE: If your regression coefficients do not match the trend line equation for each car type, double check your work 7.Use Excel to calculate the correlation coefficient using the =CORREL command for each car type. Additionally,calculate the coefficient of determination for each car type as well. Put these values near your regression output. Do these values match what you found in your regression output?
Solved by Z. H. in 27 mins