data provided, calculate regression analyses with scatter diagrams and trendlines in Excel, and compare the differences and similarities between children with at least one parent unemployed and children from low-income working families. One regression analysis will compare total public-school students receiving free or reduced-price lunches in Indiana with at least one parent unemployed. Other regression analysis will compare total public-school students receiving free or reduced-price lunches in Indiana with children from low-income working families. Both worksheets should show a Summary Output to include multiple R, R square, adjusted R square, standard error, and number of observations. In addition, include ANOVA calculations and the residual output. 1. Do you see a trend and if so, what is it? 2. What does the data suggest about working or not working and the inuence on student free/reduced lunches? 3. How does Community Eligibility Provision (CEP) potentially impact future data sets? 4. How much "free lunch" is explained by \"low income"? 5. Discuss Multiple R and R-squared and what they indicate about the relationship. Submit your Excel spreadsheet and written conclusion here. Your conclusion can be written on the Excel spreadsheet, in a Word document, or typed in the textbox. You will be graded on your completion of the calculations in Excel and the explanation of your conclusion. Remember to use good grammar, spelling, and punctuation in your explanation and include citations if references are used to support your explanation. This assignment is worth 50 points. Regression 1 Total Public school Children with at least one students receiving free or unemployed parent in reduced price lunches in TimeFrame Indiana Indiana 5008 98,000 408,285 5009 198,000 435,039 5010 198,000 472,078 5011 172,000 489,137 5012 183,000 501,230 5013 127,000 508,582 5014 95,000 512,114 5015 89,000 511,677 5018 82,000 502,452 5017 58,000 493,243 Regression 2 Total Public school students receiving free or Total Children in low- reduced price lunches in income working families Indiana 2008 776,000 408,265 5009 792,000 435,039 2010 851,000 472,076 5011 794,000 489,137 2012 890,000 501,230 2013 914,000 508,582 2014 902,000 512,114 5015 859,000 511,877 2016 870,000 502 ,452 5017 818,000 493,243