Re: [ANN] orgtbl-fit

[tbanelwebmin <tbanelwebmin@free.fr>]

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