Search This Blog

Tuesday, November 24, 2020

Google Sheets - Create a Gauge or Speedometer Chart

Gauge charts aka Speedometer charts are one of those fancy looking charts that try to represent a metric with the car dashboard analogy. This dashboard analogy is good in small doses because it's preferable to have something similar to a basic car dashboard as opposed to airplane cockpit dashboard. Thankfully creating a gauge chart in Google Sheets is fairly straight forward and easy to do. So buckle up and check out the video.

Wednesday, November 18, 2020

Google Sheets - Create a Dynamic Dropdown List

Want to learn how to create a dynamic drop down list in Google Sheets? It happens when you click a small drop down arrow in the cell and it shows you a list of choices. Then after the first selection from that drop down list will help filter another drop down list for another set of options to choose from. This is pretty easy to do by involving the named ranges, the data validation feature and the INDIRECT function.

Monday, November 16, 2020

Perform a Two Sample Test in Excel (paired t-test)

If you're testing a scenario that looks at a before and after situation AND wanted to know if there the result is based on random chance or NOT, you probably want to use a paired t test. Excel has some neat functions that give you the ability to do a paired or dependent t test easily. This video will show a quick way using the Data Analysis feature and then the various functions and formula to do it in a more manual (but challenging) way.