Show Menu

STATS779 Cheat Sheet (DRAFT) by

A cheatsheet for university course. Commands for Word, Excel, R.

This is a draft cheat sheet. It is a work in progress and is not finished yet.


Format words, select them > Home > Styles > Create a Styles
Field codes
Header (Diff. first page)
Search > Header & Footer > Tick 'Different First Page'
Footer (Date)
Search > Header & Footer > Date & Time
Footer (Page number)
Search > Header & Footer > Page Number
Search > Insert Caption
Cross reference
Search > Insert Cross-­ref­erence
Equation (Editor)
Search > Insert Equation
Equation (LaTex)
Mathpix > paste latex to Word Equation Editor > Under Equation ribbon > Convert > Current - Profes­sional
Table of Contents
Search > Table of Contents


Standard deviation
Calculate sample size
quanti­le.i­nc­(array, quart)
quart = 0, 1, 2, 3, 4, 5. Min, 25th, 50th, 75th, max
percen­til­e.i­nc(­array, k)
k = values between 0 to 1 inclusive
Absolute cell address
$A1 or A$1
Partially absolute, partially relative cell address
Relative cell address
=VLOOK­UP(­A2,­$G$­1:$­H$7,2, FALSE)
Pivot Table
Search > Pivot chart
Binomial probab­ility (slider etc.)
Worksheet 3 Exercise 3

Excel (Standard Statis­tical Distri­but­ions)


Excel (Data Analysis)

Data Analysis Add-In
Data tab > Data Analysis
Two sample t-test (t-sta­tistic)
Worksheet 2 Exercise 1
Two sample t-test (p-value)
Two sample t-test (df)
n - 1
Simulation to find mean, 2.5% and 97.5% quantile, probab­ility y <=> value
Worksheet 2 Exercise 3
Random number generation (Uniforms)
Data tab > Data Analysis > Random Number Generation > Distri­bution = Uniform > OK
Random number generation (Expon­ential)
Generate Uniforms random number U first. Expone­ntials = -ln(1-U)
Worksheet 2 Exercise 4. Data tab > Data Analysis > Regres­sion.
Rejection sampling
Week 2 Lecture Excel Part 2 slide 25 to 28

Library and References

Databases example: Web of Science, Scopus
UoA Catalogue > DATABASES > Faculty = Science
To find articles according to specific author name, year, keywords, go to Databases like Web of Science and Scopus. Once found, find the article on UoA Catalogue, click into article and click 'REFWORKS' to save to RefWorks. Once done, in-text citation can be inserted into Word via Word > RefWorks > Insert Citation. Remember to 'Sync My Database' to sync citations. References can be inserted into Word via Word > RefWorks > Biblio­graphy Options > Insert Biblio­graphy .