(Continued)Percentage Below PovertyLine (2009)Percentage Without HealthInsurance (2009)StateTexas17.226.1Washington12.312.9Wisconsin12.49.5Source: U.S. Census Bureau, The 2012 Statistical Abstract, 2011, Tables 709 and 156.a. Construct a scatterplot, predicting the percentage without health insurance withthe percentage living below the poverty level. Does it appear that a straight-linerelationship will fit the data?b. Calculate the regression equation with percentage of the population without healthinsurance as the dependent variable, and draw the regression line on the scatterplot.What is its slope? What is the intercept? Has your opinion changed about whethera straight line seems to fit the data? Are there any states that fall far from theregression line? Which one(s)? C4. In 2010, a U.S. Census Bureau report revealed that approximately 14.3% of allAmericans were living below the poverty line in 2009. This figure is higher than in 2000,when the poverty rate was l12.2%. Individuals and families living below the povertyline face many obstacles, the least of which is access to health care. Inliving below the poverty line are without any form of health insurance. Using data fromthe U.S. Census Bureau, analyze the relationship between living below the poverty lineand access to health care for a random sample of 12 states. (The health insurance dataare pre-Affordable Care Act implementation.)many cases, thosePercentage Below PovertyLine (2009)Percentage Without HealthInsurance (2009)State17.916.9Alabama14.220California15.214.3Idaho1617.3Louisiana15.89.4New Jersey14.814.2New York11.412.5Pennsylvania12.311.5Rhode Island17.017.1South Carolina(Continued)

The independent variable is Percentage Below Poverty Line. The dependent variable is Percentage Without Health Insurance. This is simple linear regression model. We have to draw scatter plot and describe the plot. Then find the regression equation, slope, intercept.EXCEL output: Yes, it appears that a straight-line relationship will fit the data.EXCEL (Data Analysis) Procedure: Step 1: In EXCEL sheet, enter Percentage Below Poverty Line in one column and enter Percentage Without Health Insurance in one column. Step 2: In Data, select Data Analysis and choose Regression. Step 3: In Input Variable Y Range: select Percentage Without Health Insurance. Step 4: In Input Variable X Range: select Percentage Below Poverty Line. Step 5: Select Lables. Click Ok. EXCEL (Data Analysis) Output: The regression equation is y^= 2.874 + 0.901 x.Slope = 0.901. Intercept = 2.874. No, the opinion is not changed about whether a straight line seems to fit the data. (9.4, 15.8) and (14.2, 20) and (17.2, 26.1) are fall from the regression line.