Blog

  • 89 – Brief Break

    89 – Brief Break

    The time has come for me to make the decision of taking a brief break from writing blogs. As much as I enjoy writing about topics that I love, I’ve made the decision to take a break so that I can remain focused on the balance of life that I currently have: 2x jobs, a

    Read more

  • 88 – How to use Excel and Python to Match People into Groups

    In a previous post, I mentioned that I was responsible for tracking updates in timetables. This is somewhat of an extension of that post. I was thinking about what could happen to these groups of people after the grouping has been completed. What happens when you actually need to group people together. How do you

    Read more

  • 86 – Summing It All Up

    86 – Summing It All Up

    Are you actually the sum of your experiences? (Kant.)  Is there actually a zero-sum game when it comes to social interactions and longevity around relationships? Is your life actually the sum of all your choices? (Camus.) Even Aristotle said something to the effect of, ‘character is the sum of repeated actions.’ What he actually said

    Read more

  • 85 – Tracking my Weather Dashboard Activity Usage

    Homework Review How did you go with those polynomials from last week? Here is what I came up with. 4th degree =ARRAYFORMULA(LINEST(dataset1!D2:D351,dataset1!B2:B351^{1,2,3,4},1,1)) We are now estimating this equation in the form: Final Exam Score = e + d(Pre-test Score) + c(Pre-test Score)2 + b(Pre-test Score)3 + a(Pre-test Score)4 Where, For this purpose, it suggests that:a

    Read more

  • 84 – How to Create Higher-Order Polynomial Regressions and Charts in Google Sheets

    In this previous post, I mentioned that I wanted to calculate the t-statistic and degrees of freedom for completeness sake, but for the case where I’m in the situation again needing to calculate them for another project. Although this post isn’t specifically about t-statistics or degrees of freedom, it is about the concept of documenting

    Read more

  • 83 – Is Speeding Worth Your Time?

    I want to start with a thought activity. I’m not asking you for your responses in the comments section below, but I am asking you to genuinely consider these questions and even write down your answers as you go. First question: Do you know your hourly wage? If so, feel free to write it down

    Read more

  • 82 – Applying Regression Discontinuity Design (RDD) in Google Sheets

    Introduction Regression Discontinuity Design (RDD) is a quasi-experimental pretest-posttest design that assigns a cutoff or threshold above or below where an intervention is assigned. It’s used to estimate the causal effect of interventions by comparing those just above and below the cutoff. If you’re familiar with the concept of a regression, then there’s only a

    Read more

  • 81 – Business Process Management Series: 4 Project Mapping (To-Be)

    This is the last instalment of the Business Process Management Series. The first in the series was an introduction to Business Process Management (BPM), outlining its principles, practices, and benefits. It illustrated how to map effective processes and improvements that can be made to efficiently organise businesses, increasing their strategic value. The second displayed some

    Read more

  • 80 – Business Process Management Series: 3 WASTE Management

    This post is the third in the series of the Business Process Management (BPM). In the last one, we created the As-Is model for the process that was provided about the business. This week is about breaking that process down, rearranging, and updating it to make it more efficient for the business. When you utilise

    Read more

Leave a comment