Calculate means and perform linear regression

profiletomo1
regression_part_of_paper.docx

Having outlined the focus of the study the methodology would involve using a combination of analysis utilizing the calculated mean of the following costs:

1) Diesel powered vehicles

2) Propane powered vehicles

3) Diesel fuel per mile

4) Propane fuel per mile

5) Service life of propane vehicles

6) Service life of diesel vehicles

7) Maintenance cost of propane vehicles

8) Maintenance cost of diesel vehicles

Research, record, calculate and cite sources for the 8 areas above

Perform multiple regression analysis (provide Microsoft excel sheets)

The dependent variable would be the amount in dollars saved and the independent variables would include the calculated means of the variables listed above.

A separate multiple regression would be performed using changing fuel prices as the independent variables. (the difference between propane and gas starting at 10 cents per mile and continuing in 5 cent intervals to 1 dollar)