Step $1$

From the Data menu, select Data Analysis, then select Regression.

Step $2$

Enter the appropriate Input Y Range and Input X Range:

The Input Y Range is the dependent variable, in this case selling price. The data are in column C with its label, C$1$:C$31.$

The Input X Range is the independent variable, in this case house size. To ensure the independent variable is labeled correctly in the output table, enter the data with its label in column B$,$ B$1$:B$31.$

Since we included the cells containing the variables$$ labels when inputting the ranges, check the Labels box.

We have already entered E$1$ as the output range.

Step $3$

Scroll down and make sure to check the Residuals and Residual Plots boxes to ensure we see the relevant residual information. $($Note that you will not be able to submit if you do not include the residual plot.$)$

Note

To view the regression output, expand the residual plot and move it to the side.

fx$=$SQRT$($F$5)$

Having Trouble?

Carefully compare your regression setup to the instructions. Nearly all issues with regression are due to a misconfiguration in the setup.

Note that you may need to choose "Wait" more than once to complete the process. Make sure that you are working from an up$-$to$-$date browser and try switching browsers $($Firefox to Chrome or vice$-$versa$)$ as a possible solution.

If issues persist, click "Reset" to clear the current task. Start over, being sure to take a screen shot of your regression setup before running the regression again. If you're still not able to submit, send the s