Kids Count

According to the USDA Economic Research Center (Links to an external site.), “Any student in a participating school can get an NSLP lunch regardless of the student’s household income.” Using the Kids Count Download Kids Countdata 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 and the 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.
Do you see a trend and if so, what is it? What does the data suggest about working or not working and the influence on student free/reduced lunches? How does Community Eligibility Provision (CEP) potentially impact future data sets?

References from The Annie E Casey Foundation, Kids Count Data Center:
Children with at least one unemployed parent in Indiana (Links to an external site.).
Public school students receiving free or reduced price lunches in Indiana. (Links to an external site.)
Children in low-income working families in Indiana by age group.

Last Completed Projects