ab-logo

Code School for Kids


Resource Links

Videos

Amortization Tables

Command Line Top 10

Command Line Essentials

Confidence Intervals

Correlation

Correlation Matrix

Correlation in Python

Correlation in R

Control Charts in SPSS

CSV Tutorial: Open and Read Files in Python

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 Programming Transportation Problem

Linear Regression in SPSS

Monte Carlo

Monte Carlo with Python

Monte Carlo with Palisades @Risk

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 Datareader fix_yahoo_finance!

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

Monte Carlo Simulation Spreadsheets

Portfolio Simulation

Stock Price Simulation

Stock Price Analysis Spreadsheet

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

T.TEST Function