Hello everyone. can anybody please tell me how can i solve differential equations using Excel...
Excel can help you in solving differential equations numerically, specially if you know the programming language of Visual Basic for Applications under Excel, Which is so easy to be learnt. After writting VBA code that solve your problem and compile it to get output data, you can use Excel spread sheets to organize your data and graph it so easily with little effort using the facilities of Excel to graph so many types of charts.
This link can help you to learn such language
http://www.homeandlearn.co.uk/NET/excel_vba.html
With Best Wishes
Use octave is better. Export data from exel in csv format and import it in octave.
Solve the problem and export its data on the ascii file in csv form to import it back to exel.
https://www.gnu.org/software/octave/doc/v4.0.0/Simple-Examples.html#Integrating-Differential-Equations
Dear Asma
beside the previous answers of researchers, i would also recommend Mathematica software.
Borut Jurcic Zlobec sir, thanks for ur reply. can u please give me some idea about octave??
Jamal Salah sir. if i will learn Mathematica to solve differential equations. can mathematica be then linked with excel???
https://www.gnu.org/software/octave/
GNU Octave is a high-level interpreted language, primarily intended for numerical computations. It provides capabilities for the numerical solution of linear and nonlinear problems, and for performing other numerical experiments. It also provides extensive graphics capabilities for data visualization and manipulation. Octave is normally used through its interactive command line interface, but it can also be used to write non-interactive programs. The Octave language is quite similar to Matlab so that most programs are easily portable.
Octave is distributed under the terms of the GNU General Public License
Answer to the last question is YES
https://www.wolfram.com/products/applications/excel_link/
But Mathematica is not free.
http://octave.sourceforge.net/io/function/xlsread.html
How to read the exel files from Octave.
Dear Asma,
In Excel you can only solve differential equations numerically, but in Mathematica you can try to solve it analytically too. When you learn Mathematica or Matlab I think you will not need further assistance from Excel, because you can also plot your output data in Mathematica or Matlab. and if you want to link between Mathematica and Excel for example you can use the following tool powered by Wolfram company that produce Mathematica program, the following link has details:
https://www.wolfram.com/products/applications/excel_link/
Best Luck.
- Badges
- Science topic
- Similar topics
- Mathematics
- Applied Mathematics
- Differential Equations