3 ms·

We got around the inaccuracy problems where I'm at by doing all the sensitive calculations in a more capable program (SAS where I'm at now--R when I consult), t

We got around the inaccuracy problems where I'm at by doing all the sensitive calculations in a more capable program (SAS where I'm at now--R when I consult), then exporting the results to Excel. It avoids most of the problems faced by the poor statistical tools in Excel. It's frustrating to think how difficult it is to cut Excel from the pipeline, but such is the dilemma with Excel being as virulent as it is.

pseut 13y ago
IIRC there's a plugin that lets you call R functions within excel.
- kfk 13y ago
  I always found much easier to do all the work in R or Python and then put the results in Excel. Excel is really not a good tool for things that go beyond additions and vlookups.