4. Run Excels Regression tool (on a new sheet) to develop a simple linear regression model that can be used to predict sales based on advertising. (You may delete the duplicate 95% columns.)

Please include the excel sheet with the data showing and with the formulas showing.

Please also include what you add in the excel regression tool. If I knew what to do and just needed a screenshot of it done right to verify I did it right I wouldn't be posting here.

Quarter Advertising Sales 1 $30,000 $1,200,000 2 $20,000 $880,000 3 $15,000 $1,800,000 4 $40,000 $1,050,000 5 $10,000 $1,700,000 6 $50,000 $350,000 7 $5,000 $2,500,000 8 $40,000 $760,000 9 $20,000 $2,300,000 10 $10,000 $1,000,000 11 $60,000 $1,570,000 12 $5,000 $2,430,000 13 $35,000 $1,320,000 14 $15,000 $1,400,000 15 $70,000 $1,890,000 16 $25,000 $3,200,000 17 $30,000 $2,200,000 18 $60,000 $1,440,000 19 $80,000 $4,000,000 20 $50,000 $4,100,000