Regression Analysis

Introduction

Our regression analysis was done on OMNITRANS fuel consumption. This has been an ongoing issue for OMNITRANS where there seems to be an inconsistency with there CNG fuel consumption. There continues to be variance in what is consumed each day compared to the amount of miles driven. This issue is very important to OMNITRANS because it makes it very difficult to plan for future use with the CNG industry. OMNITRANS wants to have a consistency with CNG use so they can plan for budgeting purposes and new contracts that are connected with the CNG usage. We are going to establish what we believe will be a good analysis for OMNITRANS to look at and establish what is needed in order to improve there fuel consumption within the industry. This will give them an overall picture of where there is a correlation between the two factors. In our particular study it is fuel consumed and miles driven.

Data Researched

What we have done is taken 5 days worth of data points from the Fleetwatch system’s reports. Fleetwatch is based for all recording purposes for all of the OMNITRANS facility. This particular report gives full details of how much fuel is consumed on each day based on filling station onsite at the OMNITRANS facility. We took every 5th days worth of data from the first on. That data point days were the 1st, 6th, 11th, 16th and the 21st. Each of these days that was chosen also represented a day where all buses were in full use with little to no difference in there operating schedule. This was established as the best way of getting a good variation of data.

We took the data from both filling stations to come up with our X factor for each days worth of data points. This gave us an assortment of total fuel consumed for each day. That way we are not going to have an exact same number for each day. This represents a better view of the fuel used. Instead of taking an average of all fuel consumed for a month by using the 5 different days we are able to look at a better sample of what is actually happening with fuel consumption.

Fuel Consumed Miles Driven

When X Y

Day1 2904.2 8712.6

Day6 2807.1 8421.3

Day11 4128.3 12384.9

Day16 3489.3 10467.9

Day21 2424.3 7272.9

Coefficient of Determine = 1

Fuel Consumed Miles Driven

2500 7500

3500 10500

Next was the issue of establishing the Y factor. With this we ran into an issue of how many miles for each day. Even though OMNITRANS has set schedules for there buses there seemed to be an issue of establishing a breakdown of each bus bases on the different routes. Some buses drive only10 miles a day while another bus may drive up to 400 in single work day. What we have done is taken the average miles per gallon and multiplied by the amount of fuel consumed in gallons. We found that this is the best way of showing the correlation between the X and Y.

The opportunity for this is that if we can establish a norm of what should be happening with fuel consumption we would have a better way of establishing what is going on with the OMNITRANS buses. Below you will find our regression analysis for the data that was explained between the X and Y.

Interpret Results

By the data above it will show that there is a direct relationship between fuel consumed and miles driven. As fuel consumed is increase it will increase miles driven. In average the buses consume one gallon of gas for every 3 miles. On the other hand some buses may consume more if there is a problem with the engine or change in weather.

From the graph it will show a correlation between fuel consumed and miles driven, with the correlation coefficient being equal to 1. This indicates that the number of fuel consumed in a perfect positive linear with miles driven. Also from the graph all points do not lay exactly on the line, if they did we would predict with 100 percent accuracy.

State the limitations of the analysis

With this analysis there are some limitations such as something interferes with the routine for that day. Such as engine failure, if the engine is starting to fail it will start to work harder when in use and this will lead to less miles per gallon of gas. Miles driven may also change when