MATLAB Answers

importing the excel data into matlab in symbolic math tool

37 views (last 30 days)
sunitha
sunitha on 15 Jan 2021
Answered: sunitha on 16 Jan 2021
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 Comments

Sign in to comment.

Answers (2)

Walter Roberson
Walter Roberson on 15 Jan 2021
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 Comments

Show 6 older comments
sunitha
sunitha on 16 Jan 2021
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
Walter Roberson on 16 Jan 2021
We do not have your data to test with. We also do not know what your manual calculations came out as.

Sign in to comment.


sunitha
sunitha on 16 Jan 2021
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)

  0 Comments

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!