Solving numerically with Excel?

  • Thread starter Thread starter itedin
  • Start date Start date
  • Tags Tags
    Excel
Click For Summary
SUMMARY

This discussion centers on automating numerical solutions in Excel for equations of the form exp(-x) - k1*exp(-k2*x) = k3, where k's are constants. The user has experience with Mathematica's Findroot but seeks a more efficient method due to the volume of data involved. Alternatives suggested include using MATLAB or R for data analysis, as the user lacks access to the Wolfram applet for Excel. The need for automation and integration with Excel is a key focus.

PREREQUISITES
  • Familiarity with Excel for data management
  • Basic understanding of numerical methods and root-finding algorithms
  • Knowledge of MATLAB or R for data analysis
  • Introductory experience with Mathematica for equation solving
NEXT STEPS
  • Research how to automate data transfer between Excel and MATLAB
  • Learn about R's numerical methods for solving equations
  • Explore advanced features of Mathematica for importing and exporting data
  • Investigate Excel add-ins that facilitate numerical analysis
USEFUL FOR

This discussion is beneficial for data analysts, mathematicians, and anyone looking to automate numerical solutions in Excel, particularly those familiar with MATLAB or R.

itedin
Messages
2
Reaction score
0
My quandary... it's related to not being able to evaluate numerically (non-algebraic solutions) with Excel. My Mathematica programming is limited, but I've managed to use Findroot to solve it, but it requires me to manually put in 3#'s, hit enter, then copy paste results back to excel.

However, I'll have to do this serveral thousand times! Lots of data. I really need to automate it... I realize Wolfram sells an applet to plug into Excel, but I don't own it.

Does anybody have any other solutions on how to solve numerically with an excel spreadsheet? I've tried reading Mathematica help to import/process/export... to no avail... I just don't know the language well enough.

By the way, for any curious math folks, equations to be solved are of the form...
exp(-x) - k1*exp(-k2*x) = k3, where k's are constants.

PS - I've created another thread with specific's if anybody well versed with Mathematica is willing to help.

Cheers
 
Last edited:
Computer science news on Phys.org
The general approach I would take would be to import the Excel sheet into a program like MATLAB or R and analyze the data there.
 

Similar threads

FindRoot solving of Excel input columns
  • · Replies 3 ·
Replies
3
Views
4K
Automated Air Force Lug Analysis
  • · Replies 5 ·
Replies
5
Views
5K
Excel as Analysis Tool and Homework Aid
  • · Replies 7 ·
Replies
7
Views
8K
4th Order Runge-Kutta method and over/under estimates
  • · Replies 6 ·
Replies
6
Views
3K
Mathematica [Mathematica] How to use for loop to process a list of data
  • · Replies 6 ·
Replies
6
Views
5K
Graduate Can someone walk me through solving a PDE numerically?
  • · Replies 12 ·
Replies
12
Views
2K
Need help solving a differential equation numerically
  • · Replies 6 ·
Replies
6
Views
2K
Solving a Double Integral: 0.23 Numerically, Analytically Possible?
  • · Replies 5 ·
Replies
5
Views
2K
Mathematica Numerical solution in Mathematica
  • · Replies 1 ·
Replies
1
Views
5K
Python Solving the heat equation numerically using Python
  • · Replies 4 ·
Replies
4
Views
6K