A small business tracks how advertising spending relates to weekly sales.(A)\left(A\right) Plot Advertising Spending (x) vs Sales (y) & find the regression line & correlation coefficient.

y = 20.587 x + 2015.6 y=20.587x+2015.6 , 0.985 0.985

A small business tracks how advertising spending relates to weekly sales. ( A ) \left(A\right) Plot Advertising Spending (x) vs Sales (y) & find the regression line & correlation coefficient.

Welcome to the practice. In this problem, we have a small business tracking how advertising spending relates to weekly sales. In part a, we'd like to plot advertising spending, x, versus sales, y, and find the regression line and correlation coefficients. So let's start by getting our scatter plot. We can begin by clicking and selecting our x data, advertising, and y data, sales. Once everything's highlighted, we'll head up to the top menu, click on insert, click on the scatter plot icon under charts, and choose the first option for a scatter plot. And we should adjust the chart title to be what we're seeing, which is ad spending versus sales. Once that's all set, I'm just going to move my scatter plot off the practice problem. Next, we need to get our regression line equation. We need to get to the chart elements menu. You can either get to that from the top ribbon or by clicking on this axis icon here. We wanna check off trend line, click on this arrow here, go to more options, make sure that linear is selected, which should be the default, and check off display equation on chart, and we'll see the regression line equation appear on our chart. Next, we can exit out of this menu, and we wanna find the correlation coefficient. We'll use the equals coral function that we've used before to get that r value. So I'm going to come over here, type equals coral, open parenthesis, click and select the x data, advertising, do a comma, and click and select the y data, sales. Then click enter, and we get the correlation coefficient, r, at about 0.985. Great work.