Result of equation in Matlab is different from Excel.
11 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Dyuman Joshi
le 12 Déc 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))
Réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!