Regression and Scatter plots

profilekmesser16

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. 

  • 6 years ago
  • 30
Answer(1)

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    PastasRUssolution.xlsx