**Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates**

For This or a Similar Paper Click To Order Now

Pennsylvania spent $882.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 Correlation

o Scatter Plots

o Calculate and interpret the correlation between the two relevant variables.

o Determine whether the correlation is significant.

• Simple Linear Regression Analysis

o Calculate the simple linear regression equation for the set of data

o Determine 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.