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.