Search This Blog

Monday, August 24, 2020

Perform Quick Pareto Analysis in Excel


A Pareto analysis tries to find out what variable are responsible for the bulk of the outcomes. It's referred to as a Pareto Principle or the 80/20 rule. The concept can be expressed with the saying that 80 percent of the wealth is owned or created by 20 percent of the population. Though in real life data may not fit tightly in the 20 percent, the idea of Pareto is that a small number of variables have a disproportionate ownership or cause of an outcome. This video show how to quickly find out from your data what variables are responsible for the "80%" in your data using Excel.

Monday, August 17, 2020

How to Calculate Margin of Error in Excel

Ever see those polling results where it says "the average number of people think this with a margin of error of..." or " the percentage of people that think the president is doing a good job is this with a margin of error...."? This margin of error calculation is based on samples and some common statistical formulas....which you can do in Excel. Learn how...



Wednesday, August 12, 2020

Power Query - Importing Table in PDF to Excel


Importing a table from a PDF document into Excel can be a difficult process. You might have been doing a copy and paste and editing or deleting our strange characters, spaces or tabs. Whether it was a small table or large one, it's a time intensive process. If you've got the Microsoft 365 subscription (formerly Office 365 or O365), you might have the latest features from Power Query to help make this an easier process. If you don't have Power Query, it still can be done but with another Microsoft application - Word (see that video here at https://youtu.be/COUOvhbQ4CQ)