The Relationship Between the Car Retail Price and Car Mileage in Dubai Market

Abstract

Correlation and regression analyses were performed to determine the relationship between car retail price and car mileage in the Dubai market. Research data was obtained through random sampling. A questionnaire was given to randomly selected customers in the Dubai car market. MS Excel was used to perform the analyses.

Data Overview

The car retail prices were presented in form of price ranges. The price ranges were coded as follows: 1 – <$3000, 2 – ($3000 to $6000), 3 – ($6001 to $9000), 4 – ($9001 to $12000), 5 – ($12001 to $15000), 6 – ($15001 to $18000), 7 – ($18001 to $21000), 8 – ($21001 to $23000), 9 – ($23001 to $26000), 10 – ($26001 to $29000) and 11 – ($30000 and above). The following mileages were observed: 0, 50000, 100000, 120000, 140000, 150000 and 200000. The car retail prices will be represented by letter X while car mileage will be represented by letter Y.

Measures of Central Tendency and Dispersion

Mean

If there are n values in a data set with values Xi where i = 0, 1, 2, 3, 4ā€¦, n, the mean will be expressed as follows:

FormulaĀ OrĀ Formula

Median

The mean can be located by the following formula after arranging the data in order of magnitude:

Median = Ā½ (n+1) Th figure in a data set. This formula applies to both even and odd data set.

Mode

The most frequent figure in a data set is called the mode. A frequency distribution table showing elements of a data set and the number of times each appears in a data set is used to calculate the mode.

Range

The formula for calculating the range is stated as follows:

Range = Maximum value ā€“ Minimum Value

The standard deviation is a measure of the spread of data around the mean. It is calculated as follows:

Formula

Where

  1. Ļƒ is the standard deviation
  2. n is the total frequency of elements in a data set
  3. xi is the data values
  4. Āµ is the mean of the data set

Measures of central tendency (mean, median, and mode) and measures of dispersion (standard deviation and range) are summarized in table 1.

Table 1. Summary Statistics of the Data
Mileage Price
Mean 109285.7143 Mean 1.871429
Standard Error 25176.24947 Standard Error 0.285118
Median 125000 Median 1.7
Mode #N/A Mode 1.7
Standard Deviation 66610.09505 Standard Deviation 0.754352
Sample Variance 4436904762 Sample Variance 0.569048
Kurtosis -0.032590335 Kurtosis 0.190053
Skewness -0.527057121 Skewness 1.100625
Range 200000 Range 2.1
Minimum 0 Minimum 1.1
Maximum 200000 Maximum 3.2
Sum 765000 Sum 13.1
Count 7 Count 7

As shown in table 1, the mean, as well as the median and most frequent car retail price ranges, are between zero and $3000. The mean car mileage is about 109,285.7143 miles while the median mileage is 125,000 miles. The standard deviation for the car mileage is 66610.09505 while the range (difference between the minimum and maximum value) is 200000. It is not meant to determine the standard deviation or range for the car retail price ranges.

Correlation and Regression

Correlation is a measure that determines the extent to which two variablesā€™ movements are related. It varies from -1(negative perfect correlation) to +1 (positive perfect correlation). The correlation coefficient is computed using the following formula.

Formula

Where r is the correlation coefficient, n is the size of the data, and x and y are the variables.

Correlation analysis produced multiple R-values (correlation coefficient) of about -0.9756. This means that the two variables are highly negatively correlated.

Table 2. Summary Output
Regression Statistics
Multiple R 0.975647
R Square 0.951887
Adjusted R Square 0.942264
Standard Error 0.181258
Observations 7

The coefficient of determination (R-square) value of 0.951887 suggests that the regression model was a perfect fit for the data. In other words, approximately 95.19% of the variations in the car retail prices were accounted for by the car mileage data. The other unexplained part of about 5% is explained by other factors not included in the model.

Table 2. Analysis of Variance (ANOVA)
Df SS MS F Significance F
Regression 1 3.250014 3.250014 98.92201 0.000175
Residual 5 0.164272 0.032854
Total 6 3.414286

Based on the ANOVA test done, the p-value of F-statistic is less than the level of significance which is 0.05. The rule of thumb is that if the p-value of a statistic is less than the level of significance, then the statistics in a model are jointly significant. F-statistic is a test of the overall significance of the regressors in a model.

Regression analysis is preferred to correlation analysis because it determines the impact of all variables in a model individually and jointly. Correlation analysis only shows the relationship between two variables and cannot analyze a model with more than one regressor. The regression model being determined is stated as follows:

Car price = a + b Mileage +Āµ. In this case, a is the intercept of the regression equation. It sums up the effects of the variables not included in the model. The slope of the regression model is b and it measures the effects of car mileage on the car retail price in Dubai. Taking x to represent car mileage and y to represent car rental price, the regression equation can be restated as follows:

Y = a + b x + Āµ

The main aim of conducting regression analysis is to determine the values of parameters a and b. The ordinary least square method (OLS) is used to determine the values of these parameters. The formulas for calculating the parameters by the OLS method are as follows:

b =Ā Ā Formula

a =Ā Formula

The results of the regression analysis are summarized in the table below.

Table 3. Coefficients and Confidence Intervals
Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
Intercept 3.078937 0.139403 22.08663 3.53E-06 2.720591 3.437284
Mileage -1.1E-05 1.11E-06 -9.94595 0.000175 -1.4E-05 -8.2E-06

Form the results above,

b =Ā FormulaĀ = -1.1E-05 and

a =Ā FormulaĀ = 3.078937

The regression equation Y = a + b x, therefore, can be stated as follows

Y = 3.078937 – 1.1E-05 x where y is the rental car price and x is the car mileage.

The results of the analysis of variance, P < 0.001 (table 2) mean that the regression model is significant. The regression model can be represented by the following equation: car retail price = 3.078937 ā€“ 0.000011 car mileage. The model shows that for every unit increase in mileage, the car retail price range decreases by 0.000011. The p-value of the coefficient of the regression model is 0.000175 which is less than the level of significance 0.05. This means that car mileage is an important determinant of car rental prices.

In conclusion, the car retail price and car mileage in the Dubai car market are negatively correlated. The car retail price would be high when the car mileage is low but low when the car mileage is high. The relationship can be represented by the regression equation, car retail price = 3.078937 – 0.000011 car mileage. The coefficient of determination (R-Squared) was close to 100% meaning that car mileage is a strong determinant of car rental price.

NetWork Analysis

The nods in the diagram represent the following:

NetWork Analysis

The chart is presented as follows:

NetWork Analysis

The following formulas were used in calculating ES, EF, LS, and LF

ES = ES of previous activity + Duration of previous activity

EF = ES for the task + Duration of the task

LS = LF for the task + Duration of the task

LF = LF of the following activity ā€“ Duration of the following activity.

Calculations were made possible by the following facts

  1. The first nod in any path has zero ES and LF
  2. The last node in a path has ES = LF
Activity Duration ES EF LS LF Total Float
A 20 0 20 -20 0 -20
B 2 0 2 -2 0 -2
C 10 2 12 0 10 -2
D 1 12 13 10 11 -2
E 6 13 19 11 17 -2
F 30 20 50 17 47 -3
G 6 12 18 37 43 25
H 4 18 22 43 47 25
I 16 0 16 31 47 31
J 3 50 53 47 50 -3
K 2 0 2 -2 0 -2
Total Float = LF – (ES + Duration)
ES: The earliest time an activity can start
EF: The earliest finish time of an activity
LS: The Latest Start time of an event
LF: The latest finish time of an event

All activities with negative total float are considered critical events. They include activities A, B, C, D, E, F, J, and K.

The total float for non-critical activities is as follows:

G 25
H 25
I 31

The critical paths are AFJ and BCDEFJ whose total times are 53 weeks and 52 weeks respectively. This means that production cannot start in 48 weeks.

Cite this paper

Select style

Reference

BusinessEssay. (2022, December 15). The Relationship Between the Car Retail Price and Car Mileage in Dubai Market. https://business-essay.com/the-relationship-between-the-car-retail-price-and-car-mileage-in-dubai-market/

Work Cited

"The Relationship Between the Car Retail Price and Car Mileage in Dubai Market." BusinessEssay, 15 Dec. 2022, business-essay.com/the-relationship-between-the-car-retail-price-and-car-mileage-in-dubai-market/.

References

BusinessEssay. (2022) 'The Relationship Between the Car Retail Price and Car Mileage in Dubai Market'. 15 December.

References

BusinessEssay. 2022. "The Relationship Between the Car Retail Price and Car Mileage in Dubai Market." December 15, 2022. https://business-essay.com/the-relationship-between-the-car-retail-price-and-car-mileage-in-dubai-market/.

1. BusinessEssay. "The Relationship Between the Car Retail Price and Car Mileage in Dubai Market." December 15, 2022. https://business-essay.com/the-relationship-between-the-car-retail-price-and-car-mileage-in-dubai-market/.


Bibliography


BusinessEssay. "The Relationship Between the Car Retail Price and Car Mileage in Dubai Market." December 15, 2022. https://business-essay.com/the-relationship-between-the-car-retail-price-and-car-mileage-in-dubai-market/.