Punto a(mm) F(N) u(mm) h(N) uh/2 Δa R
1 50.00 153 0.49
2 57.20 123 0.52 34 8.84 7.20 245.56
3 62.30 101 0.55 28 7.70 5.10 301.96
4 67.40 80 0.59 25 7.38 5.10 289.22
5 72.00 65 0.65 21 6.83 4.60 296.74
6 76.00 49 0.70 17 5.95 4.00 297.50
7 79.90 39 0.75 12 4.50 3.90 230.77
276.96
Punto a(mm) u(mm) F(N) C(um/N) dc/da R
1 50.00 0.49 153 3.2026 0.1993 466.541
2 57.20 0.52 123 4.2276 0.20333 307.621
3 62.30 0.55 101 5.4455 0.32682 333.387
4 67.40 0.59 80 7.3750 0.55939 358.009
5 72.00 0.65 65 10.0000 0.86933 367.293
6 76.00 0.70 49 14.2857 1.22079 293.111
7 79.90 0.75 39 19.2308 1.6407 249.55
339.359
25.0000
20.0000
f(x) = 0.00000245991 x⁴ + 0.0000755819 x³ − 0.0551461 x² + 3.889451 x
− 78.237053
15.0000 R² = 0.99942557602679
Column E
10.0000 Polynomial (Column E)
5.0000
0.0000
0 0 0 0 0 0 0 0
.0 .0 .0 .0 .0 .0 .0 .0
50 55 60 65 70 75 80 85
c a a^2 a^3 a^4
3.2026 50 2500 125000 6250000
4.2276 57.2 3271.84 187149.248 10704937
5.4455 62.3 3881.29 241804.367 15064412.1
7.3750 67.4 4542.76 306182.024 20636668.4
10.0000 72 5184 373248 26873856
14.2857 76 5776 438976 33362176
19.2308 79.9 6384.01 510082.399 40755583.7
Resumen
Estadísticas de la regresión
Coeficiente d 0.99971275
Coeficiente d 0.99942558
R^2 ajustado 0.99827673
Error típico 0.24275721
Observacione 7
ANÁLISIS DE VARIANZA
Grados de libertad
Suma de cuadrados
Promedio de los cuadradosF Valor crítico de F
Regresión 4 205.065306 51.2663264 869.937209 0.00114852
Residuos 2 0.11786213 0.05893107
Total 6 205.183168
Coeficientes Error típico Estadístico t Probabilidad Inferior 95% Superior 95%
Intercepción -78.2370527 348.686415 -0.22437654 0.8433018 -1578.51361 1422.0395
Variable X 1 3.88945096 21.9765665 0.17698174 0.87582361 -90.6680829 98.4469849
Variable X 2 -0.0551461 0.51444934 -0.10719443 0.9244189 -2.26864296 2.15835076
Variable X 3 7.55819E-05 0.00530331 0.01425184 0.98992294 -0.02274271 0.02289387
Variable X 4 2.45991E-06 2.03223E-05 0.12104512 0.91471999 -8.498E-05 8.98995E-05
Inferior 95.0%
Superior 95.0%
-1578.51361 1422.0395
-90.6680829 98.4469849
-2.26864296 2.15835076
-0.02274271 0.02289387
-8.498E-05 8.98995E-05