Clear Filters
Clear Filters

Result of equation in Matlab is different from Excel.

2 views (last 30 days)
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 Comments
Dyuman Joshi
Dyuman Joshi on 12 Dec 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))
Z1 =
-6.78461224489797
Z2 = (((x1*b1) + (x2*b2) + (x3*b3)) / (t))
Z2 =
393.280672653061
piston_pim_offset
piston_pim_offset on 13 Dec 2023
l apologize for taking your time. There was a wrong digit in my code.

Sign in to comment.

Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!