regression analysis 27

3 excel problems: problems 1, 2 and 4

The book used here is Essentials of business analytics first edition by camm, et. Al.

It is not necessary that you have a copy of the book. The problems are provided here as attached (see screenshots). The excel file to use which contains the data is also attached.

For your final answers: please only use one excel file. Just separate the problem numbers by sheet.

NOTE: problem number 1 has parts a,b,c,d and e. The e part is found on the other screenshot, before problem number 2.

Thanks!!