Linear Correlation and Regression Worksheet Laura has just started her first job as a marketing analyst at a toy store. Her first assignment is to study the advertising expenses and toys sales of the company during the past 12 months. She wants to know if there is any relationship between advertising expenditure and sales. With the information, she would like make recommendation to her supervisor of an appropriate advertising expense to increase sales of the company. Here is the advertising and sales information Laura obtained from the company database. Advertising Expenditure Monthly Sales $ 12,500 $ 330,250 $ 20,000 $ 400,500 $ 13,500 $ 352,500 $ 22,000 $ 412,500 $ 15,700 $ 368,000 $ 19,800 $ 395,000 $ 10,000 $ 295,000 $ 23,500 $ 425,000 1. Use Microsoft excel to Create a scatter plot that captures the data given. Remember to give an appropriate title and label the axes clearly. 2. Find the linear correlation. Do the variables have a positive or negative association? Is the linear association between the two variables strong or weak? 3. Can we say that the advertising expenditure causes the sales to go up or down? 4. Sketch an approximation of the least squares regression