Data_Analyst_Internship_Task/Task_Description_ENG.tex at master · JuiceFV/Data_Analyst_Internship_Task · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
\documentclass[14pt, a4paper]{extarticle}
\usepackage[T1]{fontenc}
\usepackage[utf8]{inputenc}
\usepackage[left=25pt, right=25pt, bottom=33pt]{geometry}

\usepackage[english]{babel}
\usepackage{booktabs}
\usepackage{amsmath}
\usepackage{blindtext}
\usepackage{enumitem}
\usepackage{xcolor}
\usepackage{hyperref}
\hypersetup{
	colorlinks=true,
    linkcolor=blue,
    filecolor=magenta,
    urlcolor=cyan,
}


\title{\textcolor{blue}{The Tasks for Data Analyst Intership by Rambler Group}}
\date{03-13-2020}
\author{Aleksandr Kasian}

\begin{document}

\begin{titlepage}
	\maketitle
	\pagenumbering{gobble}
\end{titlepage}
\pagenumbering{arabic}
\newpage

\tableofcontents

\newpage

\section*{Description}
\addcontentsline{toc}{section}{\protect\numberline{}Description}%
The tasks in the following document were represented by Rambler Group to the role "the Data Analyst Internship".

\section*{Problem 1}
\addcontentsline{toc}{section}{\protect\numberline{}Problem 1}%
Rambler Group's advertising campaign uses most fascinating and most memorable banners.
Analytics have access to the databases containing data regard the banner' showing.
The \textbf{Shows\_table} contains:
\begin{itemize}
	\item \emph{show\_id} - an identifier of a showing
	\item \emph{day} - a day of a showig
\end{itemize}

\begin{table}[h]
	\begin{tabular}{|l|l|}
	\hline
	show\_id & day        \\ \hline
	12367    & 2018-10-04 \\ \hline
	28736    & 2019-02-22 \\ \hline
	19862    & 2019-01-31 \\ \hline
	\end{tabular}
\end{table}

\noindent
The \textbf{Click\_table} contains:
\begin{itemize}
	\item \emph{click\_id} - a show identifier clicked by an user
	\item \emph{bounce} - an user dismissing from an advertising after click (0 - when an user relinked to the site
	he keened in the information on the site. 1 - an user immediatly left the site.)
\end{itemize}

\begin{table}[h]
	\begin{tabular}{|l|l|}
		\hline
		click\_id & bounce	\\ \hline
		12367 	  & 1       \\ \hline
		15627 	  & 0       \\ \hline
		28735     & 0		\\ \hline
	\end{tabular}
\end{table}

\noindent
You need to get all users who clicked at a banner in February 2020, and
they din't reject an advertising.

\newpage

\section*{Problem 2}
\addcontentsline{toc}{section}{\protect\numberline{}Problem 2}%

The friendly Rambler Group's community likes to play in the table football:
At the odd days they play before lunch, at the even days the play after lunch.
They are splitting at the N teams among each other, and every team plays with each another team.
Because of the splitting onto the teams is randomly, the product of the games is random.
Also I would note that there are no ties. Only win or lose.
\begin{enumerate}
	\item Estimate the probability if one of the teams will finish the tournament without defeat.
	\item How many times do you need to hold a tournament, so that with a probability of 98\% at least once this happened?
\end{enumerate}
\end{document}