Use excel to generate scatterplots, descriptive statistics, and regression equations.An additional observation at the bottom of the data file, needs to be added to the dataset. You should clearly mark on the Excel or Minitab file, which dataset (entire or Canon only) and which regression you are generating. You should run 3 separate regressions for the entire data set and 3 more for the Canon only dataset. Thus you should run 6 separate regressions (each in a separate worksheet) and clearly marked with a worksheet title (Entire,price) or (Canon,weight), etc.
Attachment:- 222.xlsx