- Joined
- Nov 8, 2005
- Messages
- 22,519
- Likes received
- 1,802
- Thanks received
- 454
- Location
- Anywhere that is not broken Brexit Britain
Yep. Start reading up on Array Formulas...Is it possible? Possible to plot from a single formula calculated multiple times over for where x-0.....6 for example?
Really want to avoid going into matlab, which seems overkill.
Yep. Start reading up on Array Formulas...
May have mis-read but can't you add a column with the input values you want to use, and another with the formula values for those inputs, and feed that into a graph?
Not very elegant but wouldn't it do the job?
If you need to do these sort of things regularly, consider R (Matlab is fine too, as is the open-source version, Octave, but R is extremely powerful and has a massive user community). It will take you a while to learn, but it's almost never "overkill" vs something like Excel, because you could do this in a couple of lines of script, rather than faffing with cells and formulas in Excel.
I never expected to get a hit googling 'R'!
I'm guessing you mean: The R Project for Statistical Computing
Yes, exactly. It takes a while to learn, since it's all script-based, but it's incredibly powerful and widely used, with an excellent user/support community. It's pretty much the standard for statistical computing (the proprietary equivalent of the R language is S-plus in case that rings any bells..).