# Code School for Kids Follow @mjmacarty

## Videos

Amortization Tables

Confidence Intervals

Correlation

Correlation Matrix

Correlation in Python

Correlation in R

Control Charts in SPSS

Data analysis in Python

Data analysis in R

Data Table Excel (One Way)

Data Table Excel (Two Way)

Descriptive Statistics in Excel

Descriptive Statistics in SPSS

Forecasting Moving Averages in Excel

Forecasting Weighted Moving Average & Exponential Smoothing in Excel

Forecasting - calculating Theil's U

Independent Samples t-test

Jupyter Support for R

Linear Programming Optimization

Linear Regression in SPSS

Monte Carlo

Monte Carlo with Python

NPV & IRR with Excel

Paired Samples t-test in Excel

Paired Samples t-test in Minitab

Paired Samples t-test in SPSS

Pandas DataFrames

Pandas rolling method

Pandas Stock Price Analysis

PMT Function

Pivot Tables in Excel

Python Number Game

Python Drawing Stars

Regression

Regression (visualization)

Scatter Plots

T.TEST function

Two-tail Hypothesis Test in R

vlookup tutorial

## Files

### Spreadsheet Documentation Tools (formula comment, etc.)

The link below is to an Excel Macro enabled workbook. This file contains Macros, and should generally be run as an Addin. Click the instructions link for a complete description of the contents and installation instructions.

Documentation Tools

Instructions

### Linear Programming Optimization

Two product mix

Portfolio Simulation

Stock Price Simulation

PCLN

### Scatter Plots & Correlation

Scatter & Correl with Excel

Correlation with Python

### Confidence Intervals

Confidence template

### Python Files

Number guessing game

It's full of stars!
(this version has some added logic so you can run the graphic as many times as you want)

Click on the link then copy and paste the code into a new file in idle. Save the file and run.

T.TEST Function