Result of equation in Matlab is different from Excel.
11 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Dyuman Joshi
il 12 Dic 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))
Risposte (0)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!