Data analysis is a process of inspecting, cleaning, transforming, and modelling data with the goal of highlighting useful information, suggesting conclusions, and supporting decision making. Data analysis has multiple facets and approaches, encompassing diverse techniques under a variety of names, in different business, science, and social science domains.

Data mining is a particular data analysis technique that focuses on modeling and knowledge discovery for predictive rather than purely descriptive purposes. Business intelligence covers data analysis that relies heavily on aggregation, focusing on business information. In statistical applications, some people divide data analysis into descriptive statistics, exploratory data analysis, and confirmatory data analysis. EDA focuses on discovering new features in the data and CDA on confirming or falsifying existing hypotheses. Predictive analytics focuses on application of statistical or structural models for predictive forecasting or classification, while text analytics applies statistical, linguistic, and structural techniques to extract and classify information from textual sources, a species of unstructured data. All are varieties of data analysis.

Data integration is a precursor to data analysis, and data analysis is closely linked to data visualization and data dissemination. The term data analysis is sometimes used as a synonym for data modeling, which is unrelated to the subject of this article.

Contents 1 Nuclear and particle physics 2 Qualitative data analysis 3 The process of data analysis 4 Data cleaning 5 Initial data analysis 5.1 1) What is the quality of the data? 5.2 2) What is the quality of the measurements? 5.3 >>Initial transformations<< 5.4 3) Did the implementation of the study fulfill the intentions of the research design? 5.5 4) What are the characteristics of the data sample? 5.6 >>Final stage of the initial data analysis<< 5.7 >>Analyses<< 6 Main data analysis 7 Final data analysis 8 Free software for data analysis 9 See also 10 References 11 Further reading

[edit] Nuclear and particle physics

In nuclear and particle physics the data usually originate from the experimental apparatus via a data acquisition system. It is then processed, in a step usually called data reduction, to apply calibrations and to extract physically significant information. Data reduction is most often, especially in large particle physics experiments, an automatic, batch-mode operation carried out by software written ad-hoc. The resulting data n-tuples are then scrutinized by the high physicists, using specialized software tools like ROOT or PAW, comparing the results of the experiment with theory.

The theoretical models are often difficult to compare directly with the results of the experiments, so they are used instead as input for Monte Carlo simulation software like Geant4, predict the response of the detector to a given theoretical event, producing simulated events which are then compared to experimental data.

See also: Computational physics. 3

[edit] Qualitative data analysis

Qualitative research uses qualitative data analysis (QDA) to analyze text, interview transcripts, photographs, art, field notes of (ethnographic) observations, et cetera.

[edit] The process of data analysis

Data analysis is a process, within which several phases can be distinguished:^[1]

• Data cleaning
• Initial data analysis (assessment of data quality)
• Main data analysis (answer the original research question)
• Final data analysis (necessary additional analyses and report)

[edit] Data cleaning

Data cleaning is an important procedure during which the data are inspected, and erroneous data are -if necessary, preferable, and possible- corrected. Data cleaning can be done during the stage of data entry. If this is done, it is important that no subjective decisions are made. The guiding principle provided by Adèr (ref) is: during subsequent manipulations of the data, information should always be cumulatively retrievable. In other words, it should always be possible to undo any data set alterations. Therefore, it is important not to throw information away at any stage in the data cleaning phase. All information should be saved (i.e., when altering variables, both the original values and the new values should be kept, either in a duplicate dataset or under a different variable name), and all alterations to the data set should carefully and clearly documented, for instance in a syntax or a log.^[2]

[edit] Initial data analysis

The most important distinction between the initial data analysis phase and the main analysis phase, is that during initial data analysis one refrains from any analysis that are aimed at answering the original research question. The initial data analysis phase is guided by the following four questions:^[3]

[edit] 1) What is the quality of the data?

The quality of the data should be checked as early as possible. Data quality can be assessed in several ways, using different types of analyses: frequency counts, descriptive statistics (mean, standard deviation, median), normality (skewness, kurtosis, frequency histograms, normal probability plots), associations (correlations, scatter plots).
Other initial data quality checks are:

• Checks on data cleaning: have decisions influenced the distribution of the variables? The distribution of the variables before data cleaning is compared to the distribution of the variables after data cleaning to see whether data cleaning has had unwanted effects on the data.
• Analysis of missing observations: are there many missing values, and are the values missing at random? The missing observations in the data are analyzed to see whether more than 25% of the values are missing, whether they are missing at random (MAR), and whether some form of imputation (statistics) is needed.
• Analysis of extreme observations: outlying observations in the data are analyzed to see if they seem to disturb the distribution.
• Comparison and correction of differences in coding schemes: variables are compared with coding schemes of variables external to the data set, and possibly corrected if coding schemes are not comparable.

The choice of analyses to assess the data quality during the initial data analysis phase depends on the analyses that will be conducted in the main analysis phase.^[4]

[edit] 2) What is the quality of the measurements?

The quality of the measurement instruments should only be checked during the initial data analysis phase when this is not the focus or research question of the study. One should check whether structure of measurement instruments corresponds to structure reported in the literature.
There are two ways to assess measurement quality:

• Confirmatory factor analysis
• Analysis of homogeneity (internal consistency), which gives an indication of the reliability of a measurement instrument, i.e., whether all items fit into a unidimensional scale. During this analysis, one inspects the variances of the items and the scales, the Cronbach's α of the scales, and the change in the Cronbach's alpha when an item would be deleted from a scale.^[5]

[edit] >>Initial transformations<<

After assessing the quality of the data and of the measurements, one might decide to impute missing data, or to perform initial transformations of one or more variables, although this can also be done during the main analysis phase.^[6]
Possible transformations of variables are:^[7]

• Square root transformation (if the distribution differs moderately from normal)
• Log-transformation (if the distribution differs substantially from normal)
• Inverse transformation (if the distribution differs severely from normal)
• Make categorical (ordinal / dichotomous) (if the distribution differs severely from normal, and no transformations help)

[edit] 3) Did the implementation of the study fulfill the intentions of the research design?

One should check the success of the randomization procedure, for instance by checking whether background and substantive variables are equally distributed within and across groups.
If the study did not need and/or use a randomization procedure, one should check the success of the non-random sampling, for instance by checking whether all subgroups of the population of interest are represented in sample.
Other possible data distortions that should be checked are:

• dropout (this should be identified during the initial data analysis phase)
• Item nonresponse (whether this is random or not should be assessed during the initial data analysis phase)
• Treatment quality (using manipulation checks).^[8]

[edit] 4) What are the characteristics of the data sample?

In any report or article, the structure of the sample must be accurately described. It is especially important to exactly determine the structure of the sample (and specifically the size of the subgroups) when subgroup analyses will be performed during the main analysis phase.
The characteristics of the data sample can be assessed by looking at:

• Basic statistics of important variables
• Scatter plots
• Correlations
• Cross-tabulations^[9]

[edit] >>Final stage of the initial data analysis<<

During the final stage, the findings of the initial data analysis are documented, and necessary, preferable, and possible corrective actions are taken.
Also, the original plan for the main data analyses can and should be specified in more detail and/or rewritten.
In order to do this, several decisions about the main data analyses can and should be made:

• In the case of non-normals: should one transform variables; make variables categorical (ordinal/dichotomous); adapt the analysis method?
• In the case of missing data: should one neglect or impute the missing data; which imputation technique should be used?
• In the case of outliers: should one use robust analysis techniques?
• In case items do not fit the scale: should one adapt the measurement instrument by omitting items, or rather ensure comparability with other (uses of the) measurement instrument(s)?
• In the case of (too) small subgroups: should one drop the hypothesis about inter-group differences, or use small sample techniques, like exact tests or bootstrapping?
• In case the randomization procedure seems to be defective: can and should one calculate propensity scores and include them as covariates in the main analyses?^[10]
  

[edit] >>Analyses<<

Several analyses can be used during the initial data analysis phase:^[11]

• Univariate statistics
• Bivariate associations (correlations)
• Graphical techniques (scatter plots)
  

It is important to take the measurement levels of the variables into account for the analyses, as special statistical techniques are available for each level:^[12]

• Nominal and ordinal variables
  
  • Frequency counts (numbers and percentages)
  • Associations
    • circumambulations (crosstabulations)
    • hierarchical loglinear analysis (restricted to a maximum of 8 variables)
    • loglinear analysis (to identify relevant/important variables and possible confounders)
  • Exact tests or bootstrapping (in case subgroups are small)
  • Computation of new variables

• Continuous variables
  
  • Distribution
    • Statistics (M, SD, variance, skewness, kurtosis)
    • Stem-and-leaf displays
    • Box plots

[edit] Main data analysis

[edit] Final data analysis

[edit] Free software for data analysis

• ROOT - C++ data analysis framework developed at CERN
• PAW - FORTRAN/C data analysis framework developed at CERN
• JHepWork - Java (multi-platform) data analysis framework developed at ANL
• Zeptoscope Basic - Interactive Java-based plotter developed at Nanomix.
• KNIME - the Konstanz Information Miner, a user friendly and comprehensive data analytics framework.

[edit] See also

Wikiversity has learning materials about Data analysis

[edit] References

• Adèr, H.J. (2008). Chapter 14: Phases and initial steps in data analysis. In H.J. Adèr & G.J. Mellenbergh (Eds.) (with contributions by D.J. Hand), Advising on Research Methods: A consultant's companion (pp. 333-356). Huizen, the Netherlands: Johannes van Kessel Publishing.
• Tabachnick, B.G. & Fidell, L.S. (2007). Chapter 4: Cleaning up your act. Screening data prior to analysis. In B.G. Tabachnick & L.S. Fidell (Eds.), Using Multivariate Statistics, Fifth Edition (pp. 60-116). Boston: Pearson Education, Inc. / Allyn and Bacon.

This article needs additional citations for verification. Please help improve this article by adding reliable references. Unsourced material may be challenged and removed. (December 2008)

[edit] Further reading

• Adèr, H.J. & Mellenbergh, G.J. (with contributions by D.J. Hand) (2008). Advising on Research Methods: A consultant's companion. Huizen, the Netherlands: Johannes van Kessel Publishing.
• ASTM International (2002). Manual on Presentation of Data and Control Chart Analysis, MNL 7A, ISBN 0803120931
• Godfrey, A. B., Juran's Quality Handbook, 1999, ISBN 007034003
• Lewis-Beck, Michael S., Data Analysis: an Introduction, Sage Publications Inc, 1995, ISBN 0803957726
• NIST/SEMATEK (2008) Handbook of Statistical Methods,
• Pyzdek, T, Quality Engineering Handbook, 2003, ISBN 0824746147
• Richard Veryard (1984). Pragmatic data analysis. Oxford : Blackwell Scientific Publications. ISBN 0632013117
• Tabachnick, B.G. & Fidell, L.S. (2007). Using Multivariate Statistics, Fifth Edition. Boston: Pearson Education, Inc. / Allyn and Bacon.