optimal_tariff

Preferred Tariff Choice

We act as an analyst of "Megaline" - federal mobile operator. Clients are offered two tariff plans: "Smart" and "Ultra". In order to adjust the advertising budget, the commercial department wants to understand which tariff brings in more money.

We will have to make a preliminary analysis of tariffs based on a small sample of customers. We have the data of 500 Megaline users at our disposal: who they are, where they come from, what tariff they use, how many calls and messages each sent in 2018. It is necessary to analyze the behavior of customers and conclude which tariff is better.

Objectives

1. Analyzing the behavior of "Megaline" company clients.
2. Identifying the most profitable tariff plan.

Project progress

We have data on "Megaline" customers stored in five different datasets of uncertain quality. We will need to look at the entire set of data and prepare it accordingly for the data analysis. Next, exploratory data analysis will be carried out where the profitability of each tariff plan will be computed and visualized. Lastly, statistical hypotheses will be tested in order to make final conclusions.

Thus, the data analysis will be conducted in four stages:

1. Data overview.
2. Data preparation.
3. Exploratory data analysis.
4. Statistical hypotheses testing.

Tariff plan description

"Smart"

1. Monthly subscription fee: 500 rubles.
2. 500 minutes of conversations, 50 messages and 15GB of internet traffic are included.
3. The cost of services in excess of the tariff package:

• A minute of conversation — 3 rubles. The number of minutes and megabytes used is always rounded up by Megaline. If the user spoke for only 1 second, the whole minute is counted in the tariff;
• Message - 3 rubles;
• 1GB of internet traffic - 200 rubles.

"Ultra"

1. Monthly subscription fee: 1950 rubles.
2. 3000 minutes of conversations, 1000 messages and 30GB of internet traffic are included.
3. The cost of services in excess of the tariff package:

• A minute of conversation - 1 ruble;
• Message - 1 ruble;
• 1GB of internet traffic - 150 rubles.

Datasets

1. Users' calls.
2. Users' internet sessions.
3. Messages sent by users.
4. Users themselves.
5. Tariff plans.