importing the excel data into matlab in symbolic math tool

3 次查看（过去 30 天）

sunitha 2021-1-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/717595-importing-the-excel-data-into-matlab-in-symbolic-math-tool

回答： sunitha 2021-1-16

i have used symbolic math tool box to find out the variable in the equation. i have imported the data from the excel file to matlab.but i am not getting the result.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

回答（2 个）

Walter Roberson 2021-1-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/717595-importing-the-excel-data-into-matlab-in-symbolic-math-tool#answer_598495

Your X is a vector with four elements. When you use it in the equations you are creating a system of four simultaneous equations. You then ask solve to find a single N value that solves all of the equations simultaneously.

solve() is not vectorized: it is simultaneous solutions only.

9 个评论
显示 7更早的评论隐藏 7更早的评论

sunitha 2021-1-16

Here I am getting the result some what higher compared to manual calculations.and if I change the data, I am getting only one value for four outputs.

Walter Roberson 2021-1-16

We do not have your data to test with. We also do not know what your manual calculations came out as.

请先登录，再进行评论。

sunitha 2021-1-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/717595-importing-the-excel-data-into-matlab-in-symbolic-math-tool#answer_599205

在 MATLAB Online 中打开

suspended.xlsx

i have written the code for individual data to crosscheck that my getting the correct values or not .

i am attaching my code below and i am sending excel file .can u help me where i did mistake

clear all
close all
syms N
Qo=xlsread('suspended','Sheet1','A3')
R=xlsread('suspended','Sheet1','B3')
No=xlsread('suspended','Sheet1','C3')
X=xlsread('suspended','Sheet1','F3')
V=2434.67
r=(No-N)/No
k=1.076
a=0.27
Solution=solve(0==Qo*(1+R)*(No-N)*r-V*((X*k*N)/(a+N)),N);
vpa(Solution)