Calculating 7 Descriptive Statistics in Google Sheets

Google Sheets can be used to calculate descriptive statistics for small data sets. However, with large data sets we recommend using statistical software made for analyzing large data sets, such as R, Tableau, SAS, STATA, SPSS, and other such software.

In the video below, we show how to calculate these seven descriptive statistics.

  1. Mean (Average)
  2. Median
  3. Mode
  4. Range
  5. Standard Deviation
  6. Coefficient of Variation
  7. Z-Score

In conclusion, Google Sheets can be used to quickly and conveniently calculate descriptive statistics like the seven discussed in this article when working with small data sets.

How to Add Filters in Tableau

Adding filters in Tableau helps you make your Tableau dashboards more useful. Filters allow you to display subsections of your data set in your dashboard. 

One way to add a filter is to use one worksheet that you have in the dashboard as a filter for the other worksheets. To do this, select the filter icon in the menu that appears to the right of the worksheet when you have that worksheet selected.

Another way is to go to the drop down menu to the right of the worksheet, hover over “Filters”, which then brings up a drop down menu in which you can select which of the variables in the worksheet you want to use to filter by.

The video below shows how to do both of these methods for adding filters  in less than 3 minutes.

As shown in the above video, adding filters to your Tableau dashboards can make your dashboards more useful and easier to display a selected subsection of your data set.

Data Sources for the data shown in this video:


5 Things to Consider When Planning a Survey

Planning out the details of how your organization will conduct a survey helps to make sure that conducting the survey is a good use of the organization’s time and resources and the results provide insight for answering the research question that was the reason for conducting the survey.

The video below briefly discusses 5 important factors to consider when planning a survey. 

As briefly discussed in the above video, 5 important things to consider are:

  1. Clearly defining what the research objectives are. Narrowing it down and getting specific about what it is that you want or need to know is important before conducting a survey.
  2. Verifying that conducting a survey is the best way to go about answering your research objectives. Once your research objectives are clearly defined you can decide if a survey and not another method, such as a focus group, an in-depth interview, a secondary data analysis, etc. is the best method to use.
  3. Deciding on or clarifying who is your target sample. Is there a certain demographic who’s opinion you want on this topic? For example, are you doing this survey as part of a community health assessment where you want a sample that’s representative of the population of the community or is it more narrow, such as if you’re conducting a customer satisfaction survey so you would want a sample of your customers to survey. Or do you only want a specific segment of those customers, such as those who purchased a particular product?
  4. Deciding on your desired sample size taking into account factors such as the response rate you would expect to get, statistics such as the sample size you would need if you want a 95% Confidence Interval, or a 90% Confidence Interval, and other related factors.
  5. Determining how you will conduct the survey based on the best way to reach your target sample to get them to complete the survey, the sample size you want, your organization’s budget and resources for conducting this survey, and other related factors.

Having a well planned out survey will ensure that your organization’s time and resources  used to conduct the survey will be put to good use and that the survey results will provide valuable insight into what it is you were trying to find out through using a survey as a research method. 

A few resources to get more information on planning a survey are: