Result of equation in Matlab is different from Excel.

6 次查看（过去 30 天）
piston_pim_offset
piston_pim_offset 2023-12-12
评论： piston_pim_offset 2023-12-13
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 个评论
显示 5更早的评论
Dyuman Joshi
Dyuman Joshi 2023-12-12
Ran in:
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 2023-12-13
l apologize for taking your time. There was a wrong digit in my code.

请先登录，再进行评论。

请先登录，再回答此问题。

回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by