As a data scientist, you want to analyze the following data collected by your company which relates advertising expenditure A in thousands of dollars to total sales S in thousands of dollars. The following table shows relationship:

Advertising Expenditure (A) Total Sales (S)

22 310

23 320

24 338

24 326

25.5 342

26.3 331

23.4 315

1. Determine if the above relation (A,S) defines a function or not.

2. Using Excel, draw a scatter diagram (plot) of data and linear regression

3. Using Excel, find the line of the best fit the models.

4. Add this line to the scatter diagram

5. Interpret the slope and y intercept of this equation.

6. Express this equation as a function S of A and find its domain

7. Predict the sales if the advertising expenditure is $28000.

Thank you....***please show diagrams since that always helps with understanding the equation as well :)