Excel: Charts

Intuitively describing data patterns. When conducting statistical studies it is as important to present the results in an intuitive manner so users may understand and act on it as it is to conduct the study itself. In this article I will briefly describe the recommended uses for each method. Purpose Chart Type Displaying Trends Over…

Statistics: Variables – Measuring Values

Matching goals with variables. When designing a statistical study, it is important to understand and match your goals with each variable’s measurement type: nominal, ordinal, interval, and ratio. Each type contains distinct characteristics and provides differing benefits. Nominal Nominal variables are also qualitative which represent data usually assuming categorical values, such as a person’s ethnicity…

Excel: Averages

Describing Central Tendency of Data Descriptive statistics is concerned with describing important aspects of set of measurements, organizing and summarizing data. Here’s an example of descriptive statistics using the following dataset: There are 20 statistics classes at a university for which all the ages of the students in one class have been collected – a…

Statistics: Variables – Independent and Dependent

Understanding a Variable’s Function Variables, whether quantitative or qualitative, serve a specific function depending on the type of study being performed and it is important to understand each when designing the study. Independent Variable When designing the study, note those variables which are changing during the scenario, they are considered independent (IV). For example, if…

Statistics: Sampling Methods

Identifying the Best Method to Create a Sample As discussed in Population versus Sample, sampling provides a more cost and time-effective means of mining data versus attempting to gather an entire population. Building the sample requires deciding which sampling methods best suites your statistical needs: Simple Random Sampling: This represents the best method as it…