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-reference |
Equation (Editor) |
Search > Insert Equation |
Equation (LaTex) |
Mathpix > paste latex to Word Equation Editor > Under Equation ribbon > Convert > Current - Professional |
Table of Contents |
Search > Table of Contents |
Excel
|
Mean |
|
Standard deviation |
|
Calculate sample size |
quantile.inc(array, quart)
|
quart = 0, 1, 2, 3, 4, 5. Min, 25th, 50th, 75th, max |
percentile.inc(array, k)
|
k = values between 0 to 1 inclusive |
|
Absolute cell address |
|
Partially absolute, partially relative cell address |
|
Relative cell address |
|
=IF(B2="Contact",1,IF(B2="Passive",2,IF(B2="Projected",3))) |
|
=VLOOKUP(A2,$G$1:$H$7,2, FALSE) |
Pivot Table |
Search > Pivot chart |
Binomial probability (slider etc.) |
Worksheet 3 Exercise 3 |
Excel (Standard Statistical Distributions)
|
|
Excel (Data Analysis)
Data Analysis Add-In |
Data tab > Data Analysis |
Two sample t-test (t-statistic) |
Worksheet 2 Exercise 1 |
Two sample t-test (p-value) |
=(1-T.DIST(t-statistic,df,TRUE))*2 |
Two sample t-test (df) |
n - 1 |
Simulation to find mean, 2.5% and 97.5% quantile, probability y <=> value |
Worksheet 2 Exercise 3 |
Random number generation (Uniforms) |
Data tab > Data Analysis > Random Number Generation > Distribution = Uniform > OK |
Random number generation (Exponential) |
Generate Uniforms random number U first. Exponentials = -ln(1-U) |
Regression |
Worksheet 2 Exercise 4. Data tab > Data Analysis > Regression. |
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 > Bibliography Options > Insert Bibliography .
|