Re:Is Microsoft Excel an Adequate Statistics Package?
by ramblenode on Saturday August 27, 2016 @04:32PM
(#12374039)
The maximum number of rows in the most recent version is 1,048,576 [0]. I'm deducing then that your data is in wide format. What would happen if you wanted it in long format? It seems you would just be out of luck with Excel, which is not a problem in any other major statistics software.
[0] https://support.office.com/en-us/article/Excel-specification...
Re:Is Microsoft Excel an Adequate Statistics Package?
by blahi on Saturday August 27, 2016 @04:44PM
(#12374083)
Except that there is Power Pivot which is xVelocity - the same columnar store database use in SQL Server.
Re:Is Microsoft Excel an Adequate Statistics Package?
by goatlover on Saturday August 27, 2016 @09:25PM
(#12374896)
Why on Earth would you use Excel for that many data points?
Re:Is Microsoft Excel an Adequate Statistics Package?
by blahi on Sunday August 28, 2016 @02:34AM
(#12375552)
Quik self-service OLAP. Blazing fast slice & dice and multidimensional expressions (cube formulas). I would need a corporate BI solution to get that and it won't be self-service.
Nothing beats Excel + Power BI in reporting.
Not that it matters. "Data science" is not something that magically kicks in after you go beyond some "big data" threshold.
Excel is heavily used in managerial science type of positions and I can assure you those are rather heavy on the "data science" workflows.