Semantic Excel: An Introduction to a User-Friendly Online Software Application for Statistical Analyses of Text Data

Semantic Excel (www.semanticexcel.com) is an online software application with a simple, yet powerful interface enabling users to perform statistical analyses on texts. The purpose of this software is to facilitate statistical testing based on words, rather than numbers. The software comes with semantic representations, or an ordered set of numbers describing the semantic similarity between words/texts that are generated from Latent Semantic Analysis. These semantic representations are based on large datasets from Google N-grams for a dozen of the most commonly used languages in the world. This small-by-big data approach enables users to conduct analyses of small data that is enhanced by semantic knowledge from big data. First, we describe the theoretical foundation of these representations. Then we show the practical steps involved in carrying out statistical calculation using these semantic representations in Semantic Excel. This includes calculation of semantic similarity scores (i.e., computing a score describing the semantic similarity between two words/texts), semantic t-tests (i.e., statistically test whether two sets of words/texts differ in meaning), semantic-numeric correlations (i.e., statistically examine the relationship between words/texts and a numeric variable) and semantic predictions (i.e., using statistically trained models to predict numerical values from words/texts).