I have proposed that propane vehicles will ultimately reduce operating costs.

The issue is that propane delivery vehicles cost on average 8000 dollars more than diesel vehicles ($65,000 and 83,000 on average)

If my dependent variable is dollars saved (because eventually I need to make up the additional $8000 I spent on the propane vehicle) the independent variables would be things such as the average price difference per mile for fuel which is equal to 0.06 dollars or 6 cents. (average cost of diesel vehicles is 0.31 cents per mile and 25 cents per mile for propane)

The difference in maintaining those vehicles is 0.02 dollars or 2 cents per mile. (average of 10 cents per mile for diesel and average of 8 cents per mile for propane)

The average service life difference is 20 months

106 months for diesel (cost per month is 65000/106 = 613.21 per month)

126 months for propane (cost per month is 83000/126 = 658.73 per month)

Just need something showing how these differences in cost relate to the 8000 extra I must spend, or how long to get that 8000 back

The second regression we know that we need to make up 8000 so that is compared to how long it will take to make up that difference at 5 cents, 10 cents, 15 cents and onward up to 50 cents per mile difference.

If you would like to use months as the dependent variable you can consider the monthly distance at 1200 miles = so for that example the regression would show that at 50 cents difference and 1200 miles per month that is 600 per month and requires 13.33 months to meet the $8000

Thats just a quick example, I just need a the 2 regressions showing a benefit somehow and like I said u can use whatever dependent, independent variable u wish. You can make up any data u wish so long as its reasonable and consistent with the actual values I have provided.

Here is the section of my paper that I need the regression for:

Considering that even using the best current indicators fluctuating fuel prices that change the mean difference between the two fuel sources are likely and unpredictable a multiple regression would be performed. 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 completed regressions and charts should allow me to analyze and discuss the advantages and savings of using propane of diesel fuel for a fleet of delivery trucks.

If any data is missing or there is not enough feel free to just make up data so long as it reasonably fits with the data given and ultimately shows a slight to moderate cost saving advantage using propane vehicles.