Quiz 3
Notes 1) This quiz is graded for 50 points – only one problem.
2) Submit one Word File – not an excel file
3) Answer the questions with the requested chart/tables embedded in the report
4) Neatness matters a lot.
Sloppy presentation will be penalized significantly even if your answers are correct.
You have been asked to study the relationship between the annual maintenance cost of a transit bus and the age of the bus. Specifically, you are trying to determine whether the age of the bus influences the maintenance cost. Data for a sample of 50 buses is included in a file called BusMaint 2019.
Develop a scatter plot of the relationship between the age of the bus in months as the x axis and the annual maintenance cost as the y axis. Show the trend line along with the linear regression equation on the graph, and title the graph, and the axes appropriately.
Develop the ANOVA table using the Excel’s Data Analysis Tool Pack. Show the table in this word document.
What is the estimated regression model equation?
Explain and Illustrate the relation between the SStotal and SSregression and the Coefficient of Determination, R2
Set up the hypothesis to see whether the relationship exists. And comment on the strength df the relationship, if you believe it exists.
What is your prediction on the annual maintenance cost of a 38-month old bus?
