2 informe estadistica

ESTADISTICA Y PROBALIDIDAES Pgina | 22

UNIVERSIDAD NACIONAL DE SAN ANTONIO ABAD DEL CUSCO

FACULTAD DE INGENIERIA CIVIL

CARRERA PROFESIONAL DE INGENIERIA CIVIL

INFORME DEL SEGUNDO LABORATORIO

CURSO:ESTADISTICA Y PROBALIDIDADES DOCENTE: PRESENTADO POR: DALENS CONDORI TONNY Y.131552

1 PROBLEMA

ExploreCase Processing Summary

Cases

ValidMissingTotal

NPercentNPercentNPercent

COSTOS DE OPERACIONES33100,0%0,0%33100,0%

MILLAS33100,0%0,0%33100,0%

Descriptives

StatisticStd. Error

COSTOS DE OPERACIONESMean219,1243,4245

95% Confidence Interval for MeanLower Bound212,149

Upper Bound226,100

5% Trimmed Mean218,022

Median213,900

Variance387,007

Std. Deviation19,6725

Minimum195,6

Maximum262,3

Range66,7

Interquartile Range29,4

Skewness,868,409

Kurtosis-,436,798

MILLASMean3451,4874,500


Upper Bound3603,24


Median3232,00

Variance183158,008


Minimum2928

Maximum4394

Range1466

Interquartile Range658

Skewness,955,409

Kurtosis-,528,798

COSTOS DE OPERACIONES Frequency Stem & Leaf 2.00 19 . 58 11.00 20 . 00001122259 9.00 21 . 233355559 3.00 22 . 478 1.00 23 . 4 3.00 24 . 356 3.00 25 . 029 1.00 26 . 2 Stem width: 10.0 Each leaf: 1 case(s)

MILLAS Frequency Stem & Leaf 1.00 2 . 9 21.00 3 . 000011111111112222334 4.00 3 . 5578 7.00 4 . 0001223 Stem width: 1000 Each leaf: 1 case(s)

Regression

Variables Entered/Removedb

ModelVariables EnteredVariables RemovedMethod

1MILLASa.Enter

a. All requested variables entered.b. Dependent Variable: COSTOS DE OPERACIONES

Model Summaryb

ModelRR SquareAdjusted R SquareStd. Error of the EstimateDurbin-Watson

1,972a,946,9444,65821,165

a. Predictors: (constant) MILLAS...b. Dependent Variable: COSTOS DE OPERACIONES

ANOVAb

ModelSum of SquaresdfMean SquareFSignificance

1Regression11711,544111711,544539,721,000a

Residual672,6773121,699

Total12384,22132

a. Predictors: (constant) MILLAS...b. Dependent Variable: COSTOS DE OPERACIONE

Coefficientsa

ModelUnstandardized CoefficientsStandardized CoefficientstSignificance

BStd. ErrorBeta

1(Constant)64,8396,6909,691,000

MILLAS,045,002,97223,232,000

a. Dependent Variable: COSTOS DE OPERACIONES

Residuals Statisticsa

MinimumMaximumMeanStd. DeviationN

Unstandardized Predicted Value195,724261,256219,12419,130833

Unstandardized Residual-12,27018,6244,00004,584933

Standardized Predicted Value-1,2232,202,0001,00033

Standardized Residual-2,6341,851,000,98433

a. Dependent Variable: COSTOS DE OPERACIONES

2PROBLEMAGraph

Graph

ExploreCase Processing Summary

Cases

ValidMissingTotal

NPercentNPercentNPercent

GASTOS ADMINISTRATIVOS19100,0%0,0%19100,0%

ACTIVOS19100,0%0,0%19100,0%

AGENCIAS19100,0%0,0%19100,0%

Descriptives

StatisticStd. Error

GASTOS ADMINISTRATIVOSMean18,8583,2180


Upper Bound25,619


Median15,600

Variance196,751


Minimum1,0

Maximum48,8

Range47,8


Skewness,715,524

Kurtosis-,2371,014

ACTIVOSMean429,51173,2398


Upper Bound583,382


Median376,600

Variance101917,411


Minimum45,8

Maximum1204,0

Range1158,2


Skewness1,449,524

Kurtosis1,7091,014

AGENCIASMean12,632,052


Upper Bound16,94


Median12,00

Variance80,023

Std. Deviation8,946

Minimum1

Maximum30

Range29

Interquartile Range15

Skewness,729,524

Kurtosis-,4331,014

GASTOS ADMINISTRATIVOS Frequency Stem & Leaf

6.00 0 . 113568 5.00 1 . 22458 5.00 2 . 14469 1.00 3 . 9 2.00 4 . 38 Stem width: 10.0 Each leaf: 1 case(s)

ACTIVOSFrequency Stem & Leaf 1.00 0 . 4 3.00 1 . 167 4.00 2 . 0388 3.00 3 . 179 4.00 4 . 3669 1.00 5 . 2 .00 6 . .00 7 . 1.00 8 . 3 2.00 Extremes (>=1154) Stem width: 100.0 Each leaf: 1 case(s)

AGENCIASFrequency Stem & Leaf 4.00 0 . 1334 4.00 0 . 5778 5.00 1 . 02223 1.00 1 . 8 2.00 2 . 00 1.00 2 . 5 2.00 3 . 00 Stem width: 10 Each leaf: 1 case(s)

Curve FitModel Description

Model NameMOD_1

Dependent Variable1GASTOS ADMINISTRATIVOS

Equation1Linear

2Powera

3Exponentiala

Independent VariableACTIVOS

ConstantIncluded

Var Whose Value Label Obs in Plots...Unspecified

Case Processing Summary

N

Total Cases19

Excluded Casesa0

Forecasted Cases0

Newly Created Cases0

Variable Processing Summary

Variables

DependentIndependent

GASTOS ADMINISTRATIVOSACTIVOS

Number of Positive Values1919

Number of Zeros00

Number of Negative Values00

Number of Missing ValuesUser-Missing00

System-Missing00

Model Summary and Parameter Estimates

Dependent Variable:GASTOS ADMINISTRATIVOS

EquationModel SummaryParameter Estimates

R SquareFdf1df2Sig.Constantb1

Linear,78963,449117,0002,098,039

Power,54520,354117,000,0391,000

Exponential,50217,110117,0014,614,002

Curve FitModel Description

Model NameMOD_2

Dependent Variable1GASTOS ADMINISTRATIVOS

Equation1Linear

2Powera

3Exponentiala

Independent VariableAGENCIAS

ConstantIncluded

Var Whose Value Label Obs in Plots...Unspecified

Case Processing Summary

N

Total Cases19

Excluded Casesa0

Forecasted Cases0

Newly Created Cases0

Variable Processing Summary

Variables

DependentIndependent

GASTOS ADMINISTRATIVOSAGENCIAS

Number of Positive Values1919

Number of Zeros00

Number of Negative Values00

Number of Missing ValuesUser-Missing00

System-Missing00

Model Summary and Parameter Estimates

Dependent Variable:GASTOS ADMINISTRATIVOS

EquationModel SummaryParameter Estimates

R SquareFdf1df2Sig.Constantb1

Linear,66233,299117,0002,7421,276

Power,44013,367117,0022,187,791

Exponential,49516,638117,0014,420,084

RegressionVariables Entered/Removedb


1AGENCIAS, ACTIVOS.Enter

a. All requested variables entered.b. Dependent Variable: GASTOS ADMINISTRATIVOS

Model Summaryb

ModelRR SquareAdjusted R SquareStd. Error of the EstimateDurbin-Watson

1,949a,901,8884,69021,670

a. Predictors: (constant) AGENCIAS, ACTIVOS...b. Dependent Variable: GASTOS ADMINISTRATIVOS

ANOVAb


1Regression3189,56221594,78172,497,000a

Residual351,9641621,998

Total3541,52618

a. Predictors: (constant) AGENCIAS, ACTIVOS...b. Dependent Variable: GASTOS ADMINISTRATIVO

Coefficientsa


BStd. ErrorBeta

1(Constant)-1,3542,008-,674,510

ACTIVOS,027,004,6236,198,000

AGENCIAS,669,158,4274,245,001

a. Dependent Variable: GASTOS ADMINISTRATIVOS

Coefficient Correlationsa

ModelAGENCIASACTIVOS

1CorrelationsAGENCIAS1,000-,621

ACTIVOS-,6211,000

CovariancesAGENCIAS,025,000

ACTIVOS,0001,951E-5


Residuals Statisticsa


Unstandardized Predicted Value,56943,65418,85813,311619

Unstandardized Residual-8,12707,3136,00004,421919


Standardized Residual-1,7331,559,000,94319


RegressionVariables Entered/Removedb,c


1AGENCIAS, ACTIVOS.Enter

a. All requested variables entered.b. Dependent Variable: GASTOS ADMINISTRATIVOSc. Linear Regression through ORIGN..

Model Summaryc,d

ModelRR SquarebAdjusted R SquareStd. Error of the EstimateDurbin-Watson

1,982a,965,9614,61441,482

a. Predictors: AGENCIAS, ACTIVOS...b. measures the propotionality...c. Dependent Variable: GASTOS ADMINISTRATIVOSd. Linear Regression through ORIG

ANOVAc,d


1Regression9936,33924968,170233,331,000a

Residual361,9711721,292

Total10298,310b19

a. Predictors: AGENCIAS, ACTIVOS...b. This total sum of squares is not ...c. Dependent Variable: GASTOS ADMINISTRATIVOSd. Linear Regression through ORI

Coefficientsa,b


BStd. ErrorBeta

1ACTIVOS,026,004,6016,432,000

AGENCIAS,626,142,4134,416,000

a. Dependent Variable: GASTOS ADMINISTRATIVOSb. Linear Regression through ORIGN...

Coefficient Correlationsa,b

ModelAGENCIASACTIVOS

1CorrelationsAGENCIAS1,000-,874

ACTIVOS-,8741,000

CovariancesAGENCIAS,020-,001

ACTIVOS-,0011,684E-5


Residuals Statisticsa,b


Unstandardized Predicted Value1,83543,05219,24712,688619

Unstandardized Residual-8,94698,0670-,38894,466519


Standardized Residual-1,9391,748-,084,96819


INFORME DE LABORATORIO

2 informe estadistica

Documents