Click Data, then look for the Analysis group and click on Data Analysis. After selecting Data Analysis, select Regression, then click OK$.$ Now you have to tell Excel where to find the data for the dependent variable $($Y Range$)$ and the independent variable $($X Range$).$ Click to put the cursor inside the Input Y Range box. Highlight the column of MedInc data $($including the column heading$).$ Repeat the above procedure for the Input X Range box, using the data in the HSDegree column.

Mark the other input information as appropriate. For example, check the "labels" box to let Excel know that you highlighted the column heading along with the data.

Tell Excel where to put the output $($the default is to place it in a separate worksheet $$ this is what I would recommend for this output$).$ Maybe label the new worksheet as Simple Regression.

Excel always provides the basic results from your regression. This is all that I want you to turn in$.$ Copy the regression results onto the sheet titled "Question $4".$

If you have extra time to play around with the data, you can make some selections in the Residuals section, but please delete extraneous items before submitting your assignment. Often the Line Fit Plots are interesting. When you have made all your selections, click OK$.$

Your regression results table may be scrunched. If so$,$ while the regression results are still highlighted, click on the Home tab. Find the Cells group, then select Format, then AutoFit Column Width. Excel will automatically widen the columns so that you can read everything.

If you selected one of the plots, you can expand the size of the chart using the graphing methods discussed in your first Excel assignment. But remember to delete these extra items before submission.

Record your responses to the following $6$ questions in the Excel sheet on the "Question $4"$ tab.

$1)$ List $($and label$)$ the dependent variable and the independent variable.

$2)$ Based on the regression results, if a county$$s percent of the population with at least a high school diploma increases by $1,$ by how much and in what direction does a county$$s Median Income change?

$3)$ What is the predicted MedInc for a HSDegree of $70$ percent?

$4)$ What proportion of the variation in MedInc is explained by our regression model $($explained by variation in HSDegree$)?$

$5)$ Suppose you want to test for a statistically significant relationship between HSDegree and MedInc. Write down the null hypothesis and alternative hypothesis that incorporates the coefficient associated with HSDegree.

$6)$ Calculate the $95\%$ confidence interval for the HSDegree coefficient. Based on this confidence interval, is there a statistically significant relationship between HSDegree and MedInc?