The binomial distribution explained with PythonThe binomial distribution is one of the most popular distributions in statistics. In order to understand the binomial distribution, it is…1d ago1d ago
Use Python to explain the normal distribution in simplistic termsI have been studying Python and statistics for a few years now, so I thought it would be a good idea to write a blog post on what I have…4d ago4d ago
What is the difference between NORM.DIST() and NORM.INV() in Excel?I have been studying business statistics, which has a heavy focus on Excel. The normal distribution is used quite extensively in…5d ago5d ago
Statistics interview question: What are descriptive measures of association?Although I have been studying statistics for a few years now, I have only just today hear the term descriptive measures of association…Jan 2Jan 2
Use Excel’s Data Analysis toolpak to create a pristine histogramA histogram is a graph that shows the frequency of numerical data using rectangles. The height of the rectangle (vertical axis) represents…Jan 21Jan 21
How to use XLOOKUP to find employee detailsIn my past blog posts I have discussed how to use VLOOKUP and HLOOKUP in Excel, which are older formulas. In this blog post I am going to…Jan 1Jan 1
How to use HLOOKUP in Excel to find precise valuesHLOOKUP is a powerful function in Excel used to search for a value in the first row of a table and return a value in the same column from a…Dec 31, 2024Dec 31, 2024
How to use VLOOKUP to search for approximate values in ExcelIn my last blog post, I discussed how to use VLOOKUP in Excel to find an exact match if a cell, which can be read here…Dec 31, 2024Dec 31, 2024
How to use VLOOKUP in Excel to search for exact valuesVLOOKUP is a powerful function in Excel used to search for a value in the first column of a table and return a value in the same row from a…Dec 31, 2024Dec 31, 2024
How to use a nested IF statement in ExcelI am currently studying a Business Statistics and Analysis course on Youtube that utilises Excel as the platform that it will use to carry…Dec 30, 2024Dec 30, 2024
