0 Members and 1 Guest are viewing this topic.
IntroductionThis Explorer allows to perform various statistical analyses and data mining operations in a very easy and intuitive way. As the name implies, this software aims at exploring data and getting quick insight of the order of magnitude of the observed objects. That's why it does focus on graphical representation and mouse driven operations, unlike the traditional statistical tools cluttered with numerous dialog boxes and lists with five decimal figures. You can, however, have the detailed numbers once your analysis is completed.Types of analysis Pie chart Bar chart Line chart Association diagram Word cloud Arc diagram Contingency table Multiple Correspondence analysis 3-variable graph Treemap Chi-2 tests Pearson' chi-square test Yates' chi-square test G-test Fisher's exact test Gini impurity Entropy Repartition curve Distribution curve Scatter plot Ternary plot Andrew's curves Survey plot 3D plot Correlations Autocorrelation plot Probability plot Tukey-lambda PPCC plot Lag plot General statistics Normality tests Shapiro-Wilk test Anderson-Darling test Lilliefors test D'Agostino test Anscombe test Omnibus test Jarque-Bera test Analysis of variance Bartlett's test F-test Levene test Brown Forsythe test Box's M test Student's T-test Welch T-test Hotelling's test Wilk's lambda Lawley-Hotelling trace Pillai trace Two-way anova Non-parametric tests Kolmogorov-Smirnov test Kruskal-Wallis test Jonckheere test Cochran Q test Durbin test Friedman test Mantel-Haenszel test Breslow-Day test Woolf test Principal components Canonical correlation analysis K-means K-medoids Fuzzy C-means Huen diagram Dendogram Radviz Discriminant analysis Regressions Linear regression Poisson regression Negative binomial regression Logistic regression Least angle regression Influence plot QQ plot Box plot Parallel coordinates Neural network (perceptron)Various file formats are accepted :Source File extension RemarksAccess mdb , accdb Access 2000 or higherARFF / KEEL * No comments at the beginning of the file.The first line must be @relationBigQuery * A config file with a content like this:BigQueryclient_secret:/full/path/to/my_private_key.jsonquery:select * from lookerdata:cdc.project_tycho_reports limit 1000timeout:60000dBase dbf Excel xlsx The names of the fields are expected at the top of the columnsJMP jmp JSON file * A JSON array of recordsLIMDEP / NLOGIT lpj MINITAB mtw MLwiN ws Uncompressed format onlyMongoDB * A config file with a content like this:mongodbhost:192.168.0.121:27017database:geocollection:countriesquery:{cont:{$eq:"EU"},pop:{$gt:50000000}}Mysql * A config file with a content like this:mysqlhost:192.168.0.2user:bobpassword:secretdatabase:testquery:select * from mytablePostgres * A config file with a content like this:postgreshost:192.168.0.2user:bobpassword:secretdatabase:testquery:select * from mytableor:postgresconnection:bob:secret@192.168.0.2/testquery:select * from mytableR rdb Binary format onlySAS sas7bdat Uncompressed format onlySPLUS sdd SPSS sav Uncompressed format onlySQL Server * A config file with a content like this:mssqlhost:192.168.0.121username:bobpassword:secretquery:select * from mytableStata dta Stata 8 or higherTabular file * The names of the fields are expected on the first lineBzip2 file bz2 The uncompressed file must be in one of the previous formatsGzip file gz The uncompressed file must be in one of the previous formatsWeb file * Contains the url of the data. The remote file must be in one of the previous formatsIf you click the clipboard button, the data must be in tabular form, with the name of the fields on the first line.