Kudlers data table analysis
Data analysis the datatable way general form: dt[i, j, by] “take dt, subset rows using i, then calculate j grouped by by” create a data table. Data analysis using datatable data manipulation operations such as subset, group, update, join etc, are all inherently related keeping these.
Instead of creating different scenarios, you can create a data table to quickly try out different values for formulas you can create a one variable data table or a.
Excel: the what if analysis with data table there are some excel features that are awesome but somewhat hidden and the data table analysis is one of them .
Download kudlers data table analysis