As the goal is to describe transportation preference per city, we select the column corresponding to the city in the Subsamples field. In the General tab, select the column corresponding to the mode of transportation in the Qualitative data field. The Descriptive Statistics dialog box appears.ģ. Once XLSTAT is open, select the XLSTAT / Describing data / Descriptive statistics command as shown below.Ģ. Setting up the dialog box for descriptive statistics of qualitative dataġ. This will allow us to extract the key figures of the survey and detect potential differences in the way people commute according to the two cities. The relative frequencies, which is the frequency divided by the total number of answers.īar charts and stacked bars, that graphically illustrate the relative frequencies by category. The frequencies, reflecting how many times each mode of commuting appears as an answer. The mode, reflecting the most frequent mode of commuting (the most frequent category). Our goal here is to describe transportation preferences when commuting to work per city using: The values a qualitative variable may take (Bicycle, Bus, Car… in the case of transportation mode) are called categories, or levels.
Here the city and the mode of commuting are qualitative variables, also referred to as nominal or categorical variables. Rows correspond to respondents and columns to the mode of transportation as well as to the city they live in. The data represent the results of a survey on how people living in two different cities commute to work. This tutorial illustrates frequencies and mode statistics as well as bar charts for qualitative data (also referred to as categorical or nominal data), in Excel using the XLSTAT software.
0 kommentar(er)
