Excel - plot for multiple values of x

[jamesbrown]

Yes, if you come from a Matlab background it should be no problem at all. It can be infuriating sometimes, but it's extremely powerful (aside from the base packages, there are hundreds of contributed packages) and, perhaps most importantly, has a very large user base and good online documentation. See ?points to add other datasets to the same plot. Anyway, good luck and I hope if works out for you.

[scooterscot]

Sorry 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..).

Already getting results using R. Like Matlab, sort of. Feels intuitive. Good recommend, thanks..

[jamesbrown]

I never expected to get a hit googling 'R'!

I'm guessing you mean: The R Project for Statistical Computing

Sorry 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..).

[scooterscot]

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

[jamesbrown]

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.

[scooterscot]

When excel fails me I turn to Grapher. The amount of times this little app has saved my bacon. In this example Sc is calculated 50 times over for sequential values of x.

[Pondlife]

Can you give us an example?

[scooterscot]

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?

Not when the formula has 20+ coefficients, too much scope for human error at that point. Also I'd like to test for different coefficients, not always the same one. Matlab is good for this but is overkill and expensive to maintain.

[d000hg]

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?

[scooterscot]

Yep. Start reading up on Array Formulas...

Oh no, not those. It's a valid point right enough, but you have to trigger them every time you wish to calculate if I remember.. but that might not be a bad thing. Thanks.

[malvolio]

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...

[scooterscot]

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.