--------------------------------------------------------------------------------------- name: log: C:\Users\IRILab001\Desktop\Outliers.log log type: text opened on: 27 Sep 2019, 18:24:07 . twoway (scatter rdintens sales, sort) . summarize sales, detail firm sales, millions ------------------------------------------------------------- Percentiles Smallest 1% 42 42 5% 93.9 93.9 10% 150 133.6 Obs 31 25% 502.2 150 Sum of Wgt. 31 50% 1212.3 Mean 2638.561 Largest Std. Dev. 3888.587 75% 2830 6754 90% 6754 7621 Variance 1.51e+07 95% 8995 8995 Skewness 3.070315 99% 19773 19773 Kurtosis 13.42303 . display 3797.013+2*7587.992 18972.997 . count if sales>19773 0 . count if sales>18972.997 1 . use "C:\Users\IRILab001\AppData\Local\Microsoft\Windows\Temporary Internet Files\Cont > ent.IE5\0CRDKN2M\RDCHEM.DTA" no; data in memory would be lost r(4); . clear all . *(8 variables, 32 observations pasted into data editor) . twoway (scatter rdintens sales, sort) . summarize sales, detail firm sales, millions ------------------------------------------------------------- Percentiles Smallest 1% 42 42 5% 93.9 93.9 10% 150 133.6 Obs 32 25% 505.95 150 Sum of Wgt. 32 50% 1332.5 Mean 3797.013 Largest Std. Dev. 7587.992 75% 2883.25 7621 90% 7621 8995 Variance 5.76e+07 95% 19773 19773 Skewness 3.752121 99% 39709 39709 Kurtosis 17.39043 . display 3797.013+2*7587.992 18972.997 . count if sales>19773 1 . count if sales>18972.997 2 . reg rdintens sales profmarg if sales<19774 Source | SS df MS Number of obs = 31 -------------+------------------------------ F( 2, 28) = 2.92 Model | 18.7880289 2 9.39401445 Prob > F = 0.0702 Residual | 89.9330615 28 3.21189505 R-squared = 0.1728 -------------+------------------------------ Adj R-squared = 0.1137 Total | 108.72109 30 3.62403635 Root MSE = 1.7922 ------------------------------------------------------------------------------ rdintens | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- sales | .0001856 .0000842 2.20 0.036 .0000131 .0003581 profmarg | .0478411 .0444831 1.08 0.291 -.0432784 .1389605 _cons | 2.296851 .5918045 3.88 0.001 1.084594 3.509107 ------------------------------------------------------------------------------ . reg rdintens sales profmarg if sales<18972 Source | SS df MS Number of obs = 30 -------------+------------------------------ F( 2, 27) = 2.26 Model | 14.6779539 2 7.33897694 Prob > F = 0.1236 Residual | 87.6382118 27 3.2458597 R-squared = 0.1435 -------------+------------------------------ Adj R-squared = 0.0800 Total | 102.316166 29 3.52814365 Root MSE = 1.8016 ------------------------------------------------------------------------------ rdintens | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- sales | .0002891 .0001494 1.94 0.063 -.0000174 .0005955 profmarg | .0551504 .0455548 1.21 0.237 -.0383202 .1486211 _cons | 2.04013 .6686955 3.05 0.005 .6680803 3.41218 ------------------------------------------------------------------------------ . reg rdintens sales profmarg Source | SS df MS Number of obs = 32 -------------+------------------------------ F( 2, 29) = 1.19 Model | 8.28423732 2 4.14211866 Prob > F = 0.3173 Residual | 100.549233 29 3.46721493 R-squared = 0.0761 -------------+------------------------------ Adj R-squared = 0.0124 Total | 108.83347 31 3.51075711 Root MSE = 1.862 ------------------------------------------------------------------------------ rdintens | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- sales | .0000534 .0000441 1.21 0.236 -.0000368 .0001435 profmarg | .0446166 .0461805 0.97 0.342 -.0498332 .1390664 _cons | 2.625261 .5855328 4.48 0.000 1.427712 3.82281 ------------------------------------------------------------------------------ . sum Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- rd | 32 153.6812 324.6358 1.7 1428 sales | 32 3797.013 7587.992 42 39709 profits | 32 370.5031 830.9303 -4.3 4154 rdintens | 32 3.26621 1.873701 1.026694 9.421906 profmarg | 32 9.823068 7.241944 -3.218563 27.18747 -------------+-------------------------------------------------------- salessq | 32 7.02e+07 2.84e+08 1764 1.58e+09 lsales | 32 7.164942 1.537853 3.73767 10.58933 lrd | 32 3.602825 1.734352 .5306283 7.26403 . log close name: log: C:\Users\IRILab001\Desktop\Outliers.log log type: text closed on: 27 Sep 2019, 18:28:32 ---------------------------------------------------------------------------------------