Accès libre

Net promoter score, growth, and profitability of transportation companies

   | 29 juin 2018
À propos de cet article

Citez

Analysis of Spearman and Pearson correlation between NPS and selected growth and profit variables

VariablePearson correlation coefficientSpearman correlation coefficient
GRS0.16752526–0.043691115
GRE0.1556350680.150436919
GRNR0.0889371990.025886473
ROA0.325424301*0.316394781*
ROAE0.2063320320.139961991
ROS0.1526751970.249374388*
ROSE0.1860069350.047260248
ROE0.1815697440.364680642*
ROEE0.230083687*0.26248856*

Regression analysis of profitability and NPS

ROAROAEROEROEEROSROSE
NPSConstNPSConstNPSConstNPSConstNPSConstNPSConst
Coefficient0.0015910.0140960.0009620.1021230.0037270.0960280.0074660.3220860.0012430.0041020.0004730.049916
Std. error0.0005370.0321010.000530.031660.0023460.1401260.0036710.2192430.0009360.0558810.000290.017347
t-ratio2.96060.43911.8143.22561.58830.68532.03381.46911.32890.07341.62852.8775
value0.004120.661870.073740.001870.116480.49530.045560.146050.187950.941680.107670.00524
************
Mean dependent variable0.1006380.1544190.2986980.7281280.0717270.07564

Standard dev.

dependent var.

0.1214940.1157930.5099440.8062340.2023550.063182
Sum squared residuals0.9898250.96279518.8602746.170182.9994670.289043
E. of regression0.1156550.1140650.5048450.7898870.2013290.062498
R20.1059010.0425730.0329680.0529390.023310.034599
Adjusted R20.0938190.0296350.01990.040140.0101110.021553
F(1,74)8.7648823.290482.522774.1364251.7660862.652052
p-value (F)0.0041240.0737360.1164770.0455550.187950.107667

Variables used in the study

VariableAcronymDescription
Net promoter scoreNPSThe difference in the proportions of respondents ranked as promoters and detractors. The variable ranges between –100 and 100.
Growth of salesGRSThe difference in sales between this year and previous year divided by the previous year’s sales
Growth of EBITDAGREThe difference between this year’s earnings before interests, tax, depreciation, and amortization (EBITDA) and previous year’s EBITDA divided by previous year’s EBITDA
Growth of net resultGRNRThe difference between the net result and previous year’s net result divided by previous year’s net result
Return on assetsROARatio of the net result to the total of assets
Return on assets 2ROAERatio of the EBITDA to the total of assets
Return on salesROSRatio of the net result to the total of sales
Return on sales 2ROSERatio of the EBITDA to the total of sales
Return on equityROERatio of net result to equity
Return on equity 2ROEERatio of EBITDA to equity

Tests of normal distribution

Test/variableDoornik-HansenShapiro-WilkLillieforsJarque-Bera
NPS8.872980.9433620.1404748.38871
p0.01183740.0020218400.0150805*
GRS1827.370.3330670.28124310441.5
p07.14E–1700
GRE241.860.4808010.3172291578.43
p3.03E–536.03E–1500
GRNR454.9020.2554060.3999273723.99
p1.66E–999.23E–1800
ROA43.50010.8550830.15670762.0592
p3.58E–104.17E–0703.34E–14
ROAE20.67350.9091170.10537439.6753
p3.24E–054.66E–050.04*2.42E–09
ROS1414.120.3272210.3383163256.38
p8.46E–3086.08E–1700.0E+00
ROSE38.65420.8738170.15742823.4112
p4.04E–091.87E–0608.25E–06
ROE56.5920.736520.148641470.91
p5.14E–132.28E–1000
ROEE60.82140.8116310.2120575.4237
p6.21E–141.90E–0804.19E–17

Regression analysis of growth and NPS

GREGRNRGRS
NPSConst.NPSConst.NPSConst.
Coefficient0.020407-0.648510.058843-3,32640,003377-0,00134
Std. error0.0150570.8992390.0766084,575360,0023110,137994
t-ratio1.3553-0.72120.7681-0,7271,4618-0,0097
p-value0.179430.473070.444870,46950,148040,99227
Mean dependent variable0.461319-0.1261680.182342
Standard dev. dependent var.3.25780116.438950.500917
Sum squared residuals776.71420107.6118.29069
S.E. of regression3.23977416.484070.497164
R20.0242220.007910.028065
Adjusted R20.011036-0.0054970.01493
F(1,74)1.8369430.5899942.136756
p-value (F)0.1794320.4448660.148039

Mean values of selected variables used in the study (Part I, companies from 1 to 18)

CompanyNSalesEBITDANRTAENPSGRSGREGRNRROAROAEROSROSEROEROEE
1Poczta Polska35486.3170.20.74410.3130643.2-0.03-0.12-1.69-0.010.120.010.1-0.010.39
2DHL Express31545.3121.288.6519.622264.10.090.060.070.520.710.180.241.21.64
3Raben31469.8115.876.8754.9252.867.7-0.03-0.020.180.310.460.160.240.981.6
4DPD31073.3153.479.41035.731239.90.250.330.310.230.440.220.430.751.46
5FM2880.354.924.6350.3106.758.60.060.30.540.140.320.060.130.451.02
6Jas-Fbg147619.78.1184.259520.04-0.050.030.050.110.020.050.140.34
7DSV1437.311.16.9131.739.464.50.16-0.12-0.220.060.090.020.030.180.29
8GLS3425.799.870.9261.5173.873.20.140.090.090.821.150.510.711.231.73
9XPO2413.439.40.8247.837.73.6-0.02-0.13-0.230.010.320.010.19-0.032.05
10Panalpina3385.421.716.286.117.867.10.080.680.790.570.760.130.172.713.65
11DHL Global Forwarding1383.329.923.8122.745.6500.060.02-0.010.20.250.070.080.530.66
12Link3318.928.39.4136.110.334.90.230.220.460.210.620.090.272.648.18
13Omega Pilzno3286.930.89.3235.659.450.90.07-0.1-0.10.130.420.10.330.893.06
14Hellmann1282.92.91.176.221.885.80.11-0.11-0.090.020.040.010.020.050.14
15GEODIS3282.53.11.675.42.381.10.20.52-0.080.070.130.020.042.445.61
16DHLSupplychain3239.69.74.394.7-22.728.20.240.35-0.420.140.310.060.13-0.62-1.36
17Arvato3229.810.90.8197.118.261.10.31.38-2.630.010.16-0.010.140.051.73
18C.Hartwig1214.75.23.1654.374.5-0.04-1.59-1.210.050.080.020.030.711.2

Mean values of selected variables used in a study (Part II, companies from 19 to 34)

CompanyNSalesEBITDANRTAENPSGRSGREGRNRROAROAEROSROSEROEROEE
19Spedimex3166.23.10.349.310.437.10.040.111.040.020.190.010.060.080.89
20Maszoński3162.627.723.5149.134.895.91.566.3932.710.480.570.460.542.032.4
21Delta Trans1153.715.14.179.336.259.10.01-0.030.270.060.20.030.10.120.42
22Damco1138.74.12.963.832150.03-3.48-30.050.070.030.030.090.13
23Farmada2125.61813.43221.667.60.1410.940.841.130.220.291.251.68
24Fiege1119.117.98.38529.6500.010.180.060.10.220.070.160.280.61
25Diera3117.92.5230.5872.80.042.08-33.790.190.240.050.070.520.68
26ID Logistics3111.82.6-1.336.8-3.546.7-0.02-5.06-0.78-0.120.2-0.040.08-2.086.95
27Uni-Logistics1102.431.722.34.5500.220.540.570.080.140.020.030.370.67
28Seifert289.62.6222.14.826.90.190.290.210.180.240.050.060.831.1
29IFB3552.62133.766.10.190.260.250.470.590.110.141.852.37
30PartnersPol154.21.40.815.77.747.30.028.45-3.280.050.090.020.030.10.19
31Allport353.83.12.614.37.861.60.120.120.220.570.670.150.171.071.26
32DSV351.82.30.327.88.122.40.470.32-0.520.020.230.010.13-0.040.83
33Marathon248.811.85.44513.251.70.160.572.090.230.540.220.480.791.84
34VGL26.60.78.215.513.2640.322.250.961.060.12.520.221.250.11
76564.236.717.5350.7104.554.40.190.47-0.137.6511.745.465.7522.7155.34

Descriptive statistics of selected variables in the period between 2014 and 2016

VariablesMeanSDMedianMinMaxSkewnessKurtosis
NPS54.385524.846258.3000–20.0000100.000–0.77460.4991
GRS0.18230.50090.0943–0.10984.2467.190955.5921
GRE0.46133.25780.1508–16.094119.42181.157722.2057
GRNR–0.126216.43890.0364–101.85898.4515–0.287834.2880
ROA0.10060.12150.0621–0.09730.53351.62423.0076
ROAE0.15440.11580.1369–0.04130.56731.30222.3971
ROS0.071730.20240.0263–0.02601.35735.491530.1281
ROSE0.07560.06320.0598–0.01090.25911.25831.0294
ROE0.29870.50990.3232–2.96891.4221–3.256420.5446
ROEE0.72810.80620.5496–0.67043.49541.77623.3465