Data visualisation

XLSTAT provide simple approaches to visualise your data within Excel with a few clicks.

The field of data and information visualization has emerged "from research in human–computer interaction, computer science, graphics, visual design, psychology, and business methods. It is increasingly applied as a critical component in scientific research, digital libraries, data mining, financial data analysis, market studies, manufacturing production control, and drug discovery". [1]

Data and information visualization presumes that "visual representations and interaction techniques take advantage of the human eye’s broad bandwidth pathway into the mind to allow users to see, explore, and understand large amounts of information at once. Information visualization focused on the creation of approaches for conveying abstract information in intuitive ways." [1]

Data analysis is an indispensable part of all applied research and problem solving in industry. The most fundamental data analysis approaches are visualization (histograms, scatter plots, surface plots, tree maps, parallel coordinate plots, etc.), statistics (hypothesis test, regression, PCA, etc.), data mining (association mining, etc.), and machine learning methods (clustering, classification, decision trees, etc.). Among these approaches, information visualization, or visual data analysis, is the most reliant on the cognitive skills of human analysts, and allows the discovery of unstructured actionable insights that are limited only by human imagination and creativity. The analyst does not have to learn any sophisticated methods to be able to interpret the visualizations of the data. Information visualization is also a hypothesis generation scheme, which can be, and is typically followed by more analytical or formal analysis, such as statistical hypothesis testing. [1]

Examples of data visualisation capability by XLSTAT:

Data visualisation solutions by XLSTAT

Univariate plots

Histograms

Probability plots

Scatter plots

Radar charts

Motion charts

Bar chart race

Parallel coordinates plots

Ternary diagrams

2D plots for crosstabs

Error bars

Semantic differential charts

Word cloud

Bar charts with images

Truncated bar chart

Plot a function

AxesZoomer

EasyLabels

Reposition labels

EasyPoints

Colors, thickness and size

Orthonormal plot

Resize a chart

Plot transformation

Merge charts

Zenplot

References

[1] https://en.wikipedia.org/wiki/Data_and_information_visualization