Y X1 X2 X3 X4 X5

Impuestos promedio de
Horas en Horas en
descubiertos Horas en PC Presupuesto del personas
MES Auditoria Terreno
no pagados (cientos) depto en millones part time
(cientos) (cientos)
(millones) (decenas)

Enero 29 45 16 48 10.43478261 1.551724138

Febrero 24 42 14 42 9.130434783 1.75
Marzo 27 44 15 45 9.782608696 1.62962963
Abril 25 45 13 39 8.47826087 1.8
Mayo 26 43 13 39 8.47826087 1.653846154
Junio 28 46 14 42 9.130434783 1.642857143
Julio 30 44 16 48 10.43478261 1.466666667
Agosto 28 45 16 48 10.43478261 1.607142857
Septiembre 28 44 15 45 9.782608696 1.571428571
Octubre 27 43 15 45 9.782608696 1.592592593
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.998158828
R Square 0.996321047
Adjusted R Square 0.661148237
Standard Error 0.13472009
Observations 10

ANOVA
df SS MS F Significance F
Regression 5 29.49110298 5.898220597 541.6328987 9.50222E-06
Residual 6 0.108897015 0.018149503
Total 11 29.6

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 27.230249 2.583531887 10.53993145 4.28815E-05 20.90857421 33.55192379 20.90857421 33.55192379
Horas en Auditoria (cientos) 0.593383136 0.03818794 15.53849565 4.49632E-06 0.499940614 0.686825659 0.499940614 0.686825659
Horas en PC (cientos) 0 0 65535 #NUM! 0 0 0 0
Horas en Terreno (cientos) 0.007373466 0.021638665 0.340754215 #NUM! -0.04557444 0.060321373 -0.04557444 0.060321373
Presupuesto del depto en millones 0 0 65535 #NUM! 0 0 0 0
promedio de personas part time (decenas) -16.30628194 0.780840836 -20.88297791 #NUM! -18.21693064 -14.39563324 -18.21693064 -14.39563324
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.501516661
R Square 0.251518961
Adjusted R Square 0.157958831
Standard Error 1.66414538
Observations 10

ANOVA
df SS MS F Significance F
Regression 1 7.44496124 7.44496124 2.688313506 0.139717873
Residual 8 22.15503876 2.769379845
Total 9 29.6

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept -6.302325581 20.43991026 -0.308334308 0.765703799 -53.43684317 40.832192 -53.43684317 40.832192
Horas en Auditoria (cientos) 0.759689922 0.463336388 1.639607729 0.139717873 -0.308765703 1.828145548 -0.308765703 1.828145548
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.771461603
R Square 0.595153004
Adjusted R Square 0.54454713
Standard Error 1.223901093
Observations 10

ANOVA
df SS MS F Significance F
Regression 1 17.61652893 17.61652893 11.76055172 0.008963221
Residual 8 11.98347107 1.497933884
Total 9 29.6

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 9.462809917 5.186608894 1.824469535 0.105527367 -2.497531641 21.42315148 -2.497531641 21.42315148
Horas en PC (cientos) 1.20661157 0.351846826 3.429366082 0.008963221 0.395251335 2.017971805 0.395251335 2.017971805
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.771461603
R Square 0.595153004
Adjusted R Square 0.54454713
Standard Error 1.223901093
Observations 10

ANOVA
df SS MS F Significance F
Regression 1 17.61652893 17.61652893 11.76055172 0.008963221
Residual 8 11.98347107 1.497933884
Total 9 29.6

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 9.462809917 5.186608894 1.824469535 0.105527367 -2.497531641 21.42315148 -2.497531641 21.42315148
Horas en Terreno (cientos) 0.402203857 0.117282275 3.429366082 0.008963221 0.131750445 0.672657268 0.131750445 0.672657268
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.771461603
R Square 0.595153004
Adjusted R Square 0.54454713
Standard Error 1.223901092
Observations 10

ANOVA
df SS MS F Significance F
Regression 1 17.61652893 17.61652893 11.76055173 0.008963221
Residual 8 11.98347107 1.497933884
Total 9 29.6

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 9.462809922 5.186608892 1.824469537 0.105527366 -2.49753163 21.42315147 -2.49753163 21.42315147
Presupuesto del depto en millones 1.85013774 0.539498466 3.429366083 0.008963221 0.606052047 3.094223434 0.606052047 3.094223434
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.918832402
R Square 0.844252983
Adjusted R Square 0.824784606
Standard Error 0.759120519
Observations 10

ANOVA
df SS MS F Significance F
Regression 1 24.98988831 24.98988831 43.36534984 0.000172015
Residual 8 4.610111695 0.576263962
Total 9 29.6

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 55.58275392 4.316737834 12.87610137 1.25094E-06 45.62833863 65.53716922 45.62833863 65.53716922
promedio de personas part time (decenas) -17.44924984 2.649752641 -6.585237265 0.000172015 -23.55959039 -11.33890929 -23.55959039 -11.33890929
 Y X1 X2 X3 X2 X3
Impuestos Horas en Horas en promedio de Horas en Presupuesto
MES descubiertos no Auditoria Terreno personas part PC del depto en
pagados (millones) (cientos) (cientos) time (decenas) (cientos) millones
Enero 29 45 48 1.551724138 16 10.43478261
Febrero 24 42 42 1.75 14 9.130434783
Marzo 27 44 45 1.62962963 15 9.782608696
Abril 25 45 39 1.8 13 8.47826087
Mayo 26 43 39 1.653846154 13 8.47826087
Junio 28 46 42 1.642857143 14 9.130434783
Julio 30 44 48 1.466666667 16 10.43478261
Agosto 28 45 48 1.607142857 16 10.43478261
Septiembre 28 44 45 1.571428571 15 9.782608696
Octubre 27 43 45 1.592592593 15 9.782608696

Junio 40.88806252 50 40 1 Información que podemos modificar en base al requerimiento

del director para poder formular
Valores de las b Coefficients
Intercept 27.230249
Horas en Auditoria (cientos) 0.593383136
Horas en Terreno (cientos) 0.007373466
promedio de personas part time (decenas) -16.30628194 Respuesta:
Formula Que pasaria si encontramos 50 horas de auditoria, 40 horas en
Y=b0+b1X1+B2x2...... terreno?
Y= 40.88806252 Detectamos 40.888 millones de impuestos no pagados

Poner 1 sola conclusión

SUMMARY OUTPUT

Regression Statistics
Multiple R 0.998158828
R Square 0.996321047
Adjusted R Square 0.827814904 con un 87 ya nos atrevemos hacer inferencias.
Standard Error 0.13472009
Observations 10

ANOVA
df SS MS F Significance F
Regression 4 29.49110298 7.372775746 541.6328987 8.8892E-07
Residual 6 0.108897015 0.018149503
Total 10 29.6

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 27.230249 2.583531887 10.53993145 4.28815E-05 20.90857421 33.55192379 20.90857421 33.55192379
Horas en Auditoria (cientos) 0.593383136 0.03818794 15.53849565 4.49632E-06 0.499940614 0.686825659 0.499940614 0.686825659
Horas en Terreno (cientos) 0.007373466 0.021638665 0.340754215 0.744903386 -0.04557444 0.060321373 -0.04557444 0.060321373
Presupuesto del depto en millones 0 0 65535 #NUM! 0 0 0 0
promedio de personas part time (decenas) -16.30628194 0.780840836 -20.88297791 #NUM! -18.21693064 -14.39563324 -18.21693064 -14.39563324
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.998158828
R Square 0.996321047
Adjusted R Square 0.99448157 Relación del .99 Con esto ya podemos tomar decisiónes
Standard Error 0.13472009
Observations 10

ANOVA
df SS MS F Significance F
Regression 3 29.49110298 9.830367662 541.6328987 1.08773E-07
Residual 6 0.108897015 0.018149503
Total 9 29.6

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 27.230249 2.583531887 10.53993145 4.28815E-05 20.90857421 33.55192379 20.90857421 33.55192379
Horas en Auditoria (cientos) 0.593383136 0.03818794 15.53849565 4.49632E-06 0.499940614 0.686825659 0.499940614 0.686825659
Horas en Terreno (cientos) 0.007373466 0.021638665 0.340754215 0.744903386 -0.04557444 0.060321373 -0.04557444 0.060321373
promedio de personas part time (decenas) -16.30628194 0.780840836 -20.88297791 7.85179E-07 -18.21693064 -14.39563324 -18.21693064 -14.39563324