Project two, Math 240

MAT 240 Scatterplots in Excel Tutorial This tutorial will guide you through the steps necessary to create scatterplots using your data. It will also walk you through inserting a linear trend line and inserting the regression equation and the R-squared value on the chart. 1. Open your data set in Excel.

2. Select all the data for the two variables you are targeting (e.g., median listing price and median square feet).

Tip: Holding down the Ctrl key while selecting your data will allow you to select two columns of data that are not next to each other.

3. On the Insert tab, click the Recommended Charts button.

This will bring up the Insert Chart dialog box, which prompts you to select from the list of auto-generated charts. If Scatter is not one of the options, click the All Charts tab. Then select X Y (Scatter) and select the chart on the right side. Click OK.

4. With the new chart selected, go to the Chart Design tab and click the Add Chart Element button. In the drop-down menu, hover over Trendline and select More Trendline Options.

5. In the Format Trendline sidebar, select Linear. At the bottom, check the boxes for these options:

 Display Equation on Chart  Display R-Squared Value on Chart

6. Close the Format Trendline sidebar and move the equation and R-squared value to the side so that it is visible.

Tip: You can use an empty cell to have Excel calculate the square root of your R-squared value by selecting an empty cell in your sheet and using the =sqrt() function.

Type your R-squared value into the parenthesis and hit enter.