statistic Q

• Jaggia Chapter 14, question 41. 
  • Before estimating the regression given in a) produce scatter plots of price (vertical axis) against age (horizontal axis),  and price (vertical axis) against Mileage (horizontal axis).   Use either Excel, Google Sheets, or Minitab to produce scatter plots.
    • Describe the scatter plots in one sentence each
  • Produce the regression output for  41) part a) in Excel. 
  • Include Excel's regression output as  an appendix to your Word Document.  All numbers in this output must be given to no more than 4 decimal places  - use more appropriate rounding in the answer itself
  • Before answering a) produce scatter plots of the response variable (vertical axis), against the explanatory variables Income and GPA (two plots).  Use Google Sheets, or Minitab to produce scatter plots.
  • Describe the scatter plots in one sentence each
• Ideally use Minitab to produce the regression output needed for a).  Excel will work if you do not have access to Minitab.
• Put Minitab output as an appendix  at the end of the document.  The reader of the Word document should be able to skip the Minitab output, and still know what the key numbers from the regression output are.
• Report regression results  for all three models, both in a well formatted, sourced table, and  as sample regression equations

 In addition: d) Fully interpret the regression output for your preferred model (ie interpret the slope coefficients and R2)

question and data see attachment