Using Excel, create scatter plots and display the regression equations for the following pairs of variables:
“BachDeg%” versus “Sales/SqFt”
“MedIncome” versus “Sales/SqFt”
“MedAge” versus “Sales/SqFt”
“LoyaltyCard(%)” versus “SalesGrowth(%)”
In your report, include the scatter plots. For each scatter plot, designate the type of relationship observed (increasing/positive, decreasing/negative, or no relationship) and determine what you can conclude from these relationships.
Please use my Supplied Excel Sheet with prior Data.