ClubEnsayos.com - Ensayos de Calidad, Tareas y Monografias
Buscar

Base de datos Proyecto Integrador 1


Enviado por   •  11 de Febrero de 2018  •  Apuntes  •  1.054 Palabras (5 Páginas)  •  210 Visitas

Página 1 de 5

Resumen

Estadísticas de la regresión

Coeficiente de correlación múltiple

0.07318861

Coeficiente de determinación R^2

0.00535657

R^2  ajustado

-0.0002313

Error típico

0.89957656

Observaciones

180

ANÁLISIS DE VARIANZA

 

Grados de libertad

Suma de cuadrados

Promedio de los cuadrados

F

Valor crítico de F

Regresión

1

0.77573943

0.77573943

0.95860482

0.32886746

Residuos

178

144.04436

0.80923798

Total

179

144.8201

 

 

 

 

Coeficientes

Error típico

Estadístico t

Probabilidad

Inferior 95%

Superior 95%

Inferior 95.0%

Superior 95.0%

Intercepción

90.5562926

1.09877798

82.4154597

1.046E-143

88.3879852

92.7246001

88.3879852

92.7246001

Variable X 1

0.00084389

0.00086192

0.97908367

0.32886746

-0.000857

0.00254479

-0.000857

0.00254479

Análisis de los residuales

Resultados de datos de probabilidad

Observación

Pronóstico para Y

Residuos

Residuos estándares

Percentil

Y

1

91.6909038

-0.1589038

-0.1771383

0.27777778

90.003

2

91.7288535

0.42614647

0.47504777

0.83333333

90.064

3

91.6071307

-0.7981307

-0.8897181

1.38888889

90.102

4

91.7208619

-0.1278619

-0.1425343

1.94444444

90.11

5

91.4884459

-0.6114459

-0.6816108

2.5

90.126

6

91.5166403

1.23035968

1.37154631

3.05555556

90.131

7

91.6795112

0.24948877

0.27811818

3.61111111

90.134

8

91.7022963

1.25870372

1.40314289

4.16666667

90.246

9

91.6938574

1.29914262

1.44822226

4.72222222

90.264

10

91.6525067

0.83849327

0.93471232

5.27777778

90.347

11

91.6010294

1.14597061

1.2774734

5.83333333

90.356

12

91.7345582

0.16144177

0.17996759

6.38888889

90.359

13

91.6989207

1.28607928

1.43365986

6.94444444

90.37

14

91.7114947

-0.1404947

-0.1566168

7.5

90.371

15

91.5453326

0.8236674

0.91818514

8.05555556

90.373

16

91.5225476

0.32945245

0.36725788

8.61111111

90.38

17

91.7006085

-0.9266085

-1.032939

9.16666667

90.395

18

91.5833077

1.38369231

1.54247422

9.72222222

90.396

19

91.519172

-0.116172

-0.129503

10.2777778

90.415

20

91.5352059

-0.1422059

-0.1585244

10.8333333

90.456

21

91.4862603

0.12073975

0.13459492

11.3888889

90.481

22

91.5699742

-0.5799742

-0.6465276

11.9444444

90.482

23

91.673604

0.020396

0.02273649

12.5

90.498

24

91.5352059

-0.6272059

-0.6991792

13.0555556

90.503

25

91.6153755

-0.8843755

-0.9858597

13.6111111

90.517

26

91.7073596

-1.0483596

-1.1686613

14.1666667

90.541

27

91.7092584

0.11374162

0.12679373

14.7222222

90.583

28

91.5402693

0.16473074

0.18363398

15.2777778

90.59

29

91.4987498

0.91225017

1.01693299

15.8333333

90.63

30

91.6474434

-0.1554434

-0.1732809

16.3888889

90.644

31

91.7225497

-1.0785497

-1.2023157

16.9444444

90.653

32

91.6156287

-0.5776287

-0.6439129

17.5

90.659

33

91.6516628

-1.1956628

-1.3328679

18.0555556

90.659

34

91.7073596

-1.0483596

-1.1686613

18.6111111

90.663

35

91.5402693

-0.8772693

-0.9779379

19.1666667

90.696

36

91.7031402

-0.6461402

-0.7202863

19.7222222

90.697

37

91.7082035

-0.3202035

-0.3569476

20.2777778

90.731

38

91.6533506

-0.5903506

-0.6580947

20.8333333

90.736

39

91.5875271

-0.8905271

-0.9927172

21.3888889

90.746

40

91.6381606

-1.5041606

-1.6767665

21.9444444

90.755

41

91.5056697

1.66133026

1.85197177

22.5

90.774

42

91.6719162

0.87208378

0.97215742

23.0555556

90.785

43

91.6156793

1.28232066

1.42946994

23.6111111

90.793

44

91.5697126

0.34528739

0.38490992

24.1666667

90.809

45

91.7133513

0.77864875

0.8680005

24.7222222

90.861

46

91.7411153

0.69988474

0.78019814

25.2777778

90.876

47

91.7385836

1.26441641

1.40951113

25.8333333

90.877

48

91.7444908

-1.6804908

-1.873331

26.3888889

90.905

49

91.7402714

-1.1502714

-1.2822677

26.9444444

90.908

50

91.6474434

-1.5374434

-1.7138686

27.5

90.954

51

91.5605226

-1.0625226

-1.1844496

28.0555556

90.954

52

91.5208598

-1.0178598

-1.1346615

28.6111111

90.98

53

91.6192574

0.22174257

0.24718804

29.1666667

90.99

54

91.5335181

-0.3515181

-0.3918557

29.7222222

91.038

55

91.6073755

-0.0513755

-0.0572709

30.2777778

91.047

56

91.7282712

-1.3812712

-1.5397753

30.8333333

91.057

57

91.6195697

0.08343033

0.09300415

31.3888889

91.063

58

91.5605226

-1.1655226

-1.2992691

31.9444444

91.064

59

91.6990895

0.0149105

0.01662152

32.5

91.073

60

91.6725913

-0.0105913

-0.0118067

33.0555556

91.15

61

91.6276963

-1.2716963

-1.4176265

33.6111111

91.169

62

91.5871474

-0.3081474

-0.343508

34.1666667

91.182

63

91.6227596

-0.2317596

-0.2583545

34.7222222

91.212

64

91.630228

1.47877199

1.64846451

35.2777778

91.219

65

91.5721261

-1.5691261

-1.749187

35.8333333

91.22

66

91.5284801

-0.3594801

-0.4007313

36.3888889

91.224

67

91.7121529

-0.5001529

-0.5575466

36.9444444

91.243

68

91.6297217

-0.8367217

-0.9327374

37.5

91.243

69

91.5384633

-0.6774633

-0.7552038

38.0555556

91.245

70

91.6492831

-0.7732831

-0.8620191

38.6111111

91.25

71

91.619595

-1.517595

-1.6917425

39.1666667

91.279

72

91.5760165

0.31598353

0.35224337

39.7222222

91.304

73

91.6181604

0.34183962

0.38106651

40.2777778

91.315

74

91.7228197

1.00918029

1.12498607

40.8333333

91.331

75

91.5594762

0.70452379

0.78536953

41.3888889

91.361

76

91.675123

0.191877

0.21389533

41.9444444

91.381

77

91.675123

-0.920123

-1.0257093

42.5

91.388

78

91.4922434

-0.7462434

-0.8318766

43.0555556

91.391

79

91.541611

-0.845611

-0.9426469

43.6111111

91.393

80

91.541611

-1.182611

-1.3183184

44.1666667

91.403

81

91.6419328

-0.4919328

-0.5483832

44.7222222

91.469

82

91.6934017

-1.1764017

-1.3113965

45.2777778

91.492

83

91.6280086

-1.2320086

-1.3733844

45.8333333

91.53

84

91.4983701

-0.5443701

-0.6068378

46.3888889

91.532

85

91.7291236

-1.3141236

-1.4649223

46.9444444

91.556

86

91.7401532

-1.4761532

-1.6455452

47.5

91.561

87

91.7433009

-1.6123009

-1.7973162

48.0555556

91.571

88

91.7120348

-0.3970348

-0.4425954

48.6111111

91.572

89

91.597291

1.58170904

1.76321383

49.1666667

91.587

90

91.511155

1.43184497

1.59615251

49.7222222

91.593

91

91.5981264

0.01187359

0.01323611

50.2777778

91.607

92

91.5216108

-1.1506108

-1.2826461

50.8333333

91.61

93

91.7099504

-0.6629504

-0.7390255

51.3888889

91.625

94

91.5946665

0.30033354

0.33479751

51.9444444

91.655

95

91.5177205

-0.2987205

-0.3329994

52.5

91.662

96

91.5366237

-1.1636237

-1.2971522

53.0555556

91.692

97

91.734111

-0.489111

-0.5452376

53.6111111

91.694

98

91.5292734

-0.9882734

-1.10168

54.1666667

91.694

99

91.6752918

1.26270822

1.40760692

54.7222222

91.703

100

91.7360519

0.32494809

0.36223663

55.2777778

91.705

101

91.7031402

1.33885982

1.4924971

55.8333333

91.714

102

91.6761357

0.28086433

0.31309416

56.3888889

91.743

103

91.573181

1.235819

1.3776321

56.9444444

91.751

104

91.6153755

-0.9623755

-1.0728104

57.5

91.761

105

91.5849955

0.17600453

0.19620146

58.0555556

91.823

106

91.5710038

-1.0900038

-1.2150842

58.6111111

91.83

107

91.6069366

-1.3609366

-1.5171073

59.1666667

91.841

108

91.720018

-0.766018

-0.8539203

59.7222222

91.848

109

91.6398484

-1.2698484

-1.4155664

60.2777778

91.852

110

91.6440678

0.04993218

0.05566201

60.8333333

91.854

111

91.580776

-0.950776

-1.0598798

61.3888889

91.863

112

91.5352059

-0.9522059

-1.0614738

61.9444444

91.867

113

91.7284569

-1.3484569

-1.5031955

62.5

91.892

114

91.7267691

0.10323088

0.11507687

63.0555556

91.895

115

91.6314095

-0.1014095

-0.1130464

63.6111111

91.896

116

91.588371

-0.027371

-0.0305119

64.1666667

91.911

117

91.7082035

-1.5822035

-1.763765

64.7222222

91.915

118

91.5250792

0.32292077

0.35997668

65.2777778

91.929

119

91.5368937

0.3171063

0.35349499

65.8333333

91.957

120

91.7141108

1.14488925

1.27626795

66.3888889

91.96

121

91.5976538

-0.8616538

-0.9605306

66.9444444

91.979

122

91.6145316

0.89146835

0.99376642

67.5

92.061

123

91.7174863

0.60851368

0.67834204

68.0555556

92.155

124

91.5478643

-0.0788643

-0.0879141

68.6111111

92.164

125

91.6406923

0.81430774

0.90775145

69.1666667

92.202

126

91.7174863

1.28151368

1.42857035

69.7222222

92.205

127

91.6330972

-0.0080972

-0.0090264

70.2777778

92.264

128

91.64238

-1.16038

-1.2935363

70.8333333

92.311

129

91.6212828

1.27771723

1.42433825

71.3888889

92.313

130

91.6330972

-0.7280972

-0.8116481

71.9444444

92.326

131

91.6148354

-0.5418354

-0.6040123

72.5

92.357

132

91.6148354

1.19316455

1.33008296

73.0555556

92.369

133

91.6508189

0.55118105

0.61443036

73.6111111

92.384

134

91.6179072

0.76609279

0.85400372

74.1666667

92.411

135

91.6179072

1.38709279

1.54626491

74.7222222

92.422

136

91.6288778

1.33712221

1.49056009

75.2777778

92.441

137

91.647975

-0.404975

-0.4514469

75.8333333

92.455

138

91.6183629

0.12463709

0.13893949

76.3888889

92.485

139

91.619595

-0.639595

-0.71299

76.9444444

92.491

140

91.619595

0.07240501

0.08071365

77.5

92.492

141

91.6350888

0.56991118

0.63530981

78.0555556

92.506

142

91.6204389

0.69256112

0.77203412

78.6111111

92.544

143

91.6139662

0.69703376

0.77702

79.1666667

92.592

144

91.6204389

1.27056112

1.41636096

79.7222222

92.647

145

91.6229706

1.15602945

1.28868651

80.2777778

92.656

146

91.6148354

-0.5508354

-0.6140451

80.8333333

92.663

147

91.6142447

-0.2532447

-0.2823051

81.3888889

92.671

148

91.6156793

0.24732066

0.27570128

81.9444444

92.732

149

91.6148101

-0.3648101

-0.4066729

82.5

92.747

150

91.6381606

1.28283941

1.43004822

83.0555556

92.747

151

91.6339411

-0.4099411

-0.4569828

83.6111111

92.757

152

91.6229706

-0.0359706

-0.0400983

84.1666667

92.779

153

91.6190887

-0.2880887

-0.3211475

84.7222222

92.808

154

91.6243377

1.48666234

1.6572603

85.2777778

92.809

155

91.6372407

1.23175925

1.37310649

85.8333333

92.841

156

91.6316879

-0.3886879

-0.4332908

86.3888889

92.859

157

91.6209537

-0.4009537

-0.446964

86.9444444

92.869

158

91.6130464

0.1379536

0.1537841

87.5

92.891

159

91.6231225

1.13387755

1.26399263

88.0555556

92.893

160

91.6135696

1.04243039

1.1620517

88.6111111

92.898

161

91.6351057

1.2578943

1.40224059

89.1666667

92.899

162

91.6272238

1.03577624

1.15463397

89.7222222

92.921

163

91.6226752

0.73432481

0.81859029

90.2777778

92.938

164

91.6339411

-0.2529411

-0.2819667

90.8333333

92.943

165

91.6345825

1.47541751

1.6447251

91.3888889

92.961

166

91.6279242

0.85707581

0.95542725

91.9444444

92.966

167

91.6235528

0.79844716

0.89007083

92.5

92.967

168

91.6280086

1.04299142

1.16267711

93.0555556

92.985

169

91.6343209

0.27667912

0.30842869

93.6111111

92.993

170

91.6309031

1.01609687

1.13269635

94.1666667

92.999

171

91.6167258

0.03827424

0.0426663

94.7222222

93.003

172

91.6410383

0.95096175

1.06008681

95.2777778

93.005

173

91.6245993

0.35440074

0.39506905

95.8333333

93.028

174

91.6335276

-0.8485276

-0.9458981

96.3888889

93.042

175

91.6241773

1.48382268

1.65409478

96.9444444

93.108

176

91.648397

-0.076397

-0.0851637

97.5

93.109

177

91.7398832

-0.4358832

-0.4859018

98.0555556

93.11

178

91.7385751

1.10242485

1.22893066

98.6111111

93.111

179

91.7254189

1.30258111

1.45205532

99.1666667

93.167

180

91.7251826

0.4388174

0.48917271

99.7222222

93.179

Respuesta:

a. ¿Cuántas variables hay en el banco de datos?

La respuesta a esta pregunta es que son 7 variables y son las columnas llamadas:

• Size

• Displacement

• Cylinders

• Drive

• Fuel Type

• City MPG

• Hwy MPG

Existe una columna que contiene elementos o entidades a partir de las cuales se han

...

Descargar como (para miembros actualizados) txt (22 Kb) pdf (107 Kb) docx (33 Kb)
Leer 4 páginas más »
Disponible sólo en Clubensayos.com