87 million on student transportation (for public elementary and secondary education) in 2004-05. A decade later, such expenditure was increased by more than 43% to $1.27 billion.Suppose you are hired by the Pennsylvania Department of Education (PDE) to exam total pupil transportation costs in rural counties and assess the impacts of enrollment on total transportation costs.Assignment:Scatter Plots and CorrelationScatter PlotsCalculate and interpret the correlation between the two relevant variables.Determine whether the correlation is significant.Simple Linear Regression AnalysisCalculate the simple linear regression equation for the set of dataDetermine whether the regression model is significant.Prediction if a school district has an enrollment equal to the last four numbers of your student ID divided by two. What is the expected transportation cost?Submit a professional report and the excel file with all of your calculations presented in an organized and professional manner.
