Data Explorer1.36.0 - App Store

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!

Version History Fixed issue where filters on the data were not reflected in output in some situations 1.36.0 11/05/2023 Bug fixes and improvement including:
• Bivariate analysis: residual vs fitted graph incorrectly labeled x-axis as independent var instead of dependent var. Thanks to Jim H for reporting
• Import: fixes issue where importing xlsx files exported by Numbers could fail. Thanks to Doug P for reporting 1.35.0 09/24/2023 • Fix issue with importing certain Excel files 1.34.1 06/15/2020 • Fixes for user reported issues
• Browse view correctly resizes when rotating display
• App respects safe display area limits on iPhone X* devices
• Filter button for second sample on Hypothesis test of Proportions works correctly
• Updated to more modern Apple technologies underneath 1.34.0 11/06/2018 • Updated UI to latest iOS frameworks
• Can now use app in split screen on iPad
• Fixes for user reported issues 1.33.0 12/13/2016 • Added "IN" filter type (works like IN clause in SQL WHERE statements)
• Fixes for user reported issues 1.32.0 08/16/2016 • Fixes for user reported issues 1.31.1 06/21/2016 • Added stacked bar plot to two way table when aggregating by rows or columns
• Added arrows on side of variable detail page to show you can swipe between variables
• Fixes to user reported issues 1.31.0 06/19/2016 • Fixes for user reported bugs 1.30.1 05/23/2016 • Add not equal to operator to filters
• Redesign analysis creation UI to be more consistent and have fewer steps
• Added histogram of residuals and residuals vs fitted plots to bivariate analysis
• Fixes for user reported issues 1.30.0 04/07/2016 • Added box plot to variable detail page under histogram
• When working with date/time variables display granularity is now assumed based on time scale
• Fixed bug preventing multiple filters on the same variable on variable detail page 1.29.0 02/09/2016 • Fixed issue when importing certain .xlsx files 1.28.2 05/27/2015 • Fixed a display issue on the Browse page on the iPad in landscape mode. 1.28.1 04/23/2015 • Search your analyses by variable name
• Native support for iPhone 6/6+ screen sizes
• Fixed some user reported issues 1.28.0 04/01/2015 • Linear and logistic regression split into separate analyses for ease of use
• Logistic regression adds ROC curve plot, AUC, and AIC
• On variable detail page you can swipe left and right to see the previous and next variable 1.27.0 02/01/2015 • Fixes for a few iOS 8 compatibility issues including importing some Excel spreadsheets 1.26.1 10/30/2014 • Added search to glossary
• Made it easier to purchase full version! You can now purchase the full version through the About tab in bottom right.
• Updated for iOS 8 1.26.0 10/03/2014 • Added hypothesis tests to analyses. Can do one, two, and paired sample tests of means and proportions.
• Added glossary of terms to variable detail page 1.25.0 09/03/2014 • Added a bunch of new statistics on Variable Detail page:
• Root mean square, Mode, Mid-Range
• Variance, Mean Absolute Deviation, Coeff. of Variation
• Skew, kurtosis
• Confidence intervals of: mean, standard deviation, variation
• Added Normal QQ Plot to Variable Detail page 1.24.0 07/24/2014 • For free users you can now try the full functionality when using the example workspace
• Residual plot now shows residual over fitted 1.23.0 07/01/2014 • Added: first version of inline help
• Fixes for user reported issues 1.22.0 02/10/2014 • Added support for landscape mode on iPad 1.21.0 11/07/2013 • updated for iOS 7
• new, intuitive file management 1.20.0 10/04/2013 • Correlation analysis now includes bivariate linear regression
• Cross-tab analysis names key statistics (chi squared, phi, cramer's v) in plain language instead of greek symbols 1.19.0 08/29/2013 • Added suggested values to filter interface based on the known values of the variable you're filtering on. 1.18.0 08/13/2013