Analysts often need to fill in the blanks in order to make longer-term decisions, or just to model different scenarios by making credulous predictions. In this post, I share just one of such scenarios and demonstrate how to make predictions using both statistical formulas manually and Excel’s feature. Lastly, we’ll see the difference between the […]
I’ve seen many pretty risk assessment maps over time. The issue I see with most of them is that they’re more of an illustration than a method meaning, they’re customized visuals with manual graphics that don’t scale well for different projects. In the post, I’ll share my approach…it’s based on applying basic statistical concept, development […]
Using the same dataset, I’ve shown in my earlier blog: Scattered Data To A Butterfly, Or A Tornado! http://flyingsalmon.net/blog/?p=2194 on how to present similar information visually and add interactivity, in this post, I’ll show other ways to present the information visually and walk through the pros and cons of each. I won’t be using any […]
Every now and then I see in technical forums questions such as this: How do I find the most occurring word in my Word document? Or PDF document? Or Emails? etc. The question is a valid one if that’s something you’re curious about or need to find out in your professional role. In this blog, […]
Back in March 2020, I did some predictive modeling using simple math and Excel where I presented 3 scenarios: Likely, Best-case, Worst-case. You can read the original blog here: What-If Models (COVID-19): Results Let’s take a look at today’s latest data from WHO and compare my Model 1: Likely Scenario numbers. We’ll compare the USA […]
Another somber perspective of WHO’s official COVID-19 data released 4/16/2020:
Showing Corona virus cases and deaths across selected countries for March 1st, 2020 to April 14th, 2020.
GLOBAL VIEW INTERACTIVE CHARTS Data retrieved from official WHO daily publications and worldOmeter.
How close were my initial models? Let’s compare with today’s data. Take a look back on my educated-guess-but-not-official models that I created back in March 22, 2020: What-If Models (COVID-19): Results Today’s numbers for USA from WHO are (on 4/1/2020): # of confirmed cases (infected): 163,199 and confirmed deaths: 2,850 My four models were agnostic […]
Today, I present a web application with a list of selected movies (about 3,000 titles) I extracted using developer APIs from IMDB and OMDB databases using my Python app. After extraction in the app, I reshape the data according to my needs and then export programmatically to XLSX format (for Excel). Which is then wrapped […]