Result of equation in Matlab is different from Excel.
11 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
As the numbers increase (not very big), digits after decimal points become different from Excel and calculator. I get 158486.23 in Excel, and 158486.44 in Matlab. Which one is more accurate and should l take into account?
7 comentarios
Dyuman Joshi
el 12 de Dic. de 2023
Both of them provide the same values.
I have attached the excel file where I computed the values. You can download the file and check the formulas and the values.
And here's the output from MATLAB -
x1 = 2456.60;
x2 = 2750.80;
x3 = 2958.45;
a1 = 56.50;
a2 = -56.50;
a3 = 0;
b1 = 120.48;
b2 = 196.65;
b3 = 42.80;
t = 2450;
format longg
Z1 = (((x1*a1) + (x2*a2) + (x3*a3)) / (t))
Z2 = (((x1*b1) + (x2*b2) + (x3*b3)) / (t))
Respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!