Show Menu
Cheatography

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.

Word

Styles
Format words, select them > Home > Styles > Create a Styles
Field codes
Alt-F9
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
Caption
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

Excel

averag­e(a­rray)
Mean
stdev.s­(a­rray)
Standard deviation
count(­array)
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
$A$1
Absolute cell address
$A1 or A$1
Partially absolute, partially relative cell address
A1
Relative cell address
IF()
=IF(B2­="Co­nta­ct",­1,I­F(B­2="P­ass­ive­"­,2,­IF(­B2=­"­Pro­jec­ted­"­,3)))
VLOOKUP()
=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)
=(1-T.D­IS­T(t­-st­ati­sti­c,d­f,T­RUE))*2
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)
Regression
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 .