Statistics with TSQL and R: Chi Square Test

As I move on from descriptive and  largely univariate (one variable based) analysis of data into more multivariate data – one...

Statistics with T-SQL and R – the Pearson’s Correlation Coefficient

In this post I will attempt to explore calculation of a very basic statistic based on linear relationship between two...

Script for creating test data for odds ratio

Make sure you have a working version of SQL Server 2016.
USE [master]

GO
/****** Object: Database [WorldHealth] ******/

CREATE DATABASE [WorldHealth]

CONTAINMENT = NONE

ON PRIMARY

(...

TSQL Tuesday #081 – Sharpening something

This TSQL tuesday is hosted by my good friend Jason Brimhall – Jason has put forth a creative challenge – plan to...

Descriptive Statistics with SQL and R – II

In the previous post I looked into some very basic and common measures of descriptive statistics – mean, median and mode,...

Script to create demo database and load data for statistics and R

Make sure you have a working install of SQL Server 2016. The size of the database is only 8 MB.
USE...

Descriptive Statistics with SQL and R – 1

I started my re-discovery of statistics with an introduction here. This second post is about descriptive statistics – very basic, simple...

Basic Statistics with SQL – Introduction

I was a student of statistics in school and college. I didn’t get to use much of anything I learned...

TSQL Tuesday #75 – PowerBI

This month’s TSQL Tuesday post is from one of my favorite people in the community – Jorge Segarra a.k.a. SQL Chicken. It...

Advent of Code – Day 2 – Using Cross apply

For this post i worked on second puzzle in the Adventofcode series. This wasn’t as challenging as the first one, but...