Question: concern have the diesel trucks proven to be cost saving...
Have the diesel trucks proven to be cost saving?
Diesel fuel is 12 cents per gallon cheaper than gasoline
Average Truck gets 10 miles per gallon
Diesel trucks cost more to repair and maintain than gasoline trucks.
Data has been collected on 20 trucks with the following information: age, miles driven and type.
“Tony,” said Mike as he put the data in Table 1 in front of Sanchez, “this data shows that, on average the 6 diesel trucks cost $21,156 in R&M expense whereas the 14 gasoline trucks averaged only $13,269 in R&M expense. I am also surprised that simple correlations show a negative relationship between miles driven and age and between miles driven and type of truck.” Tony looked up at Mike and replied, “Mike can I borrow this data. I have a young college graduate that I just hired and she is very bright. Let me ask her to look at this data and see what she comes up with.”
Assume that you are an analyst working for Tony Sanchez. He has asked you to analyze this data and to address the questions below. Prepare a business memo that addresses his issues.
- Analyze the data using statistical regression analysis to determine the variables that effect repair and maintenance expense of trucks.