Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a Cube to store Histogram information?
I am running regressions off of SQL server using VBA for calculation.
In addition to this, I would like to be able to create histograms with that bucket all the variables. It should be able to create cross-distributions for 1, 2, or 3 variables, and do so with a simple ..AddRow() method or something like that. Since there are lots of variables in the regression, I do not want to create a huge array with a dimension for each variable. I expect most cross-buckets (sub-cubes) to be empty, so I think that a SparseCube object could do the trick, if such a thing were to exist. Also, I am calculating directly off a SQL statement that returns millions of rows, so whatever solution I take must be able to handle that and not slow down the regression calculation too much. If there is an entirely different way to bucket and store the data such that I can easily aggregate over variables to get a 1, 2, or 3 dimensional grid of data that an Excel histogram can easily display, however, I would be open to it. Of the class of things that work, whatever is fastest to obtain or build... Any help would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Store hidden information in Excel throw Add-In | Excel Discussion (Misc queries) | |||
suppress warning and locate cube in a pivot table from olap cube | Excel Discussion (Misc queries) | |||
store inventory sheet(ex:sports equipment store) | Excel Worksheet Functions | |||
Store Information but not in a Workbook | Excel Programming | |||
store some of the information from one cell into another | Excel Discussion (Misc queries) |