Re: [ANN] orgtbl-fit

[tbanelwebmin]

Hi Ihor & the List

GnuPlot is a great software. If you feel confortable with it, continue 
using it! If others are used to R or Python, that is fine too.

Orgtbl-fit may be useful if:

 * - You want a pure Emacs process, without external dependencies.
 * - You know that Emacs-Calc can fit your data, but you are not
   familiar with it.
 * - Your data is already available as an Org Mode table.
 * - You don't want to write a script (just point at the target column
   and type M-x orgtbl-fit, that's all).

Actually, orgtbl-fit is a bridge between Org Mode tables and Calc.

By the way, Org Mode table spreadsheet capabilities are also a bridge 
with Calc.

Examples & documentation can be read here:
https://github.com/tbanel/orgtblfit/blob/main/README.org

Have fun!


On 1/24/23 20:55, Ihor Radchenko wrote:
> tbanelwebmin <tbanelwebmin@free.fr> writes:
>
> > The new orgtbl-fit package has just been released on Melpa. It
> > does regression fitting on Org Mode tables.
> >
> > Example. We suspect that `obs' depends on `x' and `y'.
> > ...
> >
> > Let us put the cursor on the `obs' column, and type
> > M-x orgtbl-fit
> >
> > Two columns are added
> > - predicted obs column
> > - difference between obs and predicted
> >
> > |  x | y |  obs | Best Fit | Fit Diff |
> > |----+---+------+----------+----------|
> > | 32 | 7 | 38.3 |     38.2 |     -0.1 |
> > | 18 | 3 | 11.4 |     11.6 |      0.2 |
> > | 43 | 9 | 47.3 |     47.2 |     -0.1 |
> > | 11 | 2 |  8.9 |      8.7 |     -0.2 |
> > | 35 | 8 | 45.1 |     45.3 |      0.2 |
> > #+TBLFM: $4=-0.289267886829 - 1.06613976706*$1 + 10.3668885192*$2;
> > %.1f::$5=$4-$3; %.1f
> Are there situations when this package is actually useful for data
> analysis? (I am usually using gnuplot for fitting)