\documentclass[10pt,a4paper]{article}

% Packages
\usepackage{fancyhdr}           % For header and footer
\usepackage{multicol}           % Allows multicols in tables
\usepackage{tabularx}           % Intelligent column widths
\usepackage{tabulary}           % Used in header and footer
\usepackage{hhline}             % Border under tables
\usepackage{graphicx}           % For images
\usepackage{xcolor}             % For hex colours
%\usepackage[utf8x]{inputenc}    % For unicode character support
\usepackage[T1]{fontenc}        % Without this we get weird character replacements
\usepackage{colortbl}           % For coloured tables
\usepackage{setspace}           % For line height
\usepackage{lastpage}           % Needed for total page number
\usepackage{seqsplit}           % Splits long words.
%\usepackage{opensans}          % Can't make this work so far. Shame. Would be lovely.
\usepackage[normalem]{ulem}     % For underlining links
% Most of the following are not required for the majority
% of cheat sheets but are needed for some symbol support.
\usepackage{amsmath}            % Symbols
\usepackage{MnSymbol}           % Symbols
\usepackage{wasysym}            % Symbols
%\usepackage[english,german,french,spanish,italian]{babel}              % Languages

% Document Info
\author{felyne223}
\pdfinfo{
  /Title (stats779.pdf)
  /Creator (Cheatography)
  /Author (felyne223)
  /Subject (STATS779 Cheat Sheet)
}

% Lengths and widths
\addtolength{\textwidth}{6cm}
\addtolength{\textheight}{-1cm}
\addtolength{\hoffset}{-3cm}
\addtolength{\voffset}{-2cm}
\setlength{\tabcolsep}{0.2cm} % Space between columns
\setlength{\headsep}{-12pt} % Reduce space between header and content
\setlength{\headheight}{85pt} % If less, LaTeX automatically increases it
\renewcommand{\footrulewidth}{0pt} % Remove footer line
\renewcommand{\headrulewidth}{0pt} % Remove header line
\renewcommand{\seqinsert}{\ifmmode\allowbreak\else\-\fi} % Hyphens in seqsplit
% This two commands together give roughly
% the right line height in the tables
\renewcommand{\arraystretch}{1.3}
\onehalfspacing

% Commands
\newcommand{\SetRowColor}[1]{\noalign{\gdef\RowColorName{#1}}\rowcolor{\RowColorName}} % Shortcut for row colour
\newcommand{\mymulticolumn}[3]{\multicolumn{#1}{>{\columncolor{\RowColorName}}#2}{#3}} % For coloured multi-cols
\newcolumntype{x}[1]{>{\raggedright}p{#1}} % New column types for ragged-right paragraph columns
\newcommand{\tn}{\tabularnewline} % Required as custom column type in use

% Font and Colours
\definecolor{HeadBackground}{HTML}{333333}
\definecolor{FootBackground}{HTML}{666666}
\definecolor{TextColor}{HTML}{333333}
\definecolor{DarkBackground}{HTML}{45A31D}
\definecolor{LightBackground}{HTML}{F3F9F0}
\renewcommand{\familydefault}{\sfdefault}
\color{TextColor}

% Header and Footer
\pagestyle{fancy}
\fancyhead{} % Set header to blank
\fancyfoot{} % Set footer to blank
\fancyhead[L]{
\noindent
\begin{multicols}{3}
\begin{tabulary}{5.8cm}{C}
    \SetRowColor{DarkBackground}
    \vspace{-7pt}
    {\parbox{\dimexpr\textwidth-2\fboxsep\relax}{\noindent
        \hspace*{-6pt}\includegraphics[width=5.8cm]{/web/www.cheatography.com/public/images/cheatography_logo.pdf}}
    }
\end{tabulary}
\columnbreak
\begin{tabulary}{11cm}{L}
    \vspace{-2pt}\large{\bf{\textcolor{DarkBackground}{\textrm{STATS779 Cheat Sheet}}}} \\
    \normalsize{by \textcolor{DarkBackground}{felyne223} via \textcolor{DarkBackground}{\uline{cheatography.com/146361/cs/31645/}}}
\end{tabulary}
\end{multicols}}

\fancyfoot[L]{ \footnotesize
\noindent
\begin{multicols}{3}
\begin{tabulary}{5.8cm}{LL}
  \SetRowColor{FootBackground}
  \mymulticolumn{2}{p{5.377cm}}{\bf\textcolor{white}{Cheatographer}}  \\
  \vspace{-2pt}felyne223 \\
  \uline{cheatography.com/felyne223} \\
  \end{tabulary}
\vfill
\columnbreak
\begin{tabulary}{5.8cm}{L}
  \SetRowColor{FootBackground}
  \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Cheat Sheet}}  \\
   \vspace{-2pt}Not Yet Published.\\
   Updated 13th April, 2022.\\
   Page {\thepage} of \pageref{LastPage}.
\end{tabulary}
\vfill
\columnbreak
\begin{tabulary}{5.8cm}{L}
  \SetRowColor{FootBackground}
  \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Sponsor}}  \\
  \SetRowColor{white}
  \vspace{-5pt}
  %\includegraphics[width=48px,height=48px]{dave.jpeg}
  Measure your website readability!\\
  www.readability-score.com
\end{tabulary}
\end{multicols}}




\begin{document}
\raggedright
\raggedcolumns

% Set font size to small. Switch to any value
% from this page to resize cheat sheet text:
% www.emerson.emory.edu/services/latex/latex_169.html
\footnotesize % Small font.

\begin{multicols*}{2}

\begin{tabularx}{8.4cm}{x{2.888 cm} x{3.952 cm} p{0.76 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{3}{x{8.4cm}}{\bf\textcolor{white}{Word}}  \tn
% Row 0
\SetRowColor{LightBackground}
Styles & Format words, select them \textgreater{} Home \textgreater{} Styles \textgreater{} Create a Styles &  \tn 
% Row Count 3 (+ 3)
% Row 1
\SetRowColor{white}
Field codes & Alt-F9 &  \tn 
% Row Count 4 (+ 1)
% Row 2
\SetRowColor{LightBackground}
Header (Diff. first page) & Search \textgreater{} Header \& Footer \textgreater{} Tick 'Different First Page' &  \tn 
% Row Count 7 (+ 3)
% Row 3
\SetRowColor{white}
Footer (Date) & Search \textgreater{} Header \& Footer \textgreater{} Date \& Time &  \tn 
% Row Count 9 (+ 2)
% Row 4
\SetRowColor{LightBackground}
Footer (Page number) & Search \textgreater{} Header \& Footer \textgreater{} Page Number &  \tn 
% Row Count 11 (+ 2)
% Row 5
\SetRowColor{white}
Caption & Search \textgreater{} Insert Caption &  \tn 
% Row Count 13 (+ 2)
% Row 6
\SetRowColor{LightBackground}
Cross reference & Search \textgreater{} Insert Cross-reference &  \tn 
% Row Count 15 (+ 2)
% Row 7
\SetRowColor{white}
Equation (Editor) & Search \textgreater{} Insert Equation &  \tn 
% Row Count 17 (+ 2)
% Row 8
\SetRowColor{LightBackground}
Equation (LaTex) & Mathpix \textgreater{} paste latex to Word Equation Editor \textgreater{} Under Equation ribbon \textgreater{} Convert \textgreater{} Current - Professional &  \tn 
% Row Count 23 (+ 6)
% Row 9
\SetRowColor{white}
Table of Contents & Search \textgreater{} Table of Contents &  \tn 
% Row Count 25 (+ 2)
\hhline{>{\arrayrulecolor{DarkBackground}}---}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{3.68 cm} x{4.32 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{Excel}}  \tn
% Row 0
\SetRowColor{LightBackground}
`average(array)` & Mean \tn 
% Row Count 1 (+ 1)
% Row 1
\SetRowColor{white}
`stdev.s(array)` & Standard deviation \tn 
% Row Count 2 (+ 1)
% Row 2
\SetRowColor{LightBackground}
`count(array)` & Calculate sample size \tn 
% Row Count 3 (+ 1)
% Row 3
\SetRowColor{white}
\seqsplit{`quantile.inc(array}, quart)` & quart = 0, 1, 2, 3, 4, 5. Min, 25th, 50th, 75th, max \tn 
% Row Count 6 (+ 3)
% Row 4
\SetRowColor{LightBackground}
\seqsplit{`percentile.inc(array}, k)` & k = values between 0 to 1 inclusive \tn 
% Row Count 8 (+ 2)
% Row 5
\SetRowColor{white}
`\$A\$1` & Absolute cell address \tn 
% Row Count 9 (+ 1)
% Row 6
\SetRowColor{LightBackground}
`\$A1 or A\$1` & Partially absolute, partially relative cell address \tn 
% Row Count 12 (+ 3)
% Row 7
\SetRowColor{white}
`A1` & Relative cell address \tn 
% Row Count 13 (+ 1)
% Row 8
\SetRowColor{LightBackground}
`IF()` & =IF(B2="Contact",1,IF(B2="Passive",2,IF(B2="Projected",3))) \tn 
% Row Count 16 (+ 3)
% Row 9
\SetRowColor{white}
`VLOOKUP()` & =VLOOKUP(A2,\$G\$1:\$H\$7,2, FALSE) \tn 
% Row Count 18 (+ 2)
% Row 10
\SetRowColor{LightBackground}
Pivot Table & Search \textgreater{} Pivot chart \tn 
% Row Count 19 (+ 1)
% Row 11
\SetRowColor{white}
Binomial probability (slider etc.) & Worksheet 3 Exercise 3 \tn 
% Row Count 21 (+ 2)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{Excel (Standard Statistical Distributions)}}  \tn
\SetRowColor{LightBackground}
\mymulticolumn{1}{p{8.4cm}}{\vspace{1px}\centerline{\includegraphics[width=5.1cm]{/web/www.cheatography.com/public/uploads/felyne223_1649764273_ExcelStandardStatsDistribution.png}}} \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{4 cm} x{4 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{Excel (Data Analysis)}}  \tn
% Row 0
\SetRowColor{LightBackground}
Data Analysis Add-In & Data tab \textgreater{} Data Analysis \tn 
% Row Count 2 (+ 2)
% Row 1
\SetRowColor{white}
Two sample t-test (t-statistic) & Worksheet 2 Exercise 1 \tn 
% Row Count 4 (+ 2)
% Row 2
\SetRowColor{LightBackground}
Two sample t-test (p-value) & \seqsplit{=(1-T.DIST(t-statistic},df,TRUE))*2 \tn 
% Row Count 6 (+ 2)
% Row 3
\SetRowColor{white}
Two sample t-test (df) & n - 1 \tn 
% Row Count 8 (+ 2)
% Row 4
\SetRowColor{LightBackground}
Simulation to find mean, 2.5\% and 97.5\% quantile, probability y \textless{}=\textgreater{} value & Worksheet 2 Exercise 3 \tn 
% Row Count 12 (+ 4)
% Row 5
\SetRowColor{white}
Random number generation (Uniforms) & Data tab \textgreater{} Data Analysis \textgreater{} Random Number Generation \textgreater{} Distribution = Uniform \textgreater{} OK \tn 
% Row Count 17 (+ 5)
% Row 6
\SetRowColor{LightBackground}
Random number generation (Exponential) & Generate Uniforms random number U first. Exponentials = -ln(1-U) \tn 
% Row Count 21 (+ 4)
% Row 7
\SetRowColor{white}
Regression & Worksheet 2 Exercise 4. Data tab \textgreater{} Data Analysis \textgreater{} Regression. \tn 
% Row Count 25 (+ 4)
% Row 8
\SetRowColor{LightBackground}
Rejection sampling & Week 2 Lecture Excel Part 2 slide 25 to 28 \tn 
% Row Count 28 (+ 3)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{4 cm} x{4 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{Library and References}}  \tn
% Row 0
\SetRowColor{LightBackground}
Databases example: Web of Science, Scopus & UoA Catalogue \textgreater{} DATABASES \textgreater{} Faculty = Science \tn 
% Row Count 3 (+ 3)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{8.4cm}}{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 \textgreater{} RefWorks \textgreater{} Insert Citation. Remember to 'Sync My Database' to sync citations. References can be inserted into Word via Word \textgreater{} RefWorks \textgreater{} Bibliography Options \textgreater{} Insert Bibliography .}  \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}


% That's all folks
\end{multicols*}

\end{document}