Cheatography

# STATS779 Cheat Sheet (DRAFT) by felyne223

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 (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 .