It turns out that normally distributed values are quite important in statistics. Not only because the pattern is remarkably common, the central limit theorem enables statisticians to infer conclusions about how a given treatment will affect a given population. To make such inferences, we need to learn about the Probability Density Function and a useful shortcut: the Z Table.

Continue reading

## Meetup Members Analysis

I recently started a group on Meetup.com for folks interested in computer programming. This was my first time doing so, and I had not worked out where the group would actually meet up. The first step to fining a meet-up spot was to look at the membership role and find where the individuals were located. I figured Python and the data analysis library Pandas could help me with this task.

Continue reading

## Group not Showing in SharePoint List

I recently had an issue working on a SharePoint list dealing with a User or Group column. When the list would initially load, the value for the column (i.e. the group name) was displayed but after a moment it would disappear. I found the solution by using JSON formatting to format the column values.

Continue reading

## Statistics – Standard Deviation

Most people are familiar with the concepts of the mean, median, and mode. They are measures of the central tendency of a value that has measured in a given population. They tell us, in different ways, about the value of an attribute at the heart of the population, rather than at the positive or negative extremes. Other measures are used to tell us about the variation within a population. One frequently used measure of variation is **standard deviation**.

Continue reading

## Introduction to NumPy

Lately, I’ve been studying statistics and data analysis. I have beforehand knowledge of the Python programming language, so when looking at the two most widely used programming tools applied in this domain, Pandas and R, I chose Pandas – a software library for Python. Pandas uses another library in the construction of it’s data structures (Series and DataFrames), called NumPy. This post goes over some of what can be done with NumPy.

Continue reading

## ag-Grid String Comparator

I’ve been using ag-Grid and it’s pretty great for representing tabular data. The goal of the ag-Grid team is to create “The Best HTML5 Grid in the World”, and I think they’ve done that. Anyways, just by setting an option in the the grid’s configuration (i.e. `gridOptions.enableSorting = true`

) you can make a grid (a.k.a. table) sorted by a column’s value. But the default sorting on strings is not quite what one would want – at least in many cases. For example, when there’s a space between words in a string or the capitalization is mixed the sorting doesn’t appear to be lexicographical.

Continue reading