EX1

X = 8.2 0.539827837
X = 7.8 0.460172163

7.97%

POPULATION MEAN
EX2

A)
STD DEV 5
SAMPLE 49 9.8
Z 1.96 1.4

B) SM 24.8 26.2
Z 1.96 23.4

[23.4 ; 26.2]

C) STD DEV 5
SM 49.8 12.85
Z 2.57 1.82

51.62
47.98

[47,98; 51,62]
UNKNOWN POPULATION MEAN
EX3

SAMPLE MEA 50
STD DEV 8 2.06
CONF INT 95% 0.05 T INV 2T = CI - 1; N - 1
N 25 46.7 LOWER calcular o t quando não tiver a
53.3 UPPER para detrrmiar o intervalo ness

[46,7 ; 53,3] SAMPLE MEAN -+T*SAMPLE ST

POPULATION PROPORTION
EX4

SAMPLE 400
CONF INT 95% 0.053 SAMPLE PROP-+ZSCORE*SQRT
X CAND 32 0.107

SAM PROPT. 0.08 [0,053 ; 0,107]

DETERMINING SAMPLE SIZE

EX5

MARG ERROR 0.05

CONF INT 95% 384.16 ZSCORE^2*SAMPLE PROP(1-SA
PROP 0.5

EX6
7 3.2 1.4 5.4
SAMPLE 25 2.5 2.5 1.9 5.4
SAMPLE MEA 3.348 1 2.1 8.5 4.3
STD DEV 2.240914099 1.5 1.2 2.7 3.8
CI 95% 2.063898562 1.2 2.6 4 2.6

MARGIN OF ERROR

SAMPLE MEAN -+ ZSCORE*VARIANCE/SQRTSAMPLE

NV 2T = CI - 1; N - 1
cular o t quando não tiver a population mean
a detrrmiar o intervalo nesse caso, precisa calcular upper and lower limit

MPLE MEAN -+T*SAMPLE ST DEV/(SAMPLE^0,5)

MPLE PROP-+ZSCORE*SQRT SAMPLE PROP(1-SAMPLE PROP)/SAMPLE SIZE

CORE^2*SAMPLE PROP(1-SAMPLE PROP)/MARGIN OF ERROR^2

8.5
1.6
6.2
2
0.6
EX2
SAMPLES 15
SAMPLE MEAN 50.5 MOE 40.38
POP VARIANCE 400 20 10.12139648 60.62
CI 95% 1.96
[40,38 ; 60,62 ]

EX3
The intervak built contains the population mean with 95% confidence

EX4
With a confidence the mean monthly number of complaints is in between the interval

EX5

7 3.2 1.4 5.4 8.5

2.5 2.5 1.9 5.4 1.6
1 2.1 8.5 4.3 6.2
1.5 1.2 2.7 3.8 2
1.2 2.6 4 2.6 0.6

CONF INTER 95% 1.96

SAMPLE MEAN 3.348
STD DEV 2.287
SAMPLE 25 LOWER LIM 2.403921871
MOE 0.896552363 UPER LIM 4.292078129
T 2.063898562

EX6
SAMPLE 100
SAMPLE MEAN 25.4 CI=M + Z*STD DEV/SQRT N
STD DEV 2 0,4 = Z*2/SQRT100
CONF LEVEL ? 25,80 = 25,4 + E 0.2
CONF INT [25,00 ; 25,80] 0.4 E 2

EX7
SAMPLE 65 90% 95%
SAMPLE MEAN 19.5 1.669013025 1.997729654
STD DEV 5.2
CI 90% 1.64 18.42351894 18.21150309
95% 1.96 20.57648106 20.78849691
POP MEAN

EX8
MOE 2 90% 95%
STD DEV 22.5
CI 90% 1.64 340.4025 486.2025
95% 1.96
99% 2.57

EX9 90% 95%

SAMPLE 340
X 102 0.341 + 0.349
PROP 0.3 0.259 - 0.251
CI 90% 1.64
95% 1.96 [0,259 ; 0,341] [0,251 ; 0,349]
99% 2.57

EX10
a) b)
MOE 0.05
CI 90% 1.645 271 0.351990001
SAMPLE 400 0.448009999
IN FAVOR 160
PROPORTION 0.4
CI 95% 1.96

EX11
b) c)
SAMPLE 611
ANSWER 281 0.0332 0.4267
PROPORTION 0.4599 0.4931
CI 90% 1.645

EX12
a) b)
SAMPLE 400
CI 95% 1.96 0.042986156 0.217013844
WOMEN 104 0.302986156
PROPORTION 0.26

EX13
a) SEP
SAMPLE 491
CI 95% 1.96 0.044226781 600.250
P* 0.5
MOE SEP 0.04 OCT NOV
MOE OCT 0.03
MOE NOV 0.02 1067.111 2401
MOE PRE ELEC 0.01

EX14
a) b)
PROPORTION 0.4
AVERAGE 1.68 1024.426667 188.2384
STD DEV 7
MOE 0.03
CI 95% 1.96
MOE 1
= Z*2/SQRT100

CONF LEV Z SCORE

95.44% 2
 99%

835.9326562

99%

+ 0.364 +
- 0.236 -

51 ; 0,349] [0,236 ; 0,364]

-
+

-
+

-
+

PRE ELEC
9604
EX1

CI 90% 1.64
MOE 0.3 747.1111111
SAMPLE ?

EX2
SAMPLE 30
STD DEV 24.733 2.045229642
CI 95% 1.96 88.80754602
MEAN 98.043 107.278454

EX3
SAMPLE 14
SAMPLE MEA 30.57142857 2.160368656
CI 95% 1.96 28.41105991
32.73179723

EX4
MOE 0.03
CI 95% 1.96 1067.111111
P 0.5

EX5
SAMPLE 400
BACK 129 0.284170482
PROPORTION 0.3225 0.360829518
CI 90% 1.64

EX6
SAMPLE 64
MEAN 6.2
STD DEV POP 1
CI 95% 1.96

EX7
POP STD DEV 10
SAMPLE 81 163.3356286 163.1722222
SAMPLE MEA 165 166.6643714 166.8277778
CI 90% 1.645
T 1.664371409

EX8
SAMPLE 1037
CONC 643
PROPORTION 0.620057859 0.59533895
CI 90% 1.64 0.644776769
 HYPHOTESIS TESTING CLASS

EX1
T 70
STD DEV 3.5
SAMPLE 49 -1.8 Zobs
SAMPLE MEAN 69.1 -1.64485363 Critical Value

EX2
HO: M >=200
HÁ: M<200

POP. ST.DEV. PROVIDED - ONE-TAILED

EX3
STD DEV 2
SAMPLE 25 HO: M >=8 Z OBS P value Critical Value
MEAN C. SAM 8 HÁ: M<=7,2 -2 0.022750132 -1.64485363
MEAN C. 7.2 Reject H0
SIG LEVEL 5% 0,02<0,05
0.05

POP. ST.DEV. PROVIDED - TWO-TAILED

EX4
HO M=6 ZOBS P value
HA M DIF 6 1.4 0.919243341
SAMPLE 49 -0.08075666
SAMPLE MEAN 6.2 0.161513318
STD DEV 1
SIG LEVEL 5% Do not reject H0
CRIT VALUE -1.645 0,161>0,05

UNKNOWN POP. VARIANCE - USE T

EX5 TWO TAILED
H0: M = 36800 TOBS P value
HA M DIF 36800 1.912132318 0.067384218
SAMPLE 26 Do nor reject H0
SAMPLE MEAN 37250 0,067 > 0,05
SAMPLE ST. D 1200
SIG LEVEL 5%
CRITICAL -1.645
 the second happens when HA is > than H0
P VALUE USING Z - ONE TAILED: NORM.S.DIST OR 1-NORM.S.DIST
P VALUE USING Z - TWO TAILED 2*NORM.S.DIST
in the two tailed case you subtract the value for -1 and then multiplies for 2

ZOBS: (SAMPLE MEAN-POP MEAN)/(ST DEV/SQRT(SAMPLE))

P VALUE USING T - ONE TAILED: T.DIST.RT

P VALUE USING T - TWO TAILED: 2*T.DIST.RT
multiplies for 2
EX1

P value ? P value
Z> 1.645
0.049984906 Z was >, so I used the 1-norms.dist

P value ? P value
T> 1.645
DOF 1000 0.050142199

The results are similar, because the degres of freedom are a high number

EX2

MEAN 100 ZOBS P value

STD DEV 100
SAMPLE 25 1.0 0.1587
SAMPLE MEAN 120
H0 M = 100
HÁ M > 120 use 1-norm.s.dist for p value

EX3

POP MEAN 30 ZOBS P value

POP STD DEV 3
SAMPLE 16 -2.666666667 0.0038303806
SAMPLE MEN 28
HO M = 30
HÁ M < 30

EX4

MEAN 20 ZOBS P value

STD DEV 6
SAMPLE 36 6 P(z>=6)
SAMPLE MEA 26
H0 M = 20
HÁ M >= 26

EX5

MEAN 10.5 ZOBS P value

VARIANCE 0.04
SAMPLE 100 -15 P(z< -15)
SAMPLE MEA 10.2
H0 M = 10,5 OR M >=10,5
HÁ M < 10,2

EX6

MEAN 38 P VALUE SIG LEVEL

SAMPLE 15 0.0342 < 0.05 reject
HO M < 38 0.0342 > 0.025 do not reject
HÁ M > 38 0.0342 > 0.025 do not reject
P value 0.0342 0.0342 > 0.02 do ot reject
0.0342 > 0.03 do not reject

EX7

SAMPLE 40 ZOBS P value

SAMPLE MEA 2.1
STD DEV 4.8 -2.766992953 0.0028287989
SIG LEVEL 0.05 0,0028 < 0,05 reject H0
H0 M >= 0
HÁ M<0

EX8

MEAN 215 P VALUE SIG LEVEL

P VAL.UE 0.033 0.033 < 0.05 reject
H0 M = 215 0.033 > 0.01 do not reject
HÁ M > 215 0.033 > 0.03 do not reject
0.033 < 0.1 reject

EX9

MEAN POP 2.5 ZOBS P Value

STD DEV 0.5
SAMPLE 49 -2.8 0.0025551303
SAMPLE MEA 2.3 0,0025 < 0,05 reject H0
SIG LEVEL 0.05

H0 M = 2,5 Yes, there is evidence

HÁ M < 2,3
EX10

MEAN POP 500 TOBS P value

SAMPLE 7.0
SAMPLE MEA 551.4 2.398880783 0.0266881074
SIG LEVE 0.1
STD DEV 56.72112229
H0 M = 500
HÁ M > 500

EX11

MEAN 9 TOBS P value

SAMPLE 30
SAMPLE MEA 8.42 -1.443995833 0.0797288645
STD DEV S 2.2 0,079 > 0,05 do not reject H0
SIG LEVEL 0.05
Do not reject, so dont have evidence
H0 M=9
HÁ M<9

EX12

MEAN 8 ZOBS P value

SAMPLE 120
SAMPLE MEA 8.4 1.369306394 0.9145482399
STD DEV 3.2 -0.08545176
SIG LEVEL 0.05 0.1709035202
H0 M=8
HÁ M DIF 8

EX13

MEAN 3530 TOBS P Value

SAMPLE 92
SAMPLE MEA 3740 2.486727457 0.0073579633
STD DEV SAM 810
0,007 < 0,01 reject H0
H0 M = 3530 yes, we have the evidence
HÁ M > 3530
 LAST SEMESTER QUIZ 2

EX1

HO M = 3200 TOBS
HÁ DIF 3200
SAMPLE 36 -1.05
SAMPLE MEAN 3130
STD DEV S 400
POP MEAN 3200

EX2

SAMPLE 380 POP

INGESTED 25
PROP 0.065789474 -1.34279913
SIG LEVEL 0.05

H0 M = 0,085
HÁ M < 0,085

EX3

SAMPLE 88 POP
SATISF 45
PROP 0.511363636 2.132451285
SIG LEVEL 0.05
HO M = 0,4
HÁ M DIF 0,4

EX4

HO M = 3200 TOBS
HÁ M > 3200
SAMPLE ST DEV 31 1.893039883
MEAN SAMP 3370
STD DEV 500
SIG LEVEL 0.05

EX5
MEAN 85
H0 M >= 85
HÁ M < 85

EX6

MEAN 3000 ZOBS

STD DEV 500
SAMPLE 40 2.681611456
SAMPLE MEAN 3212
SIG LEVEL 0.05

H0 M = 3000
HÁ M > 3000

EX7

SAMPLE 49 ZOBS
MEAN 6
MEAN SAMP 6.3 2.1
STD DEV 1
SIG LEVEL 0.05

H0 M=6
HÁ M DIF 6

EX8

MEAN 100 ZOBS

STD DEV 100
SAMPLE 25 1
MEAN SAMP 120

H0 M = 100
HÁ M > 120
ot reject H0

nt have evidence

we have the evidence

 P value

0.849542774
0.150457226
0.300914452 is between 20% and 40%

P value

0.089668512

P value

0.983515117
0.016484883
0.032969765

0,03 < 0,05 rejected

P value

0.034017536

0,03 < 0,05 reject

 P value

0.003663425

P value

0.982135579
0.017864421
0.035728841

0,036 < 0,05 reject

P value

0.158655254
 THINGS TO REMEMBER

Z = (SAMPLE MEAN-POP MEAN)/(STD.DEV/SQRT(SAMPLE))

Z P VALUE ONE TAIL: NORM.S.DIST OR 1-NORM.S.DIST

the second case is used when HA > than H0
Z P VALUE TWO TAILS: 2* NORM.S.DIST
in this case, we subtract 1-the result and multiply the result by 2
P VALUE USING T WHEN HÁ < HO: DIST. T

P VALUE T WHEN HÁ > H0: 1-T.DIST

P VALUE USING T - TWO TAILED: 2*T.DIST.RT

we subtract 1-the result and multiply the result by 2
P VALUE > SIG LEVEL : DO NOT REJECT H0

P VALUE < SIG LEVEL: REJECT H0

EX1

SAMPLE 100 ZOBS P value

MEAN SAMP 6.2
STD DEV 1 2 0.977249868
POP MENA 6 0.022750132
SIG LEV 0.05 0.045500264
H0 M=6
HÁ M DIF 6 0,046 < 0,05 reject

EX2

MEAN POP 20 ZOBS P value

STD DEV 6
SAMPLE 36 6
SAMPLE MEA 26

H0 M = 20
HÁ M >= 26

EX3
MEAN 2000 ZOBS P value
STD DEV 750
SAMLE 25 -1.73333333 0.04151822
MEAN SAM 1740
SIG LEVEL 0.05 0,042 < 0,05 reject

HO M >= 2000
HÁ M < 2000

EX4

SAMPLE 31 TOBS P value

MEAN SAM 3300
S STD DEV 500 1.113552873 0.137156923

H0 M <= 3200
HÁ M > 3200

EX5

SAMPLE 380
INGESTED 25 POP P value
PROP 0.065789474
SIG LEVEL 0.05 -1.34279913 0.089668512

HO M = 0,085 O,085 > 0,05 do not reject

HÁ M < 0,085

EX6

SAMPLE 88 POP P value

SATISF 52
PROP 0.590909091 3.655630775 0.999871725
0.000128275
H0 M = 0,4 0.00025655
HÁ M DIF 0,4
0,0002 < 0,05 reject

EX7

SAMPLE 36 TOBS P value

SAMPLE MEA 3130
S STD DEV 400 -1.05 0.849542774
0.150457226
H0 M = 3200 0.300914452 between 20 and 40%
HÁ M DIF 3200

EX8

H0 M >= 90
HÁ M < 90
ween 20 and 40%
 HYPHOTESIS TESTING TWO POP

EX1
Indiv Weight bef Weight aft Before - After t-Test: Paired Two Sample for Means
1 130 121 9
2 142 123 19
3 126 127 -1 Mean
4 151 135 16 Variance
5 118 109 9 Observations
6 97 94 3 Pearson Correlation
7 104 102 2 Hypothesized Mean Diffe
8 122 115 7 df
123.75 115.75 8 t Stat
17.97 13.55 6.87 P(T<=t) one-tail
t Critical one-tail
P(T<=t) two-tail
t Critical two-tail
Two Sample for Means

Weight bef Weight aft

123.75 115.75
323.07142857 183.6428571
8 8
0.9433801388
0
7
3.2955433635
0.006600707
1.8945786051
0.0132014139
2.3646242516
 CHI SQUARE TESTS

Observed 1 2 3 4 5 6
15 13 17 15 20 20

Expected 1 2 3 4 5 6
16.67 16.67 16.67 16.67 16.67 16.67

0.16730053989 0.8079724055 0.0065326935 0.1673005399 0.6652009598 0.6652009598

XOBS 2.47950809838
Critical 11.0704976935
P 78%

Observed 1 2 3 4 5 6
43 49 56 45 66 41

Expected 1 2 3 4 5 6
50 50 50 50 50 50

0.98 0.02 0.72 0.5 5.12 1.62

XOBS 8.96
Critical 15.5073130559
P 11.07%

Observed 1 2 3 4 total
15 20 10 5 50

Expected 1 2 3 4 total
25 15 5 5 50

4 1.666666667 5 0

XOBS 10.66666667
Critical 0.245098709
P 0.013671894
 CHI SQUARES (2)

Observed Pastel Types (total line*total column)/tota

Generation 1 2 3 total
z 20 32 48 100
x 80 48 72 200
Total 100 80 120 300 Test Statistic
5.333333333
Expected Pastel Types 2.666666667
Generation 1 2 3 total
z 33.333333333 26.66666667 40 100
x 66.666666667 53.33333333 80 200
tOTAL 100 80 120 300

XOBS 12
Critical 5.9914645471
P 0.0024787522

EX. 2

Observed Interest in soccer

Sex 1 2 3 Total
Female 98 212 268 578
Male 262 159 92 513
Total 360 371 360 1091 Test Statistic
45.07956576
Expected Interest in soccer 50.79140158
Sex 1 2 3 Total
Female 190.72410632 196.5517874 190.7241063 578
Male 169.27589368 174.4482126 169.2758937 513
Total 360 371 360 1091

XOBS 165.0
Critical 5.9914645471
P 1.452021E-36
EX.3
Total
300
tal line*total column)/total total

Test Statistic
1.066666667 1.6
0.533333333 0.8

Test Statistic
1.214169951 31.30995792
1.368012148 35.27710658
 INTRODUCTION TO SIMPLE LINEAR REGRESSION

X: Independent variable/ predictable variable/ explanatory variable

Y: Dependent variable/ responde variable (in our example, weight)

ID X: height Y: weight Y^ Error (y - y^) Error^2 SS total

1 186 83 85.09781252 -2.09781252 4.400817384 654.5069444
2 167 70 56.6687202 13.3312798 177.7230212 158.3402778
3 177 80 71.63140037 8.368599631 70.03345978 510.0069444
4 165 50 53.67618416 -3.67618416 13.51433 55.00694444
5 163 50 50.68364813 -0.68364813 0.467374764 55.00694444
6 163 45 50.68364813 -5.68364813 32.30385605 154.1736111
7 168 51 58.16498821 -7.16498821 51.33705611 41.17361111
8 164 46 52.17991615 -6.17991615 38.19136357 130.3402778
9 166 55 55.17245218 -0.17245218 0.029739754 5.840277778
10 161 49 47.69111209 1.308887906 1.71318755 70.84027778
11 160 55 46.19484408 8.805155923 77.53077083 5.840277778
12 170 55 61.15752425 -6.15752425 37.91510487 5.840277778
SUM = 505.1600818 1846.916667
Means 167.5 57.416666667
R^2

Y = B0 + B1Xi + Ei
E(y) = B0 + B1X > Model Equation
ˆy =b0 + bi X

SUMMARY OUTPUT using data analysis

Regression Statistics
Multiple R 0.852340711
R Square 0.726484688
Adjusted R Sq 0.699133156
Standard Error 7.10746079
Observations 12

ANOVA
df SS MS F Significance F
Regression 1 1341.7566778 1341.756678 26.56102438 0.00042911 p value
Residual 10 505.15998887 50.51599889
Total 11 1846.9166667
 Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
Intercept -193.274068 48.685750591 -3.96982825 0.002644077 -301.7526803 -84.7954555
X: height 1.496661102 0.2904029751 5.153738873 0.00042911 0.84960295 2.143719253

EXERCISES
 CORREL b0 = -193.208039 Using solver: change the sum with B0 and b1
0.852340711 b1 = 1.496268017

-1 <= correl <= 1

SS regression
766.2458359
0.559423921 Y: weigh
202.0586542 90
13.99120936 80 f(x) = 1.49666110183639 x − 193.2740
R² = 0.726484687702744
45.33353863 70
45.33353863 60
0.559985139
50
27.42355602
40
5.036498662
94.58641174 30

125.9293022 20
13.99401545 10
1341.05197 0
155 160 165 170

0.726103129

df residual = n - 2
ou seja, somar 2 ao numero do df res pra che

R^2 Ssregression/SST

SST = SSR + SSr

The higher the correl, the higher is the Rˆ2 an

f.dist.rt
Lower 95,0% Upper 95,0%
-301.75268 -84.7954555
0.84960295 2.143719253
nge the sum with B0 and b1

Y: weight

x) = 1.49666110183639 x − 193.274067890929
² = 0.726484687702744

165 170 175 180 185 190

ao numero do df res pra chegar na sampke

egression/SST > Rˆ2 assumes values btween 0 and 1

rrel, the higher is the Rˆ2 and the better the moel fits the data
Regression
Statistics
Multiple R 0.91
R Square 0.82
Adjusted R
0.82
Square
Standard
0.19
Error

Observations 10

ANOVA
Significance
df SS MS F
F
Regression 1 1.36 1.36 36.26666667 0.0003
Residual 8 0.30 0.0375 - -
Total 9 1.66 - - -

Standard
Coefficients t Stat P-value Lower 95% Upper 95%
Error
Intercept 2.27 0.13 17.25 0 1.96 2.57
Distance-city
-0.53 0.09 -6 -0.73 -0.32
center
 EX1

correl = 0,70

49.00% percentage of the variablility of the dependent variable = correlationˆ2

EX2

df ss rˆ2 ss reg/ss total

regression 1 48 41.42%
residual 9 67.9
total 10 115.9 df residual n-2
11
coefficients std error
intercept 11.06 2.04
x -6.45 1.8

EX3

y^= 300 + 7*X 1,000,000

y : sales = ???? In hundreds

x : expenditure in advertising = 10000 in thousands

EX4

x y
26 40 Alpha 5%
12 43 H0 = 0 there is not a linear relationship
17 30 H0 ≠ 0 there is linear relationship
5 12
23 38
12 42 p value = 0,08
34 50 0,08 > 0,05 do not reject

SUMMARY OUTPUT

Regression Statistics
Multiple R 0.6906743206
R Square 0.4770310171 47.70%
Adjusted R Squar 0.3724372205
Standard Error 9.765227009
Observations 7

ANOVA
df SS MS F Significance F
Regression 1 434.91599303 434.915993 4.560796459 0.0857935065
Residual 5 476.79829268 95.35965854
Total 6 911.71428571

Coefficients Standard Error t Stat P-value Lower 95%

Intercept 20.548536585 8.3014936688 2.475281847 0.056165085 -0.791132248
x 0.8617073171 0.4034961872 2.13560213 0.085793506 -0.175512653

EX5

X (independent) Y (dependent)
20 10
Y (dependent)
70
12 18
60
16 15 50
6 5 40 f(x) = 1.44925946242458 x − 8.47065277015908
R² = 0.789147464906374
26 20 30
40 60 20
10
28 23
0
34 45 0 5 10 15 20 25 30 35 40 45

ˆy =b0 + bi X
y^= -8,47 +1,45x

EX5

Fin_knowledge Fut_Fin_WB (Y) SUMMARY OUTPUT

5.92 5
4.28 3.8 Regression Statistics
5.74 4 Multiple R 0.121730915
5.15 2.6 R Square 0.014818416
4.95 1.8 Adjusted R Sq 0.01383126
4.69 3 Standard Error0.989778544
4.62 3.8 Observations 1000
4.09 5
3.84 2.6 ANOVA
4.31 1 df SS
4.47 3 Regression 1 14.705916619
6.34 3.8 Residual 998 977.70224338
4.85 1.6 Total 999 992.40816
6.34 1.2
5.11 1.8 Coefficients Standard Error
4.59 1.6 Intercept 2.221119743 0.1925450676
6.34 3.4 Fin_knowledg 0.147265827 0.0380096584
3.41 4.4
4.95 3.2 y = b0 + b1x
4.42 3 2.37
4.72 2.4
5.17 3.6
5.92 3
6.34 4.2
4.71 3
4.95 1
5.3 3
5.74 3
3.41 3
4.31 5
4.23 3.6
3.84 3
3.41 2
5.92 5
4.42 3.8
4.28 2
4.31 1.6
5.15 2.8
4.51 3.8
6.34 2
4.91 5
6.02 1.6
3.41 3.4
5.92 3.6
6.02 3.6
5.22 3
4.9 1.8
4.8 4.4
3.7 1.4
3.96 2.2
5.74 1.8
4.23 1
5.01 3.4
5.09 4.8
3.41 1.8
3.79 3.4
3.41 3
5.92 3.4
5.66 2.4
4.55 2.4
6.02 1.4
3.41 5
4.52 2.6
6.34 3.4
4.38 1.2
6.34 1.2
4.91 2.2
4.09 3.4
4.69 2.4
6.34 2.8
4.68 2.6
4.82 1.2
4.78 1.6
5.3 3.4
4.38 1.6
3.84 2.6
5.66 1.6
4.97 3.6
5.02 3.4
3.95 3.8
5.09 2.4
5.2 2.4
5.5 3.8
4.78 3.4
4.37 1.6
4.47 2.6
4.08 3
4.91 3
4.89 3.2
5.42 1.6
4.44 3
5.66 3.8
5.2 1
4.9 4
6.34 2.8
5.52 3.6
5.52 2.6
6.02 3
4.28 3
5.15 3.4
4.28 3.2
4.52 3.4
4.96 1.4
5.3 3.4
4.31 3
4.71 2
4.49 1.8
6.34 2.8
6.02 3.8
5 3.6
5.92 3.6
5.6 2.6
4.38 3.6
3.84 4
5.66 3.6
5.92 2.6
5.49 3.2
6.34 2.4
4.42 3.6
5.66 2.2
4.89 3.2
5.77 4.4
4.91 3.4
3.84 2.4
5.92 4.8
4.82 3
6.34 3.8
5.3 3.4
5.02 2
4.55 3.4
5.52 3.4
5.21 3
5.21 3.2
3.84 3
3.41 3
4.91 1.8
4.42 2.4
4.91 3.4
4.8 3
5.49 3.2
3.41 3.6
4.59 2.6
5.06 4.4
5.2 2
5.22 4.4
5.44 1.6
5.66 3.2
5.5 2.6
4.31 2.6
3.96 1.6
5.92 4.4
5.05 2.2
6.34 2.8
5.42 4.6
6.02 4
6.02 3.2
5.05 2.6
4.91 3.8
4.57 5
6.34 4.2
6.34 1.2
4.82 2.4
4.55 2.2
4.62 1
6.34 2.6
4.44 3.8
6.34 3.4
6.34 2.6
5.02 1
5.16 2.4
5.17 2.6
5.92 3.2
5.37 1.8
5.52 1.8
3.7 2.4
4.42 3.6
6.34 4
5.09 1.8
5.92 2.2
4.85 4
 5.2 2
3.41 3.8
6.34 2.6
6.02 1.8
5.42 3.4
4.71 2.6
4.49 3
4.68 1.6
4.19 2.6
5.01 4.6
5.21 2
6.34 4.2
5.44 1.8
3.41 2.8
5.92 3.4
5.21 2.6
5.4 3.2
4.55 3.6
6.34 3
3.41 3.8
5.15 3.6
6.02 2.2
4.28 3.8
4.58 2.4
5.27 4.2
5.21 2
3.7 1
5.66 3.4
4.82 1.8
6.34 3.2
5.11 5
4.4 4.2
5.6 3.6
5.77 2.4
5.29 4
4.75 2.2
5.77 2.4
4.75 3.6
3.84 2
5.22 3.2
5.77 1
3.41 3
3.41 4.2
5.42 4.2
3.7 1.6
4.51 3.8
4.55 3.2
6.34 4.2
5.92 4.8
5.02 3.2
6.02 3
6.34 3.8
3.41 4
5.92 4.2
4.38 3
6.02 3.2
3.95 3.4
5.92 4.6
6.34 3.4
5.2 3
4.3 3.8
4.28 3
4.69 4.6
5.66 2.2
3.95 4.2
3.41 2.8
6.02 3.6
3.84 3
6.02 2.6
4.67 3.2
5.61 4
5.49 2.2
4.3 2.2
4.51 2.2
6.02 1.8
3.41 2.6
4.37 1.4
3.41 1.6
4.3 2
4.19 3
5.66 2.4
5.5 4.2
4.69 2.6
3.41 1.6
5.16 4
4.75 2.8
3.41 3
4.19 1
4.77 3.8
5.42 2
5.5 2.6
4.25 1
4.08 4
5.74 3.2
3.41 2.4
4.28 3.2
3.41 4.2
4.5 3.8
5.3 4.8
6.34 4
5.42 4.4
5.92 4
4.18 5
5.6 5
5.92 3.2
5.2 3
4.37 1
5.6 2.2
3.96 3.2
5.52 2.8
6.34 3.6
5.21 2
5.49 5
4.28 3
6.02 3.8
4.52 2.2
4.91 4
4.37 1.8
5.49 2.8
5.44 3.6
4.49 3
4.5 2
4.3 1.2
3.41 1.2
5.37 3
5.92 3.2
4.08 2.2
5.1 4
5.5 2.4
4.31 4.6
3.84 3.4
4.91 2.6
3.7 3.4
3.84 3.2
5.27 3
4.42 4
6.02 2.6
6.02 4
3.41 5
4.95 1.8
5.53 2.8
4.82 1.6
5.05 1.8
6.02 2.8
4.42 3.6
6.34 3
4.91 1.2
3.41 2.4
5.66 3.2
5.52 3
5.18 2.6
5.53 3.8
4.69 3.2
6.02 1
5.29 1.2
4.65 1.6
4.77 2
5.92 2.6
4.89 3
3.41 2.8
3.96 5
4.58 3.2
5.92 3.6
5.49 2.6
4.75 2.8
5.74 2.6
6.34 3.8
5.37 3
5.77 4
6.34 2.8
5.42 3
5.09 3
6.02 4.4
5.18 3.6
5.87 2.6
4.08 5
5.3 2.4
6.34 2.6
4.82 1.2
4.58 2.8
4.42 3.6
5.09 3.2
5.1 4.6
5.38 2.6
4.23 1.6
5.42 4.8
6.34 3.2
5.29 3
5.66 1.8
4.4 3
5.61 2.4
4.52 2.2
6.02 3
5.42 3
6.34 4
3.84 3
3.96 2.4
6.34 2.4
4.68 5
4.15 4
4.68 2.8
4.3 1.8
5.5 3.4
3.41 5
4.69 4
6.34 4.2
5.05 5
5.27 5
4.28 2.4
3.41 3
4.16 3
5.27 2.4
5.08 4
5.44 2.2
4.28 2
5.77 2.6
3.41 3
4.91 2.4
4.42 3
6.02 3.6
5.16 2.8
6.34 2.8
4.78 3.8
5.92 4.8
6.34 2.4
4.8 4.2
5.74 3.4
6.02 3
3.84 2.6
5.42 2
5.53 1
5.74 2.4
3.41 3
5.09 2.6
5.74 2.8
4.64 2.4
5.42 4
4.08 3.8
4.15 1
6.02 2.2
4.31 2.2
4.38 2
5.21 2.6
5 3.8
5.66 2.6
4.59 3.4
3.41 3.4
4.95 3
5.09 3.2
5.01 1.8
4.89 3
6.34 4
4.91 3.8
5.92 1.2
5.02 3.6
5.66 2.8
4.71 1.8
5.01 3.2
5.92 2.4
5.74 4.2
5.21 4.6
3.41 3.2
4.3 1
4.31 1.2
5.92 3.6
5.22 1.8
5.49 2.8
5.11 3.6
3.7 3
5.3 3.2
4.49 4.6
3.84 2.4
5.44 1.8
4.82 3.6
6.02 5
6.34 1.8
3.41 1
3.7 1
4.31 1
5.6 2.4
5.3 4
5.38 2.8
3.41 1.8
5.74 2
4.4 3.2
5.44 4.2
6.02 2.6
4.71 4
5.92 3
5.21 3.4
5.3 3.6
5.66 3
4.69 2.6
3.41 5
5.92 3
4.31 2
5.27 3
6.34 2.2
6.34 2.4
4.72 2.2
4.69 2.2
5.09 3.6
5.92 2.8
5.29 3.6
6.02 1.4
4.55 2.6
4.57 4.8
5.49 1.6
5.5 3.4
5.74 5
5.42 4.6
4.28 1.8
6.02 4
5.38 2.8
5.16 1.8
5.44 5
4.71 3.2
5.01 3
6.34 3.2
5.27 2.4
4.37 2.2
5.92 3.6
5.87 5
5.21 2.8
4.52 2.6
4.25 1.6
3.41 3.4
5.2 3
5.92 4.6
3.41 1
4.65 2.6
5.21 4.4
4.69 2.2
4.28 2.2
4.85 1
5.52 1.2
5.66 1
4.15 1.4
5.77 2.4
4.51 3
6.02 2.6
5.66 3.6
5.92 3.8
4.16 2.4
3.96 2
5.52 1.8
5.09 1.8
4.97 3
4.18 3
4.3 5
4.95 4.2
4.37 2.2
4.42 1.4
6.02 1.4
4.86 2.2
3.41 2.4
5.42 3
4.69 3.4
3.95 2
4.49 1
4.38 4.6
6.34 2.4
5.27 2.8
4.65 4
5.49 1.4
3.96 2.8
5.74 2.4
6.34 2.2
4.31 1.4
6.34 4.2
5.16 3.4
5.52 1.8
4.95 3.2
5.66 2.2
3.84 3
5.3 3.6
4.31 2.6
6.02 3.2
3.41 1.6
4.68 2.6
4.15 3.2
4.71 2.4
4.15 3.2
5.92 2.6
6.34 3.6
4.49 1.4
3.79 2.8
4.69 2.6
4.59 3.8
3.41 2
6.34 4.4
4.51 2
4.72 2
5.22 1
5.5 4.2
5.87 2.8
6.34 3.2
5.52 3.2
4.09 2
4.51 4.2
5.38 2.6
6.34 3.4
4.58 1.4
5.6 2.8
5.3 3
3.84 4
5.77 4.2
5.52 3.8
5.74 2.2
5.01 3.4
4.38 1.8
4.37 2.4
6.34 4.6
4.4 3.4
6.34 4
5.15 3.4
5.92 4
4.42 3.6
6.02 3.8
5.92 5
3.41 4.2
6.34 5
4.08 2.8
4.49 2.2
5.87 1.4
6.02 3.4
3.84 1
5.25 3.2
6.02 3
3.41 1.2
4.78 1.4
4.77 2.6
5.22 2.2
4.88 3.6
5.66 3.8
3.41 3.2
5.21 5
4.69 2.4
4.91 4.2
5 3.6
5.44 2.8
5.09 1.6
6.34 1.4
3.41 1.8
4.42 1.6
4.49 3
5.11 3
3.41 2.8
6.34 4.2
5.92 4.2
4.51 4
5.42 4.4
4.95 3.2
4.49 3.2
4.37 4.6
6.34 3
4.75 1
5.09 2.2
5.02 2.4
5.21 2.4
6.34 4.2
6.34 3
6.34 3.4
4.57 3
4.31 2.8
3.84 3
3.7 2
5.18 1.6
5.61 4.2
3.41 1.4
4.67 2.4
4.31 3.8
4.31 3.6
5.92 4.4
5.2 3.6
3.41 2.2
5.21 3.8
4.6 4.4
5.15 2.8
3.84 3.8
4.58 2.6
6.02 1.4
4.16 3.8
4.55 3.4
6.34 4.2
5.42 3.4
6.34 2.8
6.02 3.6
6.34 4
3.84 1.4
6.02 2.8
4.31 1.2
4.55 4.6
6.34 4
4.15 2
5.21 3.4
4.51 2
5.87 3.2
5.92 3.6
4.49 4.4
4.4 1.8
5.09 3
5.01 4.6
5.92 3.4
3.41 3
4.3 3.4
5.02 2.8
4.16 3.6
4.31 2.4
6.34 4.4
3.84 1.2
4.19 3.2
5.21 3
5.74 3.4
3.79 3.8
5.16 3.8
5.66 2.2
3.41 1
4.8 3.6
6.34 1.8
4.58 3
5.92 3.6
3.41 2.2
4.49 3.2
5.74 4.4
4.37 1
4.91 3
3.95 2.6
4.68 2.2
3.41 4.2
4.38 3.6
6.34 3.6
5.92 2
4.5 3.2
5.92 3.2
6.34 1
4.37 5
5.15 3.6
4.28 1.4
4.72 5
5.5 2.2
5.17 1.4
4.31 4.2
6.02 3.2
5.09 1.8
6.02 2.2
5.52 4
4.71 1
4.75 3.6
5.92 4.4
4.89 2.4
3.96 1.4
4.51 2.2
4.55 2.2
6.34 4
5.09 3.4
4.55 3.8
6.34 2.2
4.08 3.4
4.23 3
6.34 3.6
5.5 5
4.49 4
4.3 3
6.34 2.4
6.34 3
6.02 4
5.77 2.4
4.15 2.2
5.52 4
5.2 5
5.44 1.6
4.88 2
4.82 1
3.41 2.8
6.34 4.2
4.8 3.8
3.84 2
3.96 4
3.84 1.2
3.84 2.2
4.82 2.2
3.95 1.6
4.55 2.8
3.93 3.8
4.89 1.6
3.79 1.6
3.84 3.2
5.18 4.2
3.41 4.2
5.16 2
4.4 1.8
3.96 3.4
5.66 3
5.3 4.4
4.38 2.8
6.02 2.2
4.31 2.6
5.42 4.8
4.19 4
4.37 3.6
4.89 2.8
5.52 3.2
4.28 3
5.77 3.6
3.41 3
4.68 4.2
4.95 2.6
5.08 1.6
4.82 4
5.09 2.6
4.89 2.8
5.09 2.8
4.15 2.2
3.84 2.4
5.74 3.2
4.69 1
4.68 4.4
4.55 3.2
5.92 3.4
5.66 3
6.02 2.6
3.96 3.4
5.1 1.6
5.6 2.8
5.52 2.6
4.89 4.6
6.34 2.4
4.09 2.2
3.96 3.6
5.21 2.4
4.49 2.6
4.49 3
5.66 3.8
4.19 3
4.65 5
6.02 2.2
4.28 3
5.6 2
5.66 1
5.1 2.6
4.08 1.6
6.34 2.2
3.84 3.2
4.49 3
4.51 1.8
5.37 4.2
6.34 3.2
5.22 1.2
4.8 2.4
5.21 4.8
3.41 2
6.34 3
4.91 2.2
4.62 1.6
5.92 3.8
5.09 2.4
5.5 2.8
6.34 2.4
6.02 4
4.38 5
3.41 3
5.3 5
5.1 2
4.49 2.8
5.74 3.2
3.41 3
5.09 3.4
5.3 1
3.84 2.2
4.38 1
6.34 3.4
6.34 5
6.34 3.4
6.34 1.4
5.3 2.4
4.58 2.2
4.28 1.8
3.41 3
5.92 3
5.09 5
4.65 1.6
6.02 3
5.27 2.4
4.47 2.8
4.69 2.6
4.3 3
6.34 3
 5 4
4.58 3.2
5.92 3
6.34 5
5.42 3
6.02 2.4
5.02 3.2
4.19 4.2
3.41 1.4
4.97 4
3.84 2.4
4.59 3.4
3.41 4.2
5.92 3.4
6.02 3.2
4.25 3
4.95 3
5.52 2
6.34 3.2
5.92 3.2
6.02 3.2
4.9 2.2
5.21 4
5.74 2.8
5.3 1
4.95 3
4.18 3.2
5.27 3
5.6 2.6
5.42 3
3.41 3.4
6.34 3.8
3.84 2.8
5.49 3.4
4.52 3
4.18 3.6
4.95 2.2
6.02 2.6
4.57 3.8
4.82 2
4.3 3
4.76 2
6.34 2.2
4.72 2.2
4.91 2.8
3.96 2.4
6.34 5
4.55 3.4
3.79 2.6
3.41 1
5.1 3.6
4.16 3
4.28 3.2
3.41 2.8
4.82 3
4.55 4.8
6.34 3
5.29 1
3.95 3
6.34 3
3.84 4.6
4.78 1.8
5.17 2.6
6.02 3.6
6.02 3
5 4
4.52 4.8
5.3 3.8
4.31 2.4
5.3 2.4
3.41 4
4.09 1.8
3.84 3.2
5.4 5
6.02 4
6.34 2.4
5.21 2.8
5.17 3.8
4.31 2.4
4.38 3.2
4.95 3.8
4.76 5
6.34 3
4.28 3.6
5.92 3
5.53 4.6
 5.5 2.4
5.92 1
4.91 3.8
5.6 2.8
6.34 4.6
4.28 3
4.98 3
3.41 4.2
5.09 3
5.61 1.8
4.28 5
4.82 2.6
5.49 4
5.92 2.4
5.66 2.4
3.84 2.4
3.84 3.4
5.66 1
5.5 1.2
5.21 4.8
4.4 3.2
4.89 1.6
4.77 2.2
4.75 2.2
5.3 3.6
4.69 5
5.66 4.2
4.71 4.2
5.06 1
3.84 3.4
5.15 1.6
5.92 3.4
5.74 3.4
5.3 2.4
5.92 2.4
4.37 2.6
6.34 3.4
5.49 2.8
5.21 2
5.2 3
4.71 3.2
5.3 3
4.75 3.4
4.31 2.8
4.82 1
5.06 2.8
 what is the rˆ2?

what is the sample size?

r relationship

there isnt a linera relationship

 Upper 95% Lower 95,0% Upper 95,0%
41.88820542 -0.79113225 41.88820542
1.898927287 -0.17551265 1.898927287

ent)

47065277015908

5 30 35 40 45
 MS F Significance F
14.70591662 15.01122135 0.000113845
0.979661567

t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0%
11.5355837 5.47923E-29 1.843280114 2.598959371 1.843280114 2.598959371
3.874431745 0.000113845 0.072677808 0.221853847 0.072677808 0.221853847
 X1 X2 X3 Y
1.00 1.00 2.95 24.37 SUMMARY OUTPUT
3.50 3.80 5.95 39.62
3.50 3.60 5.53 35.41 Regression Statistics
3.25 3.60 4.05 32.14 Multiple R 0.8494736507
1.00 4.60 3.77 23.47 R Square 72.16%
3.50 3.60 4.92 32.41 Adjusted R Sq 72.08%
3.00 3.40 6.07 35.14 Standard Erro 3.0477854341
1.25 3.20 5.99 40.44 Observations 1027
3.25 2.60 4.01 27.33
1.50 2.40 4.22 30.79 ANOVA
2.00 2.00 5.72 38.32 df SS
4.25 4.60 5.60 35.89 Regression 3 24631.08593
1.25 1.80 4.39 31.98 Residual 1023 9502.6429617
3.25 3.00 4.95 30.07 Total 1026 34133.728892
2.50 2.20 5.14 32.53
4.25 5.00 2.99 19.50 Coefficients Standard Error
2.25 1.40 5.36 34.01 Intercept 9.202654856 0.5518347683
2.25 3.40 3.93 25.63 X1 0.0226531301 0.1067378505
1.00 2.60 3.73 29.25 X2 -0.166634614 0.1099877783
3.25 2.60 3.86 31.91 X3 4.8799870684 0.0951224582
3.75 2.40 4.68 32.84
2.75 2.60 5.54 36.21
2.25 2.40 5.37 34.36
3.00 3.00 4.15 32.25
2.00 1.60 2.19 15.88
1.00 1.00 4.64 27.71
2.00 3.20 4.49 28.98
3.00 2.40 5.56 44.61
1.75 2.40 6.08 34.56
2.00 2.80 5.60 42.34
3.00 2.80 4.21 27.58
3.00 3.20 4.95 33.93
1.00 1.00 4.56 31.31
2.00 2.00 4.37 30.26
1.00 1.00 5.23 36.22
3.00 1.60 5.21 30.38
2.00 4.20 3.31 27.76
1.75 1.00 5.57 35.11
1.00 1.80 5.67 33.63
2.00 2.20 4.68 30.33
1.00 2.20 5.71 36.56
2.75 2.60 3.79 23.92
4.00 1.00 5.02 30.04
3.50 4.40 4.23 29.01
1.00 2.80 4.60 31.27
1.00 1.40 3.28 30.25
1.50 1.80 6.20 42.07
3.00 1.80 7.58 44.26
1.50 4.20 3.58 19.70
1.00 2.00 5.06 32.12
2.00 2.60 4.24 30.55
1.50 2.80 4.49 28.16
2.25 2.60 4.74 26.22
1.50 1.00 3.45 28.75
2.75 1.60 4.99 36.86
2.50 3.00 6.39 38.63
3.00 3.20 6.28 40.09
2.00 2.00 6.09 40.52
3.50 2.60 5.05 37.41
1.00 2.00 5.22 37.11
3.50 5.00 6.87 43.78
3.25 3.60 4.47 29.53
1.50 1.40 3.79 27.00
2.00 1.40 5.65 33.91
1.75 1.20 6.51 37.25
1.50 1.40 5.59 35.23
1.00 3.20 3.19 21.29
4.50 4.00 6.67 39.35
1.00 1.80 6.38 37.76
1.00 1.20 4.43 30.38
1.00 3.00 5.83 37.06
1.00 1.20 5.98 41.61
2.25 2.40 5.91 37.68
2.00 2.60 6.26 40.14
1.00 1.60 5.40 30.98
2.75 2.20 5.75 38.60
1.00 2.60 5.11 37.85
1.00 3.20 5.03 35.38
3.25 2.00 4.56 31.61
1.00 1.00 6.06 39.20
1.00 2.80 2.71 17.17
1.50 2.80 4.59 32.95
3.00 3.00 5.00 32.87
4.00 4.20 4.73 26.46
2.00 1.80 4.02 33.67
2.50 1.40 5.26 38.69
1.75 2.40 5.82 31.58
2.00 3.20 4.94 35.80
1.00 3.20 5.74 33.65
4.25 3.00 4.77 35.02
2.25 3.00 6.03 33.75
3.25 3.00 3.85 29.70
3.75 1.00 7.24 36.59
3.00 3.00 4.43 32.90
2.00 2.00 3.48 25.84
1.75 1.40 5.56 41.98
2.25 1.00 5.41 41.44
2.25 4.20 5.09 36.45
1.00 1.00 4.12 25.47
1.50 1.00 5.62 38.48
1.75 2.80 3.26 24.88
5.00 2.40 3.66 26.85
2.50 2.80 7.27 43.91
3.50 2.60 5.38 34.67
2.00 3.00 3.84 26.91
2.50 2.80 4.09 28.69
2.75 2.60 5.96 37.65
2.50 1.20 4.12 27.98
3.50 2.80 4.48 31.89
1.00 1.00 5.73 38.09
1.00 1.00 4.69 34.57
1.00 1.60 6.30 39.14
3.00 2.20 4.29 25.72
1.50 1.40 5.10 36.08
1.75 1.60 5.85 36.46
2.75 2.40 3.62 27.25
1.75 2.20 3.74 19.01
3.25 2.20 4.80 30.45
1.75 1.60 4.51 26.67
2.00 2.80 3.80 28.91
4.50 2.40 5.20 33.34
1.50 1.40 4.47 27.84
1.25 2.20 4.74 36.55
1.50 1.40 4.68 30.37
4.00 3.80 4.83 32.32
2.25 1.60 5.17 36.73
1.00 1.60 4.05 26.04
4.00 3.60 5.80 35.22
2.50 3.40 5.47 38.45
2.00 2.20 4.14 25.84
3.00 3.00 4.65 29.33
3.25 1.60 5.18 35.54
2.25 3.00 5.97 38.54
4.25 3.60 7.41 41.84
1.00 3.60 4.17 27.95
3.25 3.00 7.84 45.31
2.00 1.00 3.55 24.33
1.00 1.00 4.97 35.05
1.75 3.00 3.95 29.44
2.25 1.80 5.98 37.77
3.75 3.00 5.79 34.55
2.25 2.20 7.20 44.77
1.00 1.00 5.26 36.46
3.75 2.60 4.73 33.21
4.25 2.60 5.39 38.83
1.00 1.00 6.16 38.70
1.75 2.40 5.52 37.44
1.00 3.40 5.64 31.44
1.00 3.20 4.26 28.56
2.75 2.00 4.54 32.32
2.75 2.20 4.69 30.38
4.50 3.80 4.90 31.46
3.00 2.80 4.79 36.98
1.50 2.00 4.18 33.76
3.00 2.20 5.53 33.54
1.25 1.40 5.58 43.29
4.50 1.80 3.42 25.16
1.50 2.20 4.90 36.70
3.00 3.20 3.47 19.59
3.00 1.00 4.15 28.86
1.00 1.00 5.91 37.70
2.50 3.40 5.03 24.61
4.25 4.60 4.91 33.87
3.00 3.00 5.19 38.69
2.50 2.00 4.23 32.74
3.00 2.20 5.12 38.53
1.00 2.20 5.79 36.35
3.00 3.00 5.50 35.18
3.25 3.40 5.38 35.07
1.00 1.00 4.69 34.80
4.00 2.40 3.56 27.06
2.75 1.40 4.69 32.33
1.00 1.80 6.08 38.92
2.50 3.20 4.76 33.64
1.00 1.60 5.23 32.90
2.50 3.20 7.11 43.08
1.25 2.60 5.69 35.68
3.75 3.80 5.59 34.37
1.25 2.80 3.95 26.10
4.00 4.00 6.01 32.85
2.50 1.60 5.25 37.86
3.00 3.40 6.99 44.74
1.50 2.00 4.40 34.62
4.00 3.40 5.58 37.67
1.50 1.60 4.67 33.20
2.25 2.00 5.24 37.25
1.00 1.60 5.27 38.68
1.75 1.40 4.16 31.18
5.00 5.00 3.12 26.56
3.50 3.00 5.16 36.05
1.00 1.00 6.83 41.57
3.25 3.40 5.04 32.29
3.75 4.80 5.09 39.04
2.75 3.20 5.01 34.10
1.00 1.00 5.29 38.57
2.25 2.20 6.16 36.81
2.00 3.60 6.81 42.42
2.00 1.60 5.49 37.46
3.00 1.80 4.40 31.81
2.25 3.20 5.57 35.82
1.75 4.60 3.11 22.05
1.00 1.00 3.87 30.23
1.75 1.60 3.27 25.78
2.25 1.40 5.88 36.69
1.75 2.40 2.48 20.48
2.50 2.20 5.11 29.51
1.00 1.60 5.26 34.61
3.25 2.20 5.15 31.70
2.50 1.80 5.03 33.72
1.50 2.00 5.18 30.97
2.50 2.20 2.74 20.75
3.00 1.40 6.29 37.14
1.75 2.00 4.75 26.60
3.00 3.40 4.76 30.58
2.00 3.60 5.36 39.01
1.75 1.00 3.87 29.41
1.00 3.40 4.49 32.02
1.00 2.80 5.22 31.01
1.00 1.00 4.81 31.89
2.00 2.20 4.14 29.28
1.25 3.00 5.45 29.71
1.50 1.40 3.91 31.16
3.50 3.80 4.22 25.22
3.25 3.60 5.35 29.27
1.00 3.00 4.39 29.78
1.25 2.00 7.07 45.88
2.75 2.20 4.10 32.06
2.75 3.00 7.00 37.31
2.25 2.60 4.70 33.14
1.75 2.40 5.40 32.36
2.00 3.00 7.06 40.84
1.50 3.20 3.70 28.61
3.00 1.00 5.74 35.92
1.25 2.20 4.66 27.60
1.00 3.00 4.63 28.86
5.00 5.00 5.49 31.12
2.00 2.00 4.15 26.41
1.00 2.00 4.21 32.21
3.00 1.60 5.68 34.22
1.25 2.20 7.16 43.76
2.75 3.20 6.16 41.80
2.00 2.80 4.73 33.03
1.00 1.20 5.97 38.03
3.50 3.40 4.86 36.15
1.00 2.00 6.27 34.31
1.00 5.00 7.49 41.08
3.50 3.40 4.04 26.14
1.50 2.20 3.51 28.30
1.00 2.40 4.51 36.75
3.50 3.20 7.37 46.20
3.00 2.20 4.16 31.55
2.75 2.20 5.98 33.67
1.50 3.20 3.69 25.21
2.75 3.00 3.66 31.66
2.25 1.80 4.44 24.88
1.50 1.20 4.52 32.24
2.50 1.00 4.23 27.25
2.00 1.60 3.78 31.30
4.50 4.20 3.76 30.97
1.00 1.60 3.49 26.30
2.25 3.20 6.54 41.01
3.00 3.00 4.58 26.52
3.50 3.40 5.04 22.74
2.75 2.60 4.26 32.06
3.75 3.00 5.39 34.63
2.00 1.20 4.82 35.18
1.75 1.60 5.15 33.94
1.00 1.40 5.68 38.47
2.50 1.80 5.33 39.17
1.50 1.40 5.63 33.13
2.50 2.60 2.67 18.59
2.75 2.00 6.12 38.09
3.00 3.00 3.79 27.08
1.75 1.20 5.78 41.42
3.75 3.40 4.76 34.20
1.00 1.00 4.05 26.86
1.25 2.40 3.03 24.38
2.75 1.20 5.77 39.66
2.25 2.20 5.07 35.52
2.75 3.00 5.30 36.25
2.50 2.20 4.14 33.06
2.00 2.00 5.61 37.94
2.75 3.20 4.03 24.24
3.00 3.00 4.87 34.46
2.25 1.00 5.56 36.79
3.25 2.20 5.93 39.45
5.00 5.00 5.67 37.47
1.00 3.40 5.46 25.82
1.50 4.60 5.13 36.23
1.25 1.00 3.88 29.26
1.75 3.00 5.73 39.04
1.50 1.20 3.96 34.06
2.25 1.40 3.41 23.44
2.75 3.20 5.05 31.25
1.50 1.00 4.85 34.04
3.75 3.60 5.94 37.09
1.50 2.20 3.03 21.25
1.25 3.00 4.52 31.52
1.00 1.00 4.43 34.45
1.00 1.00 5.86 34.97
1.00 1.00 4.76 30.06
1.00 1.00 4.95 29.57
3.25 3.20 4.88 26.88
2.00 3.20 4.17 23.95
1.25 1.60 4.19 24.06
2.00 2.60 4.32 29.86
2.50 1.80 6.16 40.24
4.00 2.80 4.89 30.70
1.00 1.40 5.28 34.37
2.00 3.40 4.70 30.59
4.00 2.60 5.34 33.34
2.25 2.40 3.12 21.17
3.00 3.00 4.88 37.40
2.00 1.60 3.78 23.93
1.75 2.20 5.92 32.80
2.00 2.60 5.11 37.34
2.00 2.60 4.80 30.59
5.00 2.60 6.26 41.48
5.00 2.20 3.28 28.39
3.00 3.00 4.20 31.90
1.75 3.20 2.35 22.25
1.00 3.00 4.65 31.61
1.25 1.60 4.08 29.20
1.00 1.80 1.81 44.62
2.25 3.00 5.33 37.26
3.50 3.00 6.45 41.04
3.00 2.00 5.96 35.23
1.50 1.40 4.40 30.66
1.75 2.60 5.60 32.04
3.75 3.60 6.58 41.10
2.25 2.00 4.58 30.02
3.00 4.00 3.58 22.94
1.75 3.20 5.10 34.33
2.00 1.60 5.32 31.69
1.25 1.20 6.37 39.40
3.00 3.00 3.21 30.32
2.25 2.00 3.62 24.17
1.50 1.00 5.81 37.52
1.75 2.20 4.40 35.95
3.00 1.80 6.05 39.14
1.50 2.00 5.87 37.24
2.75 1.00 5.47 36.57
1.00 1.00 2.98 22.45
3.00 1.40 6.49 41.38
2.00 2.40 4.36 31.70
3.00 2.80 4.39 29.27
1.25 2.80 4.31 31.78
1.00 2.60 4.19 29.12
1.00 1.80 5.36 36.55
3.50 4.20 4.52 34.87
1.00 2.00 4.44 34.93
1.25 2.20 3.44 23.47
5.00 4.80 5.81 40.92
2.00 2.60 3.63 25.22
1.00 2.40 5.14 37.51
2.00 1.00 4.42 27.15
3.25 2.00 4.96 32.53
1.00 3.20 4.43 34.07
2.50 2.60 5.49 40.95
1.00 3.40 3.63 27.95
1.25 1.40 4.12 33.67
2.00 2.20 4.70 29.74
1.50 3.60 6.61 37.32
1.75 2.20 5.07 26.12
3.25 3.80 4.72 35.45
1.00 1.80 5.34 33.83
3.25 2.00 5.30 37.48
1.75 1.40 4.41 23.21
2.00 3.40 5.43 43.97
1.50 4.40 3.66 27.84
1.50 3.20 3.84 33.09
1.50 2.40 4.36 31.48
3.50 3.00 4.63 31.42
4.25 4.00 5.27 33.84
2.75 1.80 4.33 34.61
4.25 3.20 5.87 36.28
1.00 2.40 5.64 42.68
2.75 1.00 1.93 15.37
2.00 3.00 4.26 30.89
2.75 2.60 3.52 24.12
2.50 1.80 5.11 33.72
1.25 4.20 5.28 39.18
2.25 2.80 3.52 27.08
3.50 3.40 4.96 35.61
4.00 3.60 5.37 32.15
1.00 1.80 5.78 37.76
1.25 2.00 4.53 32.00
1.00 2.60 5.05 37.48
1.00 1.40 4.30 29.34
2.00 3.00 5.05 29.39
1.50 1.60 3.83 28.62
1.00 1.20 4.06 28.31
3.50 3.80 4.38 28.29
3.25 4.00 7.10 51.41
1.00 1.20 5.34 38.18
2.25 2.40 5.33 39.58
2.00 2.00 4.15 31.76
1.00 2.00 6.32 35.06
2.00 2.00 4.22 30.05
1.75 3.20 5.36 32.63
2.75 3.20 5.12 31.82
2.25 3.00 5.91 34.74
1.00 1.80 3.36 23.51
2.75 1.60 7.05 45.93
3.50 2.00 6.44 35.62
3.50 2.40 6.16 40.38
3.00 3.00 4.18 26.11
1.75 2.40 4.16 27.02
2.00 2.00 5.46 37.07
2.25 1.80 5.29 34.56
2.50 3.60 5.52 37.30
3.00 2.00 4.82 25.69
3.75 4.20 7.13 41.64
2.50 2.60 5.53 36.74
1.25 3.00 5.92 44.78
2.00 2.40 4.05 26.02
3.00 3.00 5.40 36.57
2.75 3.60 4.34 27.01
2.25 2.60 5.55 34.21
1.00 4.20 2.43 20.14
3.25 2.20 4.35 29.90
2.25 2.60 5.07 30.19
1.00 1.80 4.22 30.58
1.00 1.80 6.65 42.68
1.75 1.00 4.76 32.24
4.00 2.20 4.42 29.93
2.50 1.00 4.98 34.25
3.00 3.00 5.70 41.35
1.25 1.80 6.77 42.53
3.25 3.40 4.90 33.10
2.00 5.00 5.09 28.00
1.50 2.20 7.09 47.42
1.00 1.40 5.46 33.50
1.00 1.00 3.76 28.34
4.00 5.00 4.76 27.18
2.25 1.40 4.02 25.35
3.75 3.40 5.27 31.96
4.50 4.40 3.54 24.98
3.75 3.80 4.37 30.08
2.75 3.40 4.40 28.82
2.00 3.00 3.19 27.50
1.50 3.40 5.01 34.98
2.00 1.80 4.59 27.14
2.25 2.40 4.25 34.19
1.00 1.80 6.37 36.62
1.00 2.80 5.93 40.14
1.25 1.60 5.55 36.71
3.75 3.20 3.36 24.03
3.50 3.80 5.11 34.48
1.75 2.00 6.27 40.44
2.50 1.20 5.53 35.75
1.25 1.40 7.10 44.17
2.00 4.00 3.04 18.43
2.25 1.20 6.21 45.65
3.25 1.60 4.54 29.70
1.50 1.20 6.06 39.73
2.00 2.00 4.99 32.51
3.00 1.40 6.44 43.73
2.00 3.20 4.97 28.08
3.00 1.00 3.97 30.12
1.25 3.00 4.90 31.80
2.00 1.80 5.42 33.87
1.50 3.40 4.56 29.87
3.25 3.40 6.35 42.73
1.00 4.20 4.84 29.86
1.00 4.20 3.54 25.64
2.25 1.40 6.54 42.33
2.50 2.00 5.08 32.62
1.00 1.60 4.68 32.52
5.00 5.00 3.78 27.55
3.50 3.80 4.64 29.76
2.50 2.80 5.54 40.56
1.00 2.40 3.91 31.08
2.75 2.60 6.46 42.07
2.25 4.00 5.27 35.51
1.25 2.20 4.83 29.94
3.75 2.20 4.17 32.58
1.00 2.00 4.25 27.87
1.50 2.20 4.76 28.48
2.25 3.00 5.75 38.11
2.00 3.40 4.85 31.80
1.00 1.40 6.34 44.79
4.00 3.80 4.56 30.52
2.75 3.20 3.48 23.60
1.50 2.00 5.60 33.86
2.25 2.40 5.82 38.18
2.00 2.00 6.21 48.30
3.50 3.40 5.57 38.30
2.25 5.00 3.73 29.14
1.50 1.20 6.10 33.98
1.00 2.60 7.28 48.75
3.00 3.00 6.11 43.62
1.00 1.80 6.61 42.37
2.00 3.60 5.27 34.85
3.00 3.00 3.66 28.00
1.00 1.80 3.32 27.56
1.00 2.80 7.82 47.68
1.00 1.80 3.21 23.63
1.00 2.20 3.87 23.76
4.25 3.60 5.14 31.48
2.00 1.80 4.87 35.42
1.25 3.40 6.26 35.99
2.00 2.60 3.75 29.18
1.25 1.60 3.72 28.23
2.00 4.20 5.30 24.89
1.25 1.20 4.59 30.07
1.00 2.60 5.82 36.02
4.25 1.80 5.13 36.77
3.00 3.40 5.79 41.69
2.00 1.40 3.80 22.44
2.00 2.00 6.19 36.56
4.00 4.20 4.44 30.97
1.00 1.00 5.69 38.60
1.75 2.60 3.97 29.76
3.00 3.00 5.89 39.94
2.00 3.20 4.61 33.74
1.50 2.20 5.28 36.10
2.00 3.00 5.15 29.63
1.50 2.80 4.15 31.20
1.75 2.00 6.48 43.36
4.25 4.80 3.80 27.77
1.75 1.20 3.34 23.39
1.00 2.00 5.22 34.84
3.25 1.40 4.27 32.52
3.00 3.40 4.35 32.05
3.00 3.60 4.58 32.95
1.00 2.40 4.41 25.23
2.75 2.40 5.58 32.02
2.25 3.60 4.90 31.82
3.00 1.60 6.14 40.88
1.75 2.00 5.26 34.88
3.00 4.00 4.37 35.63
3.00 4.20 5.06 36.72
1.50 3.80 5.94 35.17
2.50 1.00 3.10 17.18
2.75 2.40 6.23 39.23
2.50 1.80 4.56 34.14
1.25 1.60 5.06 32.07
1.50 3.20 5.31 37.02
2.25 3.80 5.77 36.74
3.50 3.40 6.23 38.86
1.75 1.40 6.10 46.74
4.50 3.40 4.41 28.08
1.50 1.00 4.95 41.39
1.75 1.80 4.83 29.36
2.00 1.80 5.09 27.06
2.00 1.80 4.55 30.48
1.25 1.80 3.46 25.61
1.00 1.80 6.45 43.88
1.00 1.00 5.33 34.30
1.50 2.80 5.19 35.83
2.75 3.60 7.05 45.71
1.50 1.40 3.20 27.63
2.25 1.40 3.97 27.71
2.50 4.00 4.88 33.94
1.75 2.40 5.25 34.50
3.00 3.00 4.70 32.18
2.75 1.80 5.59 35.19
2.00 3.20 2.99 21.36
2.00 2.40 4.98 29.51
1.25 2.40 5.09 28.12
1.50 1.00 6.84 40.52
2.00 3.00 6.28 41.42
2.00 2.20 5.76 40.36
2.00 2.80 7.19 43.46
1.50 2.20 3.76 29.14
4.00 4.60 5.16 29.74
1.00 1.00 5.18 34.31
1.75 3.60 3.81 24.50
1.00 2.00 5.64 38.46
1.50 1.20 4.89 35.29
4.50 2.00 5.03 33.72
2.25 4.00 5.70 33.68
2.50 3.00 5.55 31.84
1.75 1.80 5.27 35.67
3.50 2.80 6.41 34.95
1.25 1.40 4.59 32.43
1.25 1.20 5.61 36.12
1.50 3.80 4.12 32.22
3.50 3.40 3.10 23.71
2.00 3.80 5.10 36.70
3.00 3.40 5.62 38.30
3.25 2.00 5.74 39.25
3.00 4.00 5.76 34.10
3.00 3.00 4.96 27.91
2.00 3.00 3.77 31.04
1.75 1.60 5.88 37.28
1.50 3.00 4.68 34.67
1.50 2.80 4.53 32.39
1.00 1.40 5.17 37.17
2.00 2.00 7.15 42.42
3.25 3.80 6.01 40.07
2.50 2.80 3.47 26.04
1.25 2.20 5.17 34.97
3.00 4.00 3.35 27.09
1.00 2.60 7.24 47.40
4.25 4.00 4.23 34.19
2.00 2.40 3.26 18.36
1.00 1.00 5.48 39.09
1.25 1.40 5.07 30.92
2.00 1.80 4.00 30.37
2.75 2.20 3.81 24.33
1.50 1.40 4.90 35.65
1.25 1.20 5.94 38.23
1.75 2.60 5.53 35.77
3.00 2.60 4.44 28.70
1.00 2.60 5.54 37.40
3.50 2.20 5.13 30.29
3.00 2.60 5.59 34.26
1.25 1.00 4.50 28.02
1.00 1.00 5.03 35.80
1.00 1.60 5.27 35.55
3.75 3.60 6.00 36.84
1.00 3.40 5.05 29.99
1.00 1.60 4.82 36.21
2.00 4.20 5.26 33.55
3.25 2.80 4.50 30.77
2.25 1.00 5.31 35.29
1.25 2.80 3.42 24.21
2.00 1.80 3.99 28.70
2.00 1.20 5.59 35.88
2.75 2.00 5.36 36.78
3.25 1.80 5.98 41.92
2.25 2.00 3.58 29.50
1.25 1.20 5.26 31.61
1.75 1.20 6.86 41.36
1.00 3.40 3.95 24.53
2.50 1.80 4.54 32.03
2.50 1.80 6.39 39.26
2.25 1.40 6.36 35.33
2.75 2.20 3.06 21.05
2.50 1.60 6.42 38.78
3.00 2.20 5.25 36.03
2.75 2.40 5.45 38.27
3.00 2.60 4.98 33.40
1.00 2.00 4.00 26.74
3.00 2.80 5.40 35.59
4.00 1.20 4.67 32.47
1.00 1.00 3.24 24.90
1.00 2.20 4.35 33.92
3.75 1.60 5.10 29.44
1.00 3.00 4.25 33.58
1.25 1.40 4.28 29.90
3.00 4.20 3.85 27.31
3.00 2.80 3.65 27.35
4.50 2.80 6.23 41.90
2.25 4.00 4.89 35.86
1.50 2.00 5.70 35.66
1.50 3.00 3.62 29.95
2.50 1.00 5.53 38.88
1.50 2.60 5.05 32.06
1.00 1.60 4.56 26.52
2.00 1.40 5.16 35.21
3.25 4.00 3.82 27.54
3.00 3.00 3.81 27.91
3.00 2.00 3.47 30.97
1.75 1.00 5.87 32.16
1.50 1.40 4.72 29.84
1.00 2.60 4.60 33.15
4.50 4.00 5.13 36.51
1.00 1.60 5.96 38.20
4.00 3.20 4.92 28.32
3.00 2.20 5.09 37.12
1.50 1.80 5.16 37.86
2.00 1.20 4.44 27.08
3.00 4.00 6.56 39.97
1.00 3.20 3.89 23.99
2.25 2.40 4.29 32.10
3.00 3.40 7.13 48.79
1.25 1.80 4.48 27.99
3.00 2.60 5.66 35.49
3.50 3.00 6.47 39.58
3.25 2.60 4.34 30.15
2.25 2.20 4.35 32.59
3.75 2.00 4.58 31.66
3.50 2.80 5.13 33.41
1.00 2.60 5.39 38.04
4.50 4.40 3.87 31.63
1.00 2.20 3.78 26.03
3.00 3.80 6.17 37.22
1.50 2.00 6.30 44.16
2.75 2.80 4.13 30.62
1.00 1.80 3.77 29.24
5.00 4.00 6.11 39.65
1.75 1.40 6.37 43.65
1.75 1.40 3.89 30.04
1.75 1.00 5.30 38.89
1.25 2.80 6.28 40.20
1.25 1.00 6.90 43.16
3.00 4.60 6.00 34.56
3.75 2.20 5.58 40.94
1.25 1.80 4.89 33.29
2.00 1.00 3.41 26.18
2.00 4.00 4.60 29.12
1.75 2.00 6.16 39.24
2.25 1.00 4.01 25.91
1.50 2.20 5.62 36.05
2.50 1.00 3.72 23.42
1.25 1.80 4.82 25.17
2.00 1.00 5.20 34.85
1.75 1.20 4.60 29.09
2.50 2.60 4.74 26.23
3.50 2.20 6.11 33.94
2.00 2.00 6.04 40.75
2.25 1.40 6.37 36.01
1.00 1.80 5.87 38.61
1.50 2.20 5.22 28.50
1.00 1.40 4.38 32.25
1.50 2.20 6.25 39.76
2.50 2.60 4.86 33.46
2.50 1.60 2.56 26.85
1.50 3.00 4.46 30.94
2.00 2.40 5.17 34.46
2.00 2.20 3.59 27.56
1.00 3.20 4.83 30.93
1.50 2.20 5.24 31.68
1.50 1.40 4.86 31.54
3.00 3.40 5.64 33.45
2.00 1.80 5.98 37.51
1.50 1.20 5.50 36.58
2.50 1.60 4.15 29.20
2.25 1.60 4.37 29.58
2.25 2.60 5.94 37.53
1.50 1.00 6.09 35.42
1.75 1.40 3.74 29.01
1.25 2.60 3.74 29.63
1.00 1.60 3.61 27.45
1.00 2.60 4.60 34.34
3.50 3.60 6.56 36.14
2.75 1.80 4.87 34.99
1.75 2.60 2.72 19.93
4.00 3.20 6.06 33.90
2.00 2.20 5.08 32.60
2.00 2.80 5.75 35.15
3.00 3.00 5.20 35.05
3.00 3.00 3.21 25.26
2.25 2.60 5.58 35.80
3.50 3.20 5.94 39.46
2.50 1.60 5.88 35.76
1.25 3.80 4.35 29.14
5.00 5.00 3.26 21.97
2.75 2.60 3.54 24.11
2.25 2.20 4.61 28.80
3.25 2.40 7.29 50.40
4.25 3.00 5.31 37.38
3.25 2.00 5.38 38.18
3.00 2.80 5.04 31.02
3.00 3.00 5.91 38.43
3.00 2.40 5.28 29.82
1.00 2.40 5.16 31.78
2.25 1.80 4.61 30.30
2.25 3.00 3.91 25.20
3.75 3.00 4.63 30.84
1.25 1.00 6.07 37.20
2.50 1.60 6.19 37.96
1.00 1.60 5.83 35.34
4.00 1.40 6.25 39.90
3.00 3.00 5.22 29.54
1.00 1.00 5.42 38.21
1.50 2.80 6.33 41.50
1.25 2.80 4.94 34.14
1.00 1.80 6.08 40.53
1.00 3.20 5.94 34.72
1.50 3.80 4.90 32.10
3.00 3.00 4.66 27.70
2.75 3.60 5.12 28.41
3.75 3.40 4.59 33.37
3.75 4.00 6.00 40.59
3.25 3.40 7.06 41.67
2.00 2.40 5.23 36.25
1.00 1.80 3.91 24.84
2.25 2.60 5.43 31.47
1.25 1.60 5.62 38.02
2.75 3.60 4.34 26.46
3.00 3.00 5.10 33.60
1.00 2.20 6.54 40.66
1.75 1.00 5.63 41.20
1.50 1.00 5.59 37.66
1.00 1.40 6.63 34.71
2.25 2.80 5.03 32.15
2.25 1.40 6.66 40.08
1.00 1.60 3.84 28.93
2.50 2.60 5.50 32.53
3.00 3.00 4.75 34.58
2.00 2.60 3.56 24.20
3.00 3.40 3.77 25.53
3.75 1.60 3.98 25.58
2.00 1.00 5.41 36.26
2.50 3.20 4.61 30.18
4.00 3.80 5.91 35.72
4.00 3.80 4.37 28.36
1.25 1.40 5.72 40.76
2.50 2.80 4.67 27.84
1.00 4.20 2.24 21.37
2.00 1.00 5.92 37.69
1.75 1.40 5.98 39.82
2.25 2.00 5.64 38.75
3.25 3.40 7.00 42.71
1.00 1.00 4.69 30.10
2.50 2.20 4.54 29.06
3.25 1.00 5.17 37.21
3.75 2.80 6.66 37.74
3.00 3.00 5.40 39.69
2.25 1.00 3.25 23.66
1.50 2.20 5.03 34.68
1.25 1.80 3.63 25.74
1.00 3.80 3.95 25.07
2.75 3.80 6.05 37.80
3.00 5.00 4.56 29.63
1.75 1.00 4.69 30.00
2.00 3.80 4.73 32.79
3.00 3.20 4.11 33.71
1.50 1.40 4.36 30.19
2.75 3.80 5.93 35.39
2.50 1.00 4.45 33.17
1.50 1.00 4.61 28.94
1.00 2.80 4.40 26.88
2.25 2.80 5.29 34.90
1.50 2.40 3.94 33.14
1.00 2.40 4.34 30.59
1.00 3.60 3.59 22.64
1.25 1.40 4.69 33.17
3.00 2.80 5.83 36.43
3.50 1.00 4.12 32.24
2.50 2.20 3.99 26.79
3.75 1.40 5.21 30.08
2.00 2.00 5.54 35.32
2.00 1.80 3.70 27.01
1.00 1.80 4.77 30.62
2.25 3.80 5.57 41.16
2.25 3.40 4.23 32.54
2.25 1.80 3.59 26.07
2.50 2.40 4.56 24.37
2.25 1.60 3.69 28.46
3.00 3.00 4.94 30.24
1.50 1.40 5.12 34.39
1.75 4.00 6.16 39.42
3.00 3.00 4.53 31.31
1.50 3.00 6.86 41.47
1.75 1.00 5.99 36.69
2.50 2.60 5.91 38.22
3.00 2.00 4.93 31.48
2.50 2.40 4.12 28.70
1.50 1.60 3.35 24.30
1.00 1.40 5.03 32.11
3.00 4.80 3.55 25.81
1.25 1.60 4.53 30.88
1.00 2.00 4.83 31.52
2.50 2.60 5.93 34.91
3.25 1.00 2.72 22.59
2.25 2.20 6.29 45.28
3.75 2.60 5.60 36.06
1.25 3.40 4.92 32.63
1.75 2.40 5.04 35.59
1.00 2.00 4.39 28.36
4.00 3.40 5.09 32.22
1.00 1.40 4.60 30.33
3.50 3.00 5.10 35.88
4.00 3.80 4.44 30.58
4.00 4.00 4.98 33.20
1.00 1.60 3.00 22.91
1.00 1.40 4.94 32.99
1.00 1.60 4.22 33.18
3.50 3.20 4.71 28.67
3.00 1.40 6.92 39.21
3.25 3.00 6.10 44.50
3.75 3.80 3.57 21.36
1.00 2.40 5.88 40.04
1.00 2.40 5.53 33.41
2.25 1.80 4.87 36.49
2.00 2.40 6.29 39.04
2.00 3.80 4.30 22.93
2.50 3.00 3.23 22.49
1.00 4.20 5.90 44.08
3.25 3.00 6.06 37.00
1.00 2.20 4.41 31.70
2.50 1.80 5.21 33.75
4.50 4.00 4.34 28.90
1.00 2.40 4.27 27.26
1.00 1.60 3.63 27.67
2.25 2.80 4.03 30.10
2.25 3.40 6.14 40.06
2.25 2.60 5.29 40.82
1.75 2.20 7.25 41.57
1.25 1.80 4.43 32.37
2.00 2.00 4.92 36.82
1.00 4.20 4.67 26.46
3.00 3.00 4.63 29.51
2.50 2.40 5.07 34.39
3.00 3.00 4.41 27.78
1.25 3.20 6.45 42.82
2.00 1.40 4.68 36.79
3.50 5.00 5.33 36.05
3.00 3.00 4.01 28.76
1.00 1.00 7.00 46.31
2.50 1.60 4.96 29.47
1.00 1.60 5.01 34.60
1.25 2.80 3.86 29.73
4.25 3.40 4.07 33.78
2.25 2.20 5.07 37.06
1.50 2.00 5.15 31.93
1.75 3.00 5.46 39.00
1.00 1.80 4.25 26.77
2.25 4.20 5.34 36.44
3.00 3.00 4.63 29.89
1.00 1.00 4.06 32.31
3.00 1.40 5.37 33.69
1.50 1.20 4.04 28.22
3.00 1.80 4.45 33.02
2.00 1.80 4.83 32.72
3.25 3.40 4.52 33.04
2.75 3.60 2.87 22.96
2.25 4.20 3.93 26.63
1.25 3.60 5.12 33.29
1.50 2.60 4.18 26.20
2.50 3.00 2.57 21.40
3.25 2.00 5.58 39.22
3.75 3.80 4.21 29.23
1.75 2.00 5.65 38.38
2.50 3.00 5.35 40.67
3.00 2.20 4.99 32.68
4.75 4.20 5.09 32.02
1.00 2.20 5.58 37.13
4.00 4.00 4.59 35.19
1.00 3.80 3.37 26.52
1.75 2.00 4.80 30.70
3.25 3.00 5.28 32.15
2.00 2.00 5.77 38.28
2.50 1.00 4.03 26.47
1.00 3.40 6.03 38.77
2.50 2.20 5.90 39.59
1.75 2.00 3.26 25.07
2.50 2.40 3.33 29.79
3.00 3.20 5.92 40.97
1.50 4.60 2.96 23.51
1.50 1.80 5.64 38.46
2.25 1.80 4.10 30.74
1.00 2.80 5.78 35.36
2.50 1.60 5.16 29.94
1.00 1.00 5.01 30.87
3.25 1.80 4.77 30.77
1.75 2.80 5.89 41.90
5.00 5.00 4.85 27.42
1.00 1.60 5.36 29.61
1.00 2.80 6.44 41.69
2.00 2.60 5.53 33.12
1.50 1.60 5.26 29.56
1.25 1.60 4.74 25.45
2.00 2.00 5.07 32.13
2.50 3.20 5.70 41.47
2.50 2.80 5.98 35.03
2.00 4.60 3.44 30.72
2.75 1.80 4.86 32.09
4.00 4.00 4.58 31.94
3.50 3.60 5.15 36.38
1.00 1.80 5.15 32.11
2.00 2.00 2.86 20.44
1.75 2.40 4.68 28.56
1.25 1.80 4.80 26.87
1.75 1.80 5.88 35.40
3.50 3.20 4.77 32.48
2.50 1.60 3.77 25.83
2.25 3.20 4.62 32.65
2.50 2.40 5.40 32.67
2.00 2.60 5.37 33.25
3.50 3.60 3.12 22.51
3.00 2.40 7.29 46.16
1.00 3.40 5.28 37.48
3.75 2.00 4.61 32.86
2.00 1.60 5.13 38.01
1.00 1.00 5.53 36.86
1.00 3.00 4.57 29.15
1.75 3.20 4.55 30.96
1.50 1.00 3.25 22.85
2.75 1.40 6.17 40.78
1.25 3.40 4.87 28.89
2.25 3.20 3.98 29.11
1.00 1.60 4.16 29.86
2.25 2.60 4.57 32.09
1.00 1.20 5.40 29.61
3.75 2.80 4.63 31.54
2.00 2.80 3.64 28.52
2.25 2.60 5.17 31.14
3.00 1.00 5.97 34.38
3.00 1.00 5.39 34.66
1.50 2.60 3.31 21.08
3.00 2.20 2.64 21.21
3.75 3.00 3.79 28.52
1.50 2.40 5.18 36.12
2.50 3.20 6.74 40.84
3.00 3.00 6.94 43.03
3.00 2.40 5.36 36.17
1.75 2.20 4.99 33.34
4.00 1.40 3.89 29.02
1.75 2.00 3.82 27.28
2.50 2.00 4.80 25.79
3.00 3.20 5.62 38.62
1.50 2.40 4.01 31.00
3.00 3.00 4.30 24.45
5.00 2.40 2.67 26.78
3.25 3.00 4.30 30.06
3.00 2.60 6.31 35.50
1.75 3.00 5.40 34.02
2.25 4.20 4.96 33.47
1.25 2.00 4.64 30.76
3.75 3.80 7.24 44.20
1.00 1.60 3.70 25.66
2.75 2.40 4.73 30.10
2.75 1.40 4.67 27.69
2.75 2.40 4.78 25.08
2.00 3.40 5.05 31.84
5.00 5.00 3.91 28.96
2.25 1.20 3.95 26.67
1.25 3.40 3.86 27.56
1.00 2.20 6.85 41.43
3.00 3.40 5.06 33.27
1.50 1.80 4.79 29.13
1.75 1.20 3.29 23.51
3.50 3.60 6.26 38.02
2.50 1.60 5.01 33.32
5.00 5.00 4.24 36.57
1.00 2.00 5.15 34.33
1.25 3.40 3.98 32.40
4.25 3.40 6.09 43.18
3.00 1.60 4.29 27.85
1.50 2.80 4.68 31.89
1.00 1.80 4.84 29.45
 MS F Significance F
8210.362 883.880446 1.90742E-283
9.288996

t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0%
16.67647 2.0469E-55 8.1197974258 10.2855123 8.119797426 10.28551229
0.212231 0.83196874 -0.186797019 0.23210328 -0.18679702 0.232103279
-1.515028 0.1300741 -0.382462049 0.04919282 -0.38246205 0.049192822
51.30215 4.05E-285 4.6933296366 5.0666445 4.693329637 5.0666445

12 QUESTIONS
MULTIPLE LINEAR REGRESSION

Square_mtrs Age Corner IPTU Price

883 13 0 1639 205000
888 6 0 1193 215000
974 3 0 1635 215000
860 4 0 1732 199900
860 4 0 1534 190000
925 2 0 1765 180000
640 1 0 1161 156000
570 1 0 1010 144900
612 4 0 1191 137500
627 8 0 930 127000
717 15 0 984 125000
631 14 0 1112 123500
643 18 0 600 117000
589 16 0 794 115500
543 15 1 867 111000
560 17 1 750 113900
500 15 0 743 99500
467 16 1 731 90000
524 17 0 768 96000
977 28 1 1142 169500
733 28 0 1035 155300
493 53 1 626 102000
571 30 1 600 102000
397 41 0 600 85000
374 46 0 398 72000
578 43 0 656 74900
949 4 0 1487 215000
751 23 0 939 135000
914 25 1 1232 129900 1)
727 17 1 1141 125000 2)
569 14 0 810 123900 3)
570 16 0 800 112500
733 26 0 1076 108000
560 13 0 875 105000 4)
633 34 0 690 104900 5)
514 20 0 820 93400
391 6 0 456 87500
419 7 1 821 80500
332 4 0 461 75900 6)
336 19 0 513 72900
361 22 0 504 71000
500 7 1 700 97500 7)
476 40 0 701 93900
705 25 0 1209 210000
350 15 0 426 58000
750 40 0 915 184400
467 45 1 481 69900
573 5 0 867 116000
580 4 0 816 110900
567 6 0 725 112900
540 6 0 800 105000
543 6 0 750 104500
640 8 0 944 105000
535 5 0 811 102000
512 7 1 668 100000
513 6 1 826 103000
580 13 0 880 97500
435 5 0 647 94000
472 7 0 866 92000
527 9 0 810 94500
412 3 0 707 87400
410 6 0 721 87200
424 4 0 638 87000
388 7 0 694 86900
400 7 1 634 76600
323 4 1 541 73900
Ho: B1 = B2=B3-B4=B5=...= 0 If we reject Ho: statistically significant relationship exists
Há: at least one B1 diff than 0 If we do not reject Ho: there is no evidence to state that a statistically si

SUMÁRIO DOS RESULTADOS

Estatística de regressão
R múltiplo 0.913484892
Quadrado de 0.834454648
Quadrado de R0.823599215
Erro-padrão 16983.80348
Observações 66

ANOVA
gl SQ MQ F F de significância
Regressão 4 88692213151 22173053288 76.86977125 3.97565E-23
Residual 61 17595424425 288449580.74
Total 65 106287637576

Coeficientes Erro-padrão Stat t valor P 95% inferior 95% superior

Interceptar 2087.83717 8119.1024437 0.2571512288 0.797927468 -14147.3116 18322.98591
Square_mtrs 125.9343366 28.965013114 4.3478087211 5.30671E-05 68.01521326 183.85346
Age -57.4561598 195.61627222 -0.293718713 0.769969905 -448.615071 333.7027518
Corner -7901.61684 5098.9697862 -1.549649668 0.126398681 -18097.6371 2294.403408
IPTU 50.35194706 16.392113138 3.0717178826 0.003177844 17.57389102 83.1300031
EQUATION: 2087+125*X1-57*X2-7901*X3+50*X4

F TEST Indica se há uma relação significativa entre a variável dependente e o conjunto das variáveis idepende
T TEST determina a significância de cada um dos parametros individuais

MULTIPLE LINEAR REGRESSION NO R

Import Dataset
attach(NOME DO ARQUIVO)
model = lm(Y ~ X1 + X2 + X3 + X4)
y - nome do Y
x1,2.. - nome do Xs
summary(model)
To get the VIF (indicates if there is multicollineraty or not)
install("car")
library("car")
vif(model)
x0 = data.frame(Y = numero, X1 = 0 , X2 = 0, etc)
y - nome do Y
numero = numero que você quer
predict(model, x0, interval="prediction", level=0.95)
predict(model, x0, interval="confidence", level=0.95)
 ship exists
o state that a statistically significant relationship exists

CORRELATION
Square_mtrs
Square_mtrs 1
Age -0.03769359
Corner -0.0785015
IPTU 0.875249556
Price 0.88394183

IPTU E SQUARE MTS are h

correlated with price. Thus,
cause multicollinearty pro
because the variables are supp
independent!

Inferior 95,0%Superior 95,0% INTERPRERTING COEFFICIENTS

-14147.3116 18322.98591 TRUE
68.01521326 183.85346 FALSE
-448.615071 333.7027518 TRUE
-18097.6371 2294.403408 TRUE A positive coefficient indicates that as the va
17.57389102 83.1300031 FALSE independent variable increases, the mean
dependent variable also tends to increase. A
coefficient suggests that as the independen
increases, the dependent variable tends to
unto das variáveis idependentes (Y com X1;X2)

VIF The coefficient value signifies how much the

the dependent variable changes given a one
Higher than 5 = MULTICOLLINEARTY in the independent variable while holdin
variables in the model constant. This prop
BACKWARD VARIABLE SELECTION holding the other variables constant is crucia
it allows you to assess the effect of each va
Remove every variable that has p- isolation from the others
value>5% and do it all again

DUMMY
 isolation from the others

Same ideia - only difference is that you

have to change things for 1 and 0

If we have 3 answear option we create

d-1
 Age Corner IPTU Price

1
0.162728128 1
-0.29184225 -0.15317383 1
-0.16666201 -0.18758563 0.877527025 1

IPTU E SQUARE MTS are highly

correlated with price. Thus, this can
cause multicollinearty problems
cause the variables are suppose to be
independent!

COEFFICIENTS SHAPIRO-WILK TEST

H0: the residuals are normally distributed
Ha: the residuals are NOT normally distribu
Run the shapiro-wilk test: shapiro.test(rstu
cient indicates that as the value of the
variable increases, the mean of the *Considering that the p-value is close to zero
ble also tends to increase. A negative
ests that as the independent variable
ependent variable tends to decrease. BREUSCH-PAGAN TEST
H0: the residuals are homoscedastic.
Ha: the residuals are NOT homoscedastic (
Run the test: bptest(regression model form

*Considering that the p-value is approx. 0 (1.2

value signifies how much the mean of

ariable changes given a one-unit shift
ndent variable while holding other
e model constant. This property of
r variables constant is crucial because
assess the effect of each variable in
olation from the others
s are normally distributed
s are NOT normally distributed.
-wilk test: shapiro.test(rstudent(model))

t the p-value is close to zero (<alpha) then we reject the null hypothesis.

s are homoscedastic.
s are NOT homoscedastic (they are heteroscedastic).
test(regression model formula, varformula = ~ rstudent(name of the model), studentize=TRUE, data=name of the datab

the p-value is approx. 0 (1.23e-11), we reject the null hypothesis

E, data=name of the database)
 STATISTICS - FINAL STUDY

Hypothesis Testing

EX 1
H0 = 3200 TOBS P VALUE
HA ≠ 3200 -1.05 0.8495427739
SAMPLE 36 -0.150457226
MEAN S 3130 0.3009144521
STD SAMPLE 400
SIG LEVEL 0.05 0,3 > 0,05
do not reject

EX 2

SAMPLE 380 POP P VALUE

INGESTED 25 -1.34279913 0.0896685122
SIG LEVEL 0.05
H0 = 0.085 0,08 > 0,05
HÁ < 0.085 do not reject
PROPORTION 0.065789474

EX 3
H0 = 0.4 POP P VALUE
HÁ ≠ 0.4 2.132451285 0.9835151174
SAMPLE 88 0.0164848826
SATISFIED 45 0.0329697652
PROP 0.511363636
SIG LEVEL 0.05

EX 4
HO <= 3200 TOBS P VALUE
HÁ > 3200 1.893039883 0.0340175359
SAMPLE 31
MEAN 3370
SAM STD DEV 500

EX 6
POP MEAN 3000 ZOBS P VALUE
POP STD DEV 500 2.681611456 0.0036634252
SAMPLE 40
SAM MEAN 3212 0,05 > 0,003
reject
H0 = 3000
HÁ > 3000

EX 7
POP MEAN 6 ZOBS P VALUE
SAMPLE 49 2.1 0.9821355794
SAM MEAN 6.3 0.0178644206
POP STD DEV 1 0.0357288411

H0 = 6 0,03 < 0,05

HÁ ≠ 6 reject

EX 8
POP MEAN 100 ZOBS P VALUE
STD DEV POP 100 1 0.1586552539
SAMPLE 25
SAM MEAN 120

H0 = 100
HÁ > 120
 Hypothesis Testing 2 pop

EX 1
BRAND MEN WOMEN TOTAL
A 49 53 102 Test Statistic
B 75 45 120 133192.316
C 62 58 120 367105.263
TOTAL 186 156 342 250871.579

EXPECTED MEN WOMEN TOTAL

A 55.47368421 46.52631579 102 XOBS
B 65.26315789 54.73684211 120 CRITICAL
C 65.26315789 54.73684211 120 P
TOTAL 186 156 342
Test Statistic
130692.421
110842.105
184134.737

1176838.42
3.84145882
0.0500
 HYPOTESIS TEST

POP. ST.DEV. PROVIDED - ONE-TAILED

EX1
STD DEV
SAMPLE HO: M >= Lower CI
SAMPLE MEAN HÁ: M<= Upper CI
MEAN POP
SIG LEVEL

Z OBS P value Critical Value

#DIV/0! #DIV/0! -1.64485363

UNKNOWN POP. STD DEV - USE T use a t test when the exercise gives
EX1 you the std dev of the SAMPLE
H0 =
HÁ ≠ TOBS P value
SAMPLE #DIV/0! #DIV/0!
SAMPLE MEAN
SAMPLE ST. D
SIG LEVEL
CRITICAL

HYPOTHESIS TEST MORE POP CHI SQUARE

Indiv Weight bef Weight aft Bef - After Less variables

1 130 121 9
2 142 123 19 Observed
3 126 127 -1
4 151 135 16
5 118 109 9 Expected
6 97 94 3
7 104 102 2
8 122 115 7
MEANS 123.75 115.75 8
17.97 13.55 6.87
XOBS
Critical
t-Test: Paired Two Sample for Means P

Weight bef Weight aft

Mean 123.75 115.75
Variance 323.0714286 183.6428571
Observations 8 8 More Variables
Pearson Correl0.943380139
Hypothesized 0 Observed
df 7 x
t Stat 3.295543363 y
P(T<=t) one-tai0.006600707 z
t Critical one-t 1.894578605 TOTAL
P(T<=t) two-tai0.013201414
t Critical two-t 2.364624252 Expected
x
y
z
TOTAL
 POP. ST.DEV. PROVIDED - TWO-TAILED use a two tailed test when the hyp is DIFFERENT than something
EX1
HO M= ZOBS P value
HA M≠ #DIV/0! #DIV/0!
SAMPLE #DIV/0!
SAMPLE MEAN #DIV/0!
STD DEV
SIG LEVEL
CRIT VALUE

POP PROPORTION
EX1
SAMPLE POP P VALUE
WHAT DID #DIV/0! #DIV/0!
SIG LEVEL
H0 =
HÁ <
PROPORTION #DIV/0!

CHI SQUARE

s variables

1 2 3 4 5 6
15 13 17 15 20 20

1 2 3 4 5 6
16.67 16.67 16.67 16.67 16.67 16.67 equals 100
 0.1666666667 0.8066666667 0.0066666667 0.1666666667 0.6666666667 0.6666666667

2.48 D.F with less variables DF

11.070497694 total - 1 5
0.7795040527

re Variables

thing 1 thing 2 TOTAL

0 Test Statistic
0 #DIV/0! #DIV/0!
0 #DIV/0! #DIV/0!
0 0 0 #DIV/0! #DIV/0!

thing 1 thing 2 TOTAL

#DIV/0! #DIV/0! 0 XOBS #DIV/0!
#DIV/0! #DIV/0! 0 CRITICAL 3.841458821
#DIV/0! #DIV/0! 0 P 0.0500
0 0 0
D.F with many variabés
(total columns - 1)*(total lines - 1)

D.F
1
ENT than something

ZOBS = (SAMPLE MEAN - POP MEAN)/(ST DEV/SQRT(SAMPLE))

P VALUE USING Z - ONE TAILED: NORM.S.DIST
or 1-NORM.S.DIST --> use this when HA > H0
P VALUE USING Z - TWO TAILED: NORM.S.DIST
subtract the result for 1 and then multiplies for 2

TOBS = (SAMPLE MEAN - POP MEAN)/(ST DEV/SQRT(SAMPLE))

use a t test when we have the sample std dev instead of the sample
P VALUE USING T - ONE TAILED: T.DIST.RT
P VALUE USING T - TWO TAILED: T.DIST.RT
subtract the result for 1 and thenmultiplies for 2

P VALUE > SIG LEVEL : DO NOT REJECT H0

P VALUE < SIG LEVEL: REJECT H0

POP PROPORTION = (PROPORTION - H0)/SQRT(H0*(1-H0)/SAMPLE)

to calculate the proprtion: number of results/sample

HYPOTHESIS TEST AND CHI SQUARE NOTES

t test paired two sample for means:

use for matched samples, for example, voce tem um time que vend biscoito
compara a media de venda antes e depois do treinamneto
 t test for unequal variances:
used two compare independen variables, for example, comparar a media
de duas cidades diferentes

obs:
quando os sample sizes forem diferentes, so podemos usar unequal variance
 SIMPLE LINEAR REGRESSION

Using Data Analysis

ID X: height Y: weight SUMMARY OUTPUT

1 186 83
2 167 70 Regression Statistics
3 177 80 Multiple R 0.852340711
4 165 50 R Square 0.7264846877
5 163 50 Adjusted R Sq 0.6991331565
6 163 45 Standard Error 7.1074607904
7 168 51 Observations 12
8 164 46
9 166 55 ANOVA
10 161 49 df
11 160 55 Regression 1
12 170 55 Residual 10
Total 11

Coefficients
Intercept -193.27406789
X: height 1.4966611018
We can take the regression equ
y = -193,27 + 1,49x

MULT LINEAR REGRESSION

SUMMARY OUTPUT

Regression Statistics
Multiple R 0.849473651 F TEST Indicates if there is a significative relationship
R Square 72.16% T TEST Determines the significance of eachh individu
Adjusted R Sq 72.08%
Standard Error3.047785434
Observations 1027
ANOVA
df SS MS F Significance F
Regression 3 24631.08593 8210.361977 883.8804463 1.907418E-283
Residual 1023 9502.642962 9.288996052
Total 1026 34133.72889

Coefficients Standard Error t Stat P-value Lower 95%

Intercept 9.202654856 0.551834768 16.676468 2.0469E-55 8.1197974258
X1 0.02265313 0.10673785 0.212231462 0.83196874 -0.186797019
X2 -0.16663461 0.109987778 -1.51502845 0.1300741 -0.3824620493
X3 4.879987068 0.095122458 51.30215475 4.05E-285 4.6933296366
EQUATION: 9,02+0,02*X1-0,16*X2+4,87*X3

SHAPIRO-WILK TEST
H0: the residuals are normally distributed
Ha: the residuals are NOT normally distributed.
Run the shapiro-wilk test: shapiro.test(rstudent(model))

*Considering that the p-value is close to zero (<alpha) then we reject the null hypothesis.

BREUSCH-PAGAN TEST
H0: the residuals are homoscedastic.
Ha: the residuals are NOT homoscedastic (they are heteroscedastic).
Run the test: bptest(regression model formula, varformula = ~ rstudent(name of the model), stu
 SS MS F Significance F
1341.756678 1341.756678 26.56102438 0.00042911 p value of the test
505.1599889 50.51599889
1846.916667

Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0%
48.68575059 -3.96982825 0.002644077 -301.75268 -84.7954555 -301.75268 -84.7954555
0.290402975 5.153738873 0.00042911 0.84960295 2.143719253 0.84960295 2.143719253
an take the regression equation from here
193,27 + 1,49x

a significative relationship between the dependent variable and the range of independents (Y com X1;X2)
nificance of eachh individual parameter
 VIF
Higher than 5 = MULTICOLLINEARTY
p value of the test
BACKWARD VARIABLE SELECTION
Remove every variable that has p-
value>5% and do it all again
Upper 95% Lower 95,0% Upper 95,0%
10.28551229 8.119797426 10.28551229 DUMMY
0.232103279 -0.18679702 0.232103279
Same ideia - only difference is that you
0.049192822 -0.38246205 0.049192822 have to change things for 1 and 0
5.0666445 4.693329637 5.0666445
If we have 3 answear option we create d-
1

ll hypothesis.

t(name of the model), studentize=TRUE, data=name of the database)

 X : Independent variable/predictable variable
Y: Dependent variable

Regression Equation: E(y) = B0 + BiX

The higher the correl, the higher is the Rˆ2 and the better the moel fits

Percentage of the variability of the dependent variable = Correl*2

Correlation = CORREL(range x; range y)

Find the sample size: df residual + 2

Extrapo: estimate beyond the og range, the value of a var based on another

Using t-test h = 0: there is no linear relation --> h ≠ 0: there is

SST = SSR + SSr

R^2 : Ssregression/SST

MULTIPLE LINEAR REGRESSION NO R

1) Import Dataset
2) attach(NOME DO ARQUIVO)
3) model = lm(Y ~ X1 + X2 + X3 + X4)
 y - nome do Y
x1,2.. - nome do Xs
4) summary(model)
5) To get the VIF (indicates if there is multicollineraty or not)
install("car")
library("car")
vif(model)
6) x0 = data.frame(Y = numero, X1 = 0 , X2 = 0, etc)
y - nome do Y
numero = numero que você quer
7) predict(model, x0, interval="prediction", level=0.95)
predict(model, x0, interval="confidence", level=0.95)