Data Sciencing Blog
Our Latest Posts
Data Sciencing Blog
All Posts
10 Awesome Excel Tips: Select All Cells in a Direction
Have you ever been in a situation, where you need to easily select all cells in a direction? One way to easily do this, is in the top right of your keyboard press the “End” key. On the bottom left hold down “Shift”. On the bottom right of your keyboard, press the down...
5 reasons Why Avoiding Survivorship Bias in Business Can Help you Achieve Results
What is your company doing to avoid the survivorship bias trap? I’ll give you a classic example of survivorship bias. You might recognize this picture if you’ve studied survivorship bias, statistics, or data visualization. In World War 2 the U.S. Military wanted to...
10 Awesome Excel Tips: Paste Transpose
Let’s say you want cells that are currently vertically in a column, horizontally in a row - let's learn how to use "paste transpose" to prepare the data in the desired format. One thing you can do is, select the relevant cells. Then copy them. Next select the cell you...
10 Awesome Excel Tips: Column and Row Width To the Rescue!
Has you ever opened an Excel file and noticed the column names are cut off and you can’t see all the information you want to look at? Adjusting column and row width is what you need! One thing you can do, to widen the column width is select the column. Then go on the...
Let’s Have Data Fun: the Monty Hall Problem
The Monty Hall problem is named after the original host of the game show Let's Make a Deal, Monty Hall. The problem is this: Let's pretend you're on a game show, and you're given the choice to pick one of three doors. Behind one door is a car (a winning prize)...
Let’s Have Data Fun: Analyzing the Impact of Buying a Competitor
Let's pretend you're on the board of directors for a company (ABC Corp in this example) and are looking into potentially acquiring a competitor company (XYZ Corp). You and the other board of directors want to understand the impact this acquisition could have on your...
Let’s Have Data Fun with Data Visualizations: Pie Charts
I was recently reading WinnipegREALTORS® excellent monthly report about the housing market of Winnipeg and its Metropolitan Region for April...
Let’s Have Data Fun with Data Visualizations: Presentations
Let's pretend you're a project manager or co-owner of a construction company. You have 4 table saws to cut your lumber. Then one of your table saws breaks beyond repair. You notice that this causes you to fall behind on your lumber requests. When you tell the other...
Let’s Have Data Fun with Excel: Find and Replace part 5
In today's blog we're going to further explore the "Find" function in Excel. Focusing on the "Options" features. Click here for part 1, here for part 2, here for part 3, and here for part 4 of the series. To access the "Options" features, open the...
Let's Start Something new
Say Hello!
Complete the form below and we'll be in touch.