Guia Excel

roe sala roees error salaes
14.1 1095 -543.5 557.6 -3.05
10.9 1001 -496.5 507.4 -1.45
23.5 1122 -557 580.5 -7.75
5.9 578 -285 290.9 1.05
13.8 1368 -680 693.8 -2.9
20 1145 -568.5588.5 -6
16.4 1078 -535 551.4 -4.2
16.3 1094 -543 559.3 -4.15
10.5 1237 -614.5 625 -1.25
26.3 833 -412.5 438.8 -9.15
25.9 567 -279.5 305.4 -8.95
26.8 933 -462.5 489.3 -9.4
.regress roe sala

Source SS df MS Number of obs = 12
F( 1, 10) = 0.32
Model 16.6805306 1 16.6805306 Prob > F = 0.5819
Residual 515.066104 1051.5066104 R-squared = 0.0314
Adj R-squared = -0.0655
Total 531.746634 11 48.3406031 Root MSE = 7.1768


roe Coef. Std. Err. t P>t [95% Conf.Interval]

sala -.005069 .0089073 -0.57 0.582 -.0249158 .0147778
_cons 22.62387 9.181983 2.46 0.033 2.165136 43.0826



. codebook


roeroro


type: numeric (float)

range: [5.9,26.8] units: .1
unique values: 12 missing .: 0/12

mean: 17.5333
std. dev: 6.95274

percentiles: 10% 25% 50% 75% 90%10.5 12.35 16.35 24.7 26.3


sala salario


type: numeric (float)

range: [567,1368] units: 1
unique values: 12 missing .: 0/12

mean: 1004.25
std. dev:242.933

percentiles: 10% 25% 50% 75% 90%
578 883 1086 1133.5 1237

. generate roees=4+(-0.5)*sala

. generate error=roe-roees

. generate salaes =4+(-0.5)*roe

.generate error =sala-salaes
error already defined
r(110);

. summarize

Variable Obs Mean Std. Dev. Min Max

roe 12 17.53333 6.952741 5.9 26.8
sala12 1004.25 242.9333 567 1368
roees 12 -498.125 121.4666 -680 -279.5
error 12 515.6583 120.4298 290.9 693.8
salaes 12 -4.766667 3.47637 -9.4 1.05

.