Data Explorer vs XCubes

Explore and analyze your datasets. Find patterns within and between variables. Use industry standard statistical techniques without being a stats expert. Get plain english explanations. Data Explorer makes the world of data analysis accessible to the rest of us. Features include:: • Import data files (csv, txt, xls, xlsx) • Enter / edit data by hand • Browse your data set. Apply filters to zero in on the rows that interest you. • Get key stats on each variable and see a graph of its distribution • Variables can be numerical, categorical, or date / time. • Hypothesis tests of means and proportions. One, two, and paired samples. • Two way frequency tables of what values categorical variables take, including phi and Cramer's V statistics • See the distribution of a numerical variables broken down by levels of a categorical variable, including one-way ANOVA, box plot, and density plot • See how two numerical variables vary with each other (correlation) • Explain how one numerical variable varies by a combination of other numerical variables (linear and logistic regression) • Variable transformations. Calculate squares, logs, and other commonly used transformation for use in your regressions and correlations All analysis include: • Results are given in statistical terms and also in plain english • Put as many filters as you want on each analysis to focus in on the part of your data you're interested in Accepts data input in the following formats: • enter data by hand while in the field • import comma separated files (.csv) • import tab delimited text files (.txt) • import excel files (xls and xlsx) • Current version limited to 100,000 rows and 500 columns to be conservative about performance. Export options: • Email PDFs and CSVs of variable summaries and analysis results • Print variable summaries and analysis results • Email CSV of datasets you've entered or edited We are actively developing this app and have additional features lined up. Your feedback can influence the priority we put on different features so please let us know what matters to you!

XCubes is a multidimensional spreadsheet system allowing you to create and edit cubes the easy way. Compared to spreadsheets cubes can store larger amounts of data and enable data exploration/analysis by dragging and dropping the cube's dimensions. Cubes use less formulas which makes their maintenance much easier than spreadsheets. You can use the provided dimensions or create your own to build your cubes. Cubes will automatically grow or shrink when adding or removing dimensions or when adding or removing items in dimensions. Real names are used in formulas and across the system instead of traditional cell references. XCubes generates a large variety of fully interactive 2D and 3D business charts for a new experience of data visualization. You can open MS Excel files directly in the app to copy/paste data into cubes. *** Stay tuned for new features to come.