Upload
andrea-alarcon
View
227
Download
0
Embed Size (px)
DESCRIPTION
tablas de excel para aproximacion funcional
Citation preview
Hoja1APROXIMACIN FUNCIONALCon los siguientes datos encontrar el polinomio de segundo grado que mejor se ajuste a la siguiente tabla de datos:
XYXYX^2X^3X^4XYX^2Y747449343240128196929281729656118162272748161428686836216129648288TOTAL2421170129610274108674
424170211642.55.25241701296108026276-1817012961027467402763049-218.5
10-21.19239.40381004.5265a0=4.52650110.6154-0.69230101.7508a1=1.750800119.1538-27.4231001-0.2301a2=1.7508
POLINOMIO GRADO 24,5265+1,7508x-0,2301x^2Encontrar el polinomio de tercer grado que mejor se ajuste a lasiguiente tabla de datos
XYXYX^2X^3X^4X^5X^6XY(X^2)Y(X^3)Y7474493432401168071176492819613729292817296561590495314411816214582727481632641428566868362161296777646656482881728TOTAL2421170129610274836646958101086744614
4241701296211642.53245.25241701296102741080262762498-18170129610274836646740276304928584-218.51296102748366469581046140249828584275906-2190
10-21.1923076923-252.46153846159.4038461538100115.1271788254.52646868950110.615384615496.0769230769-0.6923076923010-88.05100064561.750806972200119.15384615382066.7692307692-27.423076923100117.3453841188-0.2301484829002066.769230769235905.8461538462-460.615384615400056.939961265415.0484183344
1000-25.9a3=-25.9000010025.0214285714a2=25.02140010-4.8142857143a1=-4.814300010.2642857143a0=0.2643POLINOMIO GRADO 3-25,9+25,0214x-4,8143x^2+0,2643x^3