Aaron Schlegel Homepage
The site of Aaron Schlegel focusing on Excel, data analysis, Python, R, and things of that nature.
Excel, data, analysis, Python, R, automation, mathematics
21413
home,page-template,page-template-full_width,page-template-full_width-php,page,page-id-21413,,select-theme-ver-3.8.1,wpb-js-composer js-comp-ver-4.11.2,vc_responsive
hipster-16_1920x1280

Welcome!

My name is Aaron Schlegel and I love data, automation and statistics.

About Me

My name is Aaron Schlegel and I love solving problems through data, learning as much as possible, and creating tools and processes that help people do their work better. I’m gold in some trades, silver in others, including data analysis, web development and programming. I eat Excel, Python, VBA, HTML/CSS, and Adobe products as part of a balanced breakfast with R on the side. I seek the unbiased truth buried in data sets and think psychohistory is one of the coolest ideas in fiction ever created.

Self-education is, I firmly believe, the only kind of education there is.
- Isaac Asimov

My Primary Skills


Excel

6 Years Experience

VBA

4.5 Years Experience

Python

3 Years Experience

Tableau

3 Years Experience

R

2.5 Years Experience


Secondary Skills

Powerpoint0

Photoshop0

Wordpress0

HTML/CSS0

Illustrator0

PHP0

Javascript0

Tertiary Skills

Atlas Ad Server0

DoubleClick for Advertisers0

Notebook

Writing, to me, is simply thinking through my fingertips. - Isaac Asimov

  • Mathpy 0.3.0 Released!

    I am excited to announce the release of mathpy 0.3.0! This release adds a ton of Excel UDFs including many new statistical and number-theoretic functions, several random number generators and functions for drawing random samples from continuous and discrete probability distributions, and more! More information can be found on the......

  • Combined Linear Congruential Generators with R

    Combined linear congruential generators, as the name implies, are a type of PRNG (pseudorandom number generator) that combine two or more LCGs (linear congruential generators). The combination of two or more LCGs into one random number generator can result in a marked increase in the period length of the generator......

  • Multiplicative Congruential Generators in R

    Multiplicative congruential generators, also known as Lehmer random number generators, is a type of linear congruential generator for generating pseudorandom numbers in . The multiplicative congruential generator, often abbreviated as MLCG or MCG, is defined as a recurrence relation similar to the LCG with . Unlike the LCG, the parameters......

  • Mathpy 0.2.0 Released!

    My Python library, mathpy, a collection of mathematical and statistical functions with Excel integration, has a new release! Version 0.2.0 introduces a ton of additional mathematical and statistical functions have been added in this release along with a large effort centered on documentation and testing. Installing the package is easily......

  • Linear Congruential Generator in R

    A Linear congruential generator (LCG) is a class of pseudorandom number generator (PRNG) algorithms used for generating sequences of random-like numbers. The generation of random numbers plays a large role in many applications ranging from cryptography to Monte Carlo methods. Linear congruential generators are one of the oldest and most......

  • Simpson’s Rule for Approximating Definite Integrals in R

    Simpson’s rule is another closed Newton-Cotes formula for approximating integrals over an interval with equally spaced nodes. Unlike the trapezoidal rule, which employs straight lines to approximate a definite integral, Simpson’s rule uses the third Lagrange polynomial, to approximate the definite integral and as such can give exact results when......

Some Things I’ve Done