Analysis Price Of The Unipacket Petrol

Introduction

The present project is the analysis of the data we collected. The data was collected from four locations – Inner city, Outskirts of city, Suburbs and remote regions. The data regarding the oil prices were collected from equal number of locations. The brands of oils were Shell and Caltex. Data was collected from 224 stations, equally divided amongst the two stations.

The response variable of the study is the price of the unipacket petrol.

The independent variables are the station from which the petrol is being purchased and the location of the petrol station.

Research Question

The research question for the project is: Does location of the station affect the price of petrol?

Research Hypothesis

To answer the above research question three hypothesis were developed.

The hypothesis for the tests

• Hypothesis 1

Null Hypothesis: The station brand has no effect on the price of petrol

Alternate hypothesis: The station brand has an effect on the price of petrol.

• Hypothesis 2

Null Hypothesis: The Location of the station has no effect on the price of petrol

Alternate Hypothesis: The Location of the station has an effect on the price of petrol

• Hypothesis 3

Null Hypothesis: There is no effect of the station brand and the location of the petrol station on the price of petrol

Alternate Hypothesis: The station brand and the location of the petrol station is linked by the price of petrol.

Data Analysis

To answer the above question we used the two factorial ANOVA.

Table 1: Frequency of Station brand and Location of the petrol station

(source created by author)

Table 2: Descriptive statistics of the price of petrol based on the Station brand and Location of the station

(source created by author)

Table 3: Between subject effects of the price of petrol based on the Station brand and Location of the station

(source created by author)

From table 3 we find that there are statistically significant interaction between the station brand of petrol and the location of the petrol station, F(3,216)= 40.393, p = 0.000.

We also find that there are statistically significant differences between the station brand and the price of petrol F(1,216)=6.272, p = 0.013.

In addition, we also find that there are statistically significant differences between the location of the petrol station and the price of the petrol F(3,216) = 8.843, p = 0.000.

From figure 1 and table 2 we find that the price of station brand “S” petrol is the lowest at the outskirts of the city, and the highest at the remote region. The price of station brand “NS” is the highest at the outskirts of the city and the lowest at the inner city location.

Conclusion

From the above analysis we find that the price of unipacket petrol varies with the location and the brand of petrol station.