Apache License, v2.0https://www.apache.org/licenses/LICENSE-2.0
License information was derived automatically
You are an analyst at "Megaline," a federal mobile operator. The company offers two tariff plans to customers: "Smart" and "Ultra." To adjust the advertising budget, the commercial department wants to understand which tariff generates more revenue.
You need to conduct a preliminary analysis of the tariffs on a small sample of customers. You have data on 500 users of "Megaline": who they are, where they are from, which tariff they use, how many calls and messages they sent in 2018. You need to analyze customer behavior and conclude which tariff is better.
"Smart" Tariff: - Monthly fee: 550 rubles - Included: 500 minutes of calls, 50 messages, and 15 GB of internet traffic - Cost of services beyond the tariff package: 1. Call minute: 3 rubles (Megaline always rounds up minutes and megabytes. If the user talked for just 1 second, it counts as a whole minute); 2. Message: 3 rubles; 3. 1 GB of internet traffic: 200 rubles.
"Ultra" Tariff: - Monthly fee: 1950 rubles - Included: 3000 minutes of calls, 1000 messages, and 30 GB of internet traffic - Cost of services beyond the tariff package: 1. Call minute: 1 ruble; 2. Message: 1 ruble; 3. 1 GB of internet traffic: 150 rubles.
Note: Megaline always rounds up seconds to minutes and megabytes to gigabytes. Each call is rounded up individually: even if it lasted just 1 second, it is counted as 1 minute. For web traffic, separate sessions are not counted. Instead, the total amount for the month is rounded up. If a subscriber uses 1025 megabytes in a month, they are charged for 2 gigabytes.
Step 1: Open the file with data and study the general information
File paths:
- /datasets/calls.csv
- /datasets/internet.csv
- /datasets/messages.csv
- /datasets/tariffs.csv
- /datasets/users.csv
Step 2: Prepare the data - Convert data to the required types; - Find and fix errors in the data, if any. Explain what errors you found and how you fixed them. You will find calls with zero duration in the data. This is not an error: missed calls are indicated by zeros, so they do not need to be deleted.
For each user, calculate: - Number of calls made and minutes spent per month; - Number of messages sent per month; - Amount of internet traffic used per month; - Monthly revenue from each user (subtract the free limit from the total number of calls, messages, and internet traffic; multiply the remainder by the value from the tariff plan; add the corresponding tariff plan's subscription fee).
Step 3: Analyze the data Describe the behavior of the operator's customers based on the sample. How many minutes of calls, how many messages, and how much internet traffic do users of each tariff need per month? Calculate the average, variance, and standard deviation. Create histograms. Describe the distributions.
Step 4: Test hypotheses - The average revenue of users of the "Ultra" and "Smart" tariffs is different; - The average revenue of users from Moscow differs from the revenue of users from other regions. Moscow is written as 'Москва'. You can put it in your value, when check the hypothesis
Set the threshold alpha value yourself.
Explain: - How you formulated the null and alternative hypotheses; - Which criterion you used to test the hypotheses and why.
Step 5: Write a general conclusion
Formatting: Perform the task in Jupyter Notebook. Fill the program code in the cells of type code
, and the textual explanations in the cells of type markdown
. Apply formatting and headers.
Table users
(user information):
- user_id
: unique user identifier
- first_name
: user's first name
- last_name
: user's last name
- age
: user's age (years)
- reg_date
: date of tariff connection (day, month, year)
- churn_date
: date of tariff discontinuation (if the value is missing, the tariff was still active at the time of data extraction)
- city
: user's city of residence
- tariff
: name of the tariff plan
Table calls
(call information):
- id
: unique call number
- call_date
: call date
- duration
: call duration in minutes
- user_id
: identifier of the user who made the call
Table messages
(message information):
- id
: unique message number
- message_date
: message date
- user_id
: identifier of the user who sent the message
Table internet
(internet session information):
- id
: unique session number
- mb_used
: amount of internet traffic used during the session (in megabytes)
- session_date
: internet session date
- user_id
: user identifier
Table tariffs
(tariff information):
- tariff_name
: tariff name
- rub_monthly_fee
: monthly subscription fee in rubles
- minutes_included
: number of call minutes included per month
- `messages_included...
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
Onsemi projects strong Q2 revenue, driven by demand for EV chips, overcoming tariff challenges.
https://www.cognitivemarketresearch.com/privacy-policyhttps://www.cognitivemarketresearch.com/privacy-policy
Global Bulk Carrier Ships market size was $374.24 Billion in 2022 and it is forecasted to reach $412.36 Billion by 2030. Bulk Carrier Ships Industry's Compound Annual Growth Rate will be 4.4% from 2023 to 2030. Factors Impacting on Bulk Carrier Ships Market
Rise in international trading
Trading and transportation across the borders have dramatically increased over the past few decades. Moreover, recent couple of decades have seen mounted growth in world economy. This trade growth is an ultimate result of both technological advancements and reduction in trade barriers. Almost every country is aggressively promoting economic development which is driving world trade to significantly grow every year with an average growth of 6%. International trade allows countries to expand their markets by providing goods and services to other countries. It thus allows countries to extend their markets and get access to items and services that are otherwise be unavailable in their home country. International commerce also leads to the increasing competitiveness. This integration thus helps in raising living standards across the world. Import, export, and entrepot activities are used in international trade. Currently, technological innovation, increased need for a variety of items, and rising desire for authentic products are all driving up international commercial activity. Bulk carrier ships play vital role in supply chain by carrying cargo across oceans linking borders across the globe. It is one of the most cost-effective ways to transfer large amounts of commodities throughout the world. Shipping and seaborne trade have enabled the transition from a world of separated territories to a globally linked community. Hence surging international trade drives the growth of bulk carrier’s market across the globe.
Restraining Factor of Bulk Carrier Ships market
Volatility in transportation cost and tensions in trade across borders may hamper the growth of market Volatility in the prices of fuels impacts pricing of the goods. Further, in case of global rise in the tariffs, high import prices hamper firm's production costs as well as purchasing power of customers. Further, stringent regulations, such as tracking orders, meeting promised timeline, determining liabilities, etc. associated with shipping goods across borders may hinder the growth of market. Moreover, unstable political parameters of any particular country also hamper the cargo shipping market. For instance, Russia-Ukraine war has impacted the shipping industry owing to the rise in the oil prices. Furthermore, ongoing U.S.-China tariff stand-off is also threatening trading across the borders. Hence, geopolitical crisis somehow hinders the growth of bulk carriers ships market.
Current Trends on Bulk Carrier Ships
Technological Improvement
Demand for coal, ores and cement has increased owing to the liberalization in global trade. This demand will keep on increasing and to meet the growing demand, developments have been made to offer solutions that can enable reduction in the transportation cost. Moreover, rise in the environment concern is aiming to reduce the impact of CO2 emissions from ships on marine culture by reducing the fuel consumption. Hence, new regulations have made in designing smaller ship size bulk carrier ship with engines meeting the demand for lower rpm in order to obtain an optimum ship design with highly efficient large propellers.
What is the impact of COVID-19 pandemic on Bulk Carrier Ships Market?
Advent of COVID-19 in year 2020 has plunged international trade due to the reduction in production and distribution of goods. Initial period of pandemic has resulted in the double-digit decline of revenue from bulk carrier ship market. However, the second half of pandemic global trade started recovering at relatively faster pace facilitating a V-shaped graph. What are Bulk Carrier Ships?
Carrier ships are the integral link between the production and its consumption all across the globe. It thus plays very crucial part in connecting global economy. It has been estimated that almost 80% of global goods gets transported across oceans via ships. Though air freight is less time consuming, but the cost associated with it is too high in comparison to carrier ships. Further, carrier shipping allows heavy loads, as well as hazardous materials which brings flexibility in tra...
Green electricity tariffs in the United Kingdom generated nearly ************ British pounds in 2020. This was nearly double the amount brought in the previous year and a result of greater clean energy awareness among consumers.
https://www.ibisworld.com/about/termsofuse/https://www.ibisworld.com/about/termsofuse/
Electricity suppliers are responsible for delivering electricity to consumers, forming the final phase of the electricity supply chain. After it was opened to competition in 2005, the electricity supply market has displayed notable change in recent years, with efforts to promote competition threatening the market share of Ireland’s energy giants. At an industry level, Ireland’s energy efficiency drive has weighed on household electricity consumption, though growing demand from large energy users (LEUs) has maintained strong underlying electricity consumption. Electricity suppliers’ revenue is forecast to increase at a compound annual rate of 7.8% over the five years through 2025 to reach €7.3 billion. Following a decline during the pandemic, a rebound in global demand for fuels like oil and natural gas caused wholesale electricity prices to surge in 2021, leaving suppliers scrambling to increase tariffs. Russia’s invasion of Ukraine spurred a renewed rise in wholesale electricity prices in 2022, leading to widespread double-digit tariff increases throughout the year. Such price hikes caused a jump in revenue, though this wasn’t enough to offset the impact of wholesale price increases, with the industry operating at a loss over the two years through 2022. Wholesale electricity prices eased in 2023, though tariffs continued to edge up, facilitating a return to profitability. Further reductions in wholesale prices led to widespread tariff drops in 2024, though prices and revenue remained above pre-2022 levels. Ongoing volatility in global energy markets and increased network charges are set to limit the scope for tariff reductions in 2025. Still, revenue is forecast to fall by 6.5% during the year thanks to the impact of 2024 tariff reductions. Revenue is forecast to inch down at a compound annual rate of 1.7% over the five years through 2030 to €6.7 billion. Prices are likely to remain volatile in the medium term, owing to ongoing conflicts in the Middle East and Ukraine. Fuelled by a continued rise in electricity consumption from data centres, growing demand from LEUs should keep Ireland's energy giants on top of the market.
https://www.ibisworld.com/about/termsofuse/https://www.ibisworld.com/about/termsofuse/
The metal wholesaling industry has enjoyed gradual revenue growth over the past five years. Increasing demand from construction and manufacturing markets has played a substantial role. Consumption of metals like steel, copper and aluminum has consistently supported the upward trend. Enhancements in supply chain optimizations, such as real-time tracking systems and automation in warehousing, improved delivery efficiency. Radio-frequency identification (RFID) technology advanced inventory management by reducing errors and improving stock accuracy. Companies achieved cost efficiencies by implementing strategic purchasing practices, such as bulk buying and just-in-time inventory. The 2018 tariffs under Section 232 imposed a 25% tariff on steel imports and a 10% tariff on aluminum imports, prompting a shift toward domestic sourcing where possible. The second Trump administration also introduced a 145% tariff on Chinese imports in 2025, affecting various metals. Fluctuating raw material prices required adaptable procurement strategies. The industry adapted to meet these changes, ensuring steady growth amid external challenges. A deeper look into the past five years reveals that effective cost management was critical for sustaining growth. Companies reduced purchase and depreciation fees through optimized asset utilization and smart procurement solutions. The 2018 and 2025 tariffs increased import costs but motivated companies to enhance sourcing strategies by focusing more on domestic suppliers. Key downstream markets, such as automotive and infrastructure, maintained stable demand and sustained revenue flow. Technological investments in logistics, like predictive analytics and optimized route planning, reduce delivery times and enhance efficiency. Compliance with environmental regulations, like the Clean Air Act, necessitated operational adjustments in waste management and emissions control. Commodity pricing strategies were adjusted to reflect real-time shifts in market conditions. Financial strategies focused on maintaining liquidity and managing debts efficiently. These actions allowed the industry to retain resilience and achieve a consistent upward trajectory. Metal Wholesaling industry revenue has been inching upward at a CAGR of 0.4% over the past five years and is expected to total $286.2 billion in 2025, when revenue will fall by an estimated 2.0%. Profit has risen because of a slight drop in purchase and depreciation fees. Over the next five years, technological innovation will significantly shape industry dynamics. Advanced inventory systems leveraging AI will boost stock forecasting accuracy, minimizing overstock and stockouts. Predictive analytics will streamline supply chain operations, enhancing response to demand fluctuations. New environmental regulations, such as stricter emissions limits under potential amendments to the Clean Air Act, could impact processing practices. Current tariffs, including the 25% on all steel and aluminum imports and 20% on Chinese imports, will continue to influence sourcing strategies and cost structures. Increased interest in electric vehicles and renewable energy will drive demand for specialty metals, offering new growth avenues. Companies will focus on maintaining cost efficiencies through energy-efficient processing technologies. Infrastructure investments by the government will continue to push for metals like steel and aluminum. Fluctuating prices for raw materials like iron ore will necessitate agile sourcing and procurement strategies. The industry will pursue sustainable practices to align with international environmental standards. Navigating these changes will be essential for maintaining a competitive edge. Metal Wholesaling industry revenue is expected to inch upward at a CAGR of 0.2% to $288.9 billion over the five years to 2030.
https://www.ibisworld.com/about/termsofuse/https://www.ibisworld.com/about/termsofuse/
The industry has seen a slight decline in revenue over the past five years. Tariffs from the second Trump administration, including 25% on steel and aluminum imports and 20% on Chinese imports, have significantly influenced costs. These tariffs increased raw material prices, causing downstream markets such as automotive and aerospace to reassess budgets and cut costs. Despite these challenges, profit increased because of decreased labor fees and improvements in automation. Companies have adopted advanced manufacturing technologies to enhance efficiency and productivity. The domestic market's reliance on imported materials means these tariffs directly impact production costs. Retaliatory tariffs from countries like China and the EU have affected export opportunities. To mitigate these impacts, companies optimized production processes and focused on technology integration. The past five years saw the industry adapt to economic pressures, navigating trade tensions and market demands. Decreased labor costs through automation supported profit growth despite declining revenue. Stringent tariffs on steel, aluminum and Chinese imports have increased input costs and mitigated profit growth. Downstream markets, particularly automotive and aerospace, faced reduced demand, directly affecting machinery orders. The industry responded by investing significantly in research and development to produce more efficient and eco-friendly machinery. Competitive pressures from international markets led to price adjustments and product differentiation. Regulatory changes in environmental standards required additional cost management to meet compliance. Efforts to optimize supply chains and focus on domestic market opportunities offered some respite. Companies leveraged digital technologies to improve manufacturing efficiency and reduce dependency on imports. These efforts positioned the industry to better handle external economic pressures. Metalworking Machinery Manufacturing industry revenue has inched downward at a CAGR of 0.8% over the past five years and is expected to total $33.8 billion in 2025, when revenue will fall by an estimated 0.2%. Over the next five years, a rebound in the automotive sector and increased construction demand will drive machinery sales. Continued environmental regulations are creating opportunities for manufacturers focused on sustainability. AI-driven and smart manufacturing technologies will enhance operational efficiencies and reduce costs. Evolving trade agreements might provide new export opportunities, reducing current trade barriers. Companies will continue to invest in customized, client-specific machinery to meet diverse market needs. Despite current tariffs, future reductions in trade tensions may open new markets, boosting exports. Focusing on smart technology and automation will stabilize profit, ensuring resilience against economic fluctuations. The industry’s commitment to innovation and efficiency will define its growth and competitive positioning in the coming years. Metalworking Machinery Manufacturing industry revenue is expected to expand at a CAGR of 1.3% to $36.0 billion over the five years to 2030.
https://www.ibisworld.com/about/termsofuse/https://www.ibisworld.com/about/termsofuse/
Home improvement stores form a mature industry dominated by two major companies, Home Depot and Lowe's. Both companies share similar product lines, which fuels high levels of price competition. Home improvement stores serve various markets, including do-it-for-me (DIFM), do-it-yourself (DIY) and professional customers. The most prominent influence on the performance of stores is activity in the residential market. Starting in 2021, spikes in inflation have cut consumers' spending power, while rising interest rates have constrained residential construction spending. While inflation has been tempered, the recent tariff announcements by the Trump administration remain a threat to product prices. Revenue for home improvement stores is expected to swell at a CAGR of 1.7% to $292.8 billion through the end of 2025, including growth of 1.9% in 2025 alone. The residential market boomed in 2020 as consumers stayed inside, resulting in more consumers with time to spend looking at new homes. Sales of home appliances, lumber, tools, hardware and lawn equipment were boosted. However, mounting inflationary pressure in 2022 led the Federal Reserve to raise interest rates. Since home improvement stores are tied to residential sector growth, rising interest rates cut housing sales that year, leading to faltering revenue. Since the pandemic, exploding e-commerce sales have been a boon for the industry. Home improvement stores will continue to improve their online platforms to strengthen sales in the coming years. Growing economic uncertainty has lifted sales of DIY products while limiting profit growth. Moving forward, interest rates are expected to drop, benefiting home improvement stores. Tariffs could result in higher interest rates, potentially upending the industry. Still, consumer spending power will remain relatively low, suppressing residential activity. Although residential activity is expected to slow, rising disposable income will boost spending on appliances and gardening equipment. There will be a trend of consumers opting for smaller appliances and upgrades rather than making significant investments in new construction or renovations. Home improvement store revenue is expected to climb at a CAGR of 2.1% to $325.3 billion through the end of 2030. The growing efficiency of online operations will cause profit to swell.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
The development of cross-border e-commerce platform promotes the new channel model between domestic and international. How to determine the dual-channel pricing decision of manufacturers and retailers under the condition of tariff and transportation heterogeneity has become an important and realistic problem. Based on the perspective of cross-border e-commerce dual-channel supply chain, this paper considers the impact of import tariff, transport heterogeneity and export tax rebate, compares and analyzes the performance difference between decentralized decision-making and centralized decision-making, and analyzes the impact of import tariff, export tax rebate and transport heterogeneity on cross-border e-commerce dual-channel pricing, demand and profit. The results show that the tariff is positively correlated with the manufacturer’s direct selling price and the retailer’s retail price, while the tariff is negatively correlated with the wholesale price, the demand and profit of direct selling channel and the retail channel. Export tax rebate rate is positively correlated with manufacturers’ demand and profit and retailers’ demand and profit, and negatively correlated with manufacturers’ wholesale price, direct selling price and retail price. The increase of unit freight in direct channel is unfavorable to manufacturers and beneficial to retailers; The increase in unit freight rates in retail channels is bad for both manufacturers and retailers. Centralized decision-making is beneficial to supply chain demand and profits, and can improve the overall performance of the supply chain.
https://www.ibisworld.com/about/termsofuse/https://www.ibisworld.com/about/termsofuse/
Watch manufacturing revenue has grown at an estimated CAGR of 3.4%, reaching $435.1 million by the end of 2025, including a 2.0% gain in that year alone. In recent years, watch manufacturers have faced significant volatility. High levels of inflation and unemployment have made consumers uncertain about their financial stability, causing many to delay discretionary purchases such as watches. More recently, however, improving macroeconomic conditions have led to a recovery in industry revenue. Despite this growth, demand for traditional watches continues to be negatively affected by advances in technology and shifting consumer preferences. Increasingly, buyers—especially those looking for affordable options with added functions—are opting for smartwatches, which have steadily gained market share. Domestic watch manufacturers also face prominent competition from foreign producers. Many consumers prefer imported watches, and high-end brands are often based in countries such as Switzerland, Japan and Germany. On the other hand, manufacturers of more affordable watches operate in countries with favorable regulations, such as China. As a result, import penetration surpassed 90.0%, significantly limiting the customer base for local producers. Fluctuations in input costs further challenge manufacturers, as these shifts directly influence selling prices. In recent years, producers have endured severe supply chain disruptions and ongoing trade tensions, intensified by rising tariffs imposed during the second Trump administration, which have further pressured companies reliant on imported materials. These factors all threaten revenue and profit. Over the coming years, the ongoing economic recovery is expected to support manufacturers, as rising consumer confidence often leads to more discretionary spending. Although the US dollar will likely depreciate in the coming years, imports are still expected to dominate the domestic market. Smartwatches will continue to gain popularity, further pressuring traditional watch sales. In response, domestic manufacturers are expected to incorporate new technologies and adapt to changing consumer preferences, which should help support industry growth. As a result, revenue is set to climb at a CAGR of 1.9%, reaching $478.3 million by the end of 2030.
Goal 17Strengthen the means of implementation and revitalize the Global Partnership for Sustainable DevelopmentTarget 17.1: Strengthen domestic resource mobilization, including through international support to developing countries, to improve domestic capacity for tax and other revenue collectionIndicator 17.1.1: Total government revenue as a proportion of GDP, by sourceGR_G14_GDP: Total government revenue (budgetary central government) as a proportion of GDP (%)GR_G14_XDC: Total government revenue, in local currencyIndicator 17.1.2: Proportion of domestic budget funded by domestic taxesGC_GOB_TAXD: Proportion of domestic budget funded by domestic taxes (% of GDP)Target 17.2: Developed countries to implement fully their official development assistance commitments, including the commitment by many developed countries to achieve the target of 0.7 per cent of gross national income for official development assistance (ODA/GNI) to developing countries and 0.15 to 0.20 per cent of ODA/GNI to least developed countries; ODA providers are encouraged to consider setting a target to provide at least 0.20 per cent of ODA/GNI to least developed countriesIndicator 17.2.1: Net official development assistance, total and to least developed countries, as a proportion of the Organization for Economic Cooperation and Development (OECD) Development Assistance Committee donors’ gross national income (GNI)DC_ODA_SIDSG: Net official development assistance (ODA) to small island states (SIDS) as a percentage of OECD-DAC donors' GNI, by donor countries (%)DC_ODA_LDCG: Net official development assistance (ODA) to LDCs as a percentage of OECD-DAC donors' GNI, by donor countries (%)DC_ODA_LLDC: Net official development assistance (ODA) to landlocked developing countries from OECD-DAC countries, by donor countries (millions of constant 2018 United States dollars)DC_ODA_SIDS: Net official development assistance (ODA) to small island states (SIDS) from OECD-DAC countries, by donor countries (millions of constant 2018 United States dollars)DC_ODA_LDCS: Net official development assistance (ODA) to LDCs from OECD-DAC countries, by donor countries (millions of constant 2018 United States dollars)DC_ODA_LLDCG: Net official development assistance (ODA) to landlocked developing countries as a percentage of OECD-DAC donors' GNI, by donor countries (%)DC_ODA_TOTG: Net official development assistance (ODA) as a percentage of OECD-DAC donors' GNI, by donor countries (%)DC_ODA_TOTL: Net official development assistance (ODA) from OECD-DAC countries, by donor countries (millions of constant 2018 United States dollars)DC_ODA_TOTLGE: Official development assistance (ODA) from OECD-DAC countries on grant equivalent basis, by donor countries (millions of constant 2018 United States dollars)DC_ODA_TOTGGE: Official development assistance (ODA) as a percentage of OECD-DAC donors' GNI on grant equivalent basis, by donor countries (%)Target 17.3: Mobilize additional financial resources for developing countries from multiple sourcesIndicator 17.3.1: Foreign direct investment, official development assistance and South-South cooperation as a proportion of gross national incomeGF_FRN_FDI: Foreign direct investment (FDI) inflows (millions of US dollars)Indicator 17.3.2: Volume of remittances (in United States dollars) as a proportion of total GDPBX_TRF_PWKR: Volume of remittances (in United States dollars) as a proportion of total GDP (%)Target 17.4: Assist developing countries in attaining long-term debt sustainability through coordinated policies aimed at fostering debt financing, debt relief and debt restructuring, as appropriate, and address the external debt of highly indebted poor countries to reduce debt distressIndicator 17.4.1: Debt service as a proportion of exports of goods and servicesDT_TDS_DECT: Debt service as a proportion of exports of goods and services (%)Target 17.5: Adopt and implement investment promotion regimes for least developed countriesIndicator 17.5.1: Number of countries that adopt and implement investment promotion regimes for developing countries, including the least developed countriesSG_CPA_SIGN_BIT: Number of countries with a signed bilateral investment treaty (BIT) (Number)SG_CPA_INFORCE_BIT: Number of countries with an inforce bilateral investment treaty (BIT) (Number)Target 17.6: Enhance North-South, South-South and triangular regional and international cooperation on and access to science, technology and innovation and enhance knowledge-sharing on mutually agreed terms, including through improved coordination among existing mechanisms, in particular at the United Nations level, and through a global technology facilitation mechanismIndicator 17.6.1: Fixed Internet broadband subscriptions per 100 inhabitants, by speed5IT_NET_BBNDN: Number of fixed Internet broadband subscriptions, by speed (number)IT_NET_BBND: Fixed Internet broadband subscriptions per 100 inhabitants, by speed (per 100 inhabitants)Target 17.7: Promote the development, transfer, dissemination and diffusion of environmentally sound technologies to developing countries on favourable terms, including on concessional and preferential terms, as mutually agreedIndicator 17.7.1: Total amount of funding for developing countries to promote the development, transfer, dissemination and diffusion of environmentally sound technologiesTarget 17.8: Fully operationalize the technology bank and science, technology and innovation capacity-building mechanism for least developed countries by 2017 and enhance the use of enabling technology, in particular information and communications technologyIndicator 17.8.1: Proportion of individuals using the InternetIT_USE_ii99: Internet users per 100 inhabitantsTarget 17.9: Enhance international support for implementing effective and targeted capacity-building in developing countries to support national plans to implement all the Sustainable Development Goals, including through North-South, South-South and triangular cooperationIndicator 17.9.1: Dollar value of financial and technical assistance (including through North-South, South-South and triangular cooperation) committed to developing countriesDC_FTA_TOTAL: Total official development assistance (gross disbursement) for technical cooperation (millions of 2018 United States dollars)Target 17.10: Promote a universal, rules-based, open, non-discriminatory and equitable multilateral trading system under the World Trade Organization, including through the conclusion of negotiations under its Doha Development AgendaIndicator 17.10.1: Worldwide weighted tariff-averageTM_TAX_WMFN: Worldwide weighted tariff-average, most-favoured-nation status, by type of product (%)TM_TAX_WMPS: Worldwide weighted tariff-average, preferential status, by type of product (%)Target 17.11: Significantly increase the exports of developing countries, in particular with a view to doubling the least developed countries’ share of global exports by 2020Indicator 17.11.1: Developing countries’ and least developed countries’ share of global exportsTX_IMP_GBMRCH: Developing countries’ and least developed countries’ share of global merchandise imports (%)TX_EXP_GBMRCH: Developing countries’ and least developed countries’ share of global merchandise exports (%)TX_EXP_GBSVR: Developing countries’ and least developed countries’ share of global services exports (%)TX_IMP_GBSVR: Developing countries’ and least developed countries’ share of global services imports (%)Target 17.12: Realize timely implementation of duty-free and quota-free market access on a lasting basis for all least developed countries, consistent with World Trade Organization decisions, including by ensuring that preferential rules of origin applicable to imports from least developed countries are transparent and simple, and contribute to facilitating market accessIndicator 17.12.1: Weighted average tariffs faced by developing countries, least developed countries and small island developing StatesTM_TAX_DMFN: Average tariff applied by developed countries, most-favored nation status, by type of product (%)TM_TAX_DPRF: Average tariff applied by developed countries, preferential status, by type of product (%)Target 17.13: Enhance global macroeconomic stability, including through policy coordination and policy coherenceIndicator 17.13.1: Macroeconomic DashboardTarget 17.14: Enhance policy coherence for sustainable developmentIndicator 17.14.1: Number of countries with mechanisms in place to enhance policy coherence of sustainable developmentSG_CPA_SDEVP: Mechanisms in place to enhance policy coherence for sustainable development (%)Target 17.15: Respect each country’s policy space and leadership to establish and implement policies for poverty eradication and sustainable developmentIndicator 17.15.1: Extent of use of country-owned results frameworks and planning tools by providers of development cooperationSG_PLN_PRVRIMON: Proportion of results indicators which will be monitored using government sources and monitoring systems - data by provider (%)SG_PLN_RECRIMON: Proportion of results indicators which will be monitored using government sources and monitoring systems - data by recipient (%)SG_PLN_PRVNDI: Proportion of project objectives of new development interventions drawn from country-led result frameworks - data by provider (%)SG_PLN_RECNDI: Proportion of project objectives in new development interventions drawn from country-led result frameworks - data by recipient (%)SG_PLN_PRVRICTRY: Proportion of results indicators drawn from country-led results frameworks - data by provider (%)SG_PLN_RECRICTRY: Proportion of results indicators drawn from country-led results frameworks - data by recipient (%)SG_PLN_REPOLRES: Extent of use of country-owned results frameworks and planning tools by providers of development cooperation - data by recipient (%) SG_PLN_PRPOLRES: Extent of use of country-owned results frameworks and planning tools by providers of
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
Toyota Motor announces a second consecutive quarterly profit decline amid cooling sales momentum and increasing global competition, highlighting challenges and strategies for future growth.
Goal 17Strengthen the means of implementation and revitalize the Global Partnership for Sustainable DevelopmentTarget 17.1: Strengthen domestic resource mobilization, including through international support to developing countries, to improve domestic capacity for tax and other revenue collectionIndicator 17.1.1: Total government revenue as a proportion of GDP, by sourceGR_G14_GDP: Total government revenue (budgetary central government) as a proportion of GDP (%)GR_G14_XDC: Total government revenue, in local currencyIndicator 17.1.2: Proportion of domestic budget funded by domestic taxesGC_GOB_TAXD: Proportion of domestic budget funded by domestic taxes (% of GDP)Target 17.2: Developed countries to implement fully their official development assistance commitments, including the commitment by many developed countries to achieve the target of 0.7 per cent of gross national income for official development assistance (ODA/GNI) to developing countries and 0.15 to 0.20 per cent of ODA/GNI to least developed countries; ODA providers are encouraged to consider setting a target to provide at least 0.20 per cent of ODA/GNI to least developed countriesIndicator 17.2.1: Net official development assistance, total and to least developed countries, as a proportion of the Organization for Economic Cooperation and Development (OECD) Development Assistance Committee donors’ gross national income (GNI)DC_ODA_SIDSG: Net official development assistance (ODA) to small island states (SIDS) as a percentage of OECD-DAC donors' GNI, by donor countries (%)DC_ODA_LDCG: Net official development assistance (ODA) to LDCs as a percentage of OECD-DAC donors' GNI, by donor countries (%)DC_ODA_LLDC: Net official development assistance (ODA) to landlocked developing countries from OECD-DAC countries, by donor countries (millions of constant 2018 United States dollars)DC_ODA_SIDS: Net official development assistance (ODA) to small island states (SIDS) from OECD-DAC countries, by donor countries (millions of constant 2018 United States dollars)DC_ODA_LDCS: Net official development assistance (ODA) to LDCs from OECD-DAC countries, by donor countries (millions of constant 2018 United States dollars)DC_ODA_LLDCG: Net official development assistance (ODA) to landlocked developing countries as a percentage of OECD-DAC donors' GNI, by donor countries (%)DC_ODA_TOTG: Net official development assistance (ODA) as a percentage of OECD-DAC donors' GNI, by donor countries (%)DC_ODA_TOTL: Net official development assistance (ODA) from OECD-DAC countries, by donor countries (millions of constant 2018 United States dollars)DC_ODA_TOTLGE: Official development assistance (ODA) from OECD-DAC countries on grant equivalent basis, by donor countries (millions of constant 2018 United States dollars)DC_ODA_TOTGGE: Official development assistance (ODA) as a percentage of OECD-DAC donors' GNI on grant equivalent basis, by donor countries (%)Target 17.3: Mobilize additional financial resources for developing countries from multiple sourcesIndicator 17.3.1: Foreign direct investment, official development assistance and South-South cooperation as a proportion of gross national incomeGF_FRN_FDI: Foreign direct investment (FDI) inflows (millions of US dollars)Indicator 17.3.2: Volume of remittances (in United States dollars) as a proportion of total GDPBX_TRF_PWKR: Volume of remittances (in United States dollars) as a proportion of total GDP (%)Target 17.4: Assist developing countries in attaining long-term debt sustainability through coordinated policies aimed at fostering debt financing, debt relief and debt restructuring, as appropriate, and address the external debt of highly indebted poor countries to reduce debt distressIndicator 17.4.1: Debt service as a proportion of exports of goods and servicesDT_TDS_DECT: Debt service as a proportion of exports of goods and services (%)Target 17.5: Adopt and implement investment promotion regimes for least developed countriesIndicator 17.5.1: Number of countries that adopt and implement investment promotion regimes for developing countries, including the least developed countriesSG_CPA_SIGN_BIT: Number of countries with a signed bilateral investment treaty (BIT) (Number)SG_CPA_INFORCE_BIT: Number of countries with an inforce bilateral investment treaty (BIT) (Number)Target 17.6: Enhance North-South, South-South and triangular regional and international cooperation on and access to science, technology and innovation and enhance knowledge-sharing on mutually agreed terms, including through improved coordination among existing mechanisms, in particular at the United Nations level, and through a global technology facilitation mechanismIndicator 17.6.1: Fixed Internet broadband subscriptions per 100 inhabitants, by speed5IT_NET_BBNDN: Number of fixed Internet broadband subscriptions, by speed (number)IT_NET_BBND: Fixed Internet broadband subscriptions per 100 inhabitants, by speed (per 100 inhabitants)Target 17.7: Promote the development, transfer, dissemination and diffusion of environmentally sound technologies to developing countries on favourable terms, including on concessional and preferential terms, as mutually agreedIndicator 17.7.1: Total amount of funding for developing countries to promote the development, transfer, dissemination and diffusion of environmentally sound technologiesTarget 17.8: Fully operationalize the technology bank and science, technology and innovation capacity-building mechanism for least developed countries by 2017 and enhance the use of enabling technology, in particular information and communications technologyIndicator 17.8.1: Proportion of individuals using the InternetIT_USE_ii99: Internet users per 100 inhabitantsTarget 17.9: Enhance international support for implementing effective and targeted capacity-building in developing countries to support national plans to implement all the Sustainable Development Goals, including through North-South, South-South and triangular cooperationIndicator 17.9.1: Dollar value of financial and technical assistance (including through North-South, South-South and triangular cooperation) committed to developing countriesDC_FTA_TOTAL: Total official development assistance (gross disbursement) for technical cooperation (millions of 2018 United States dollars)Target 17.10: Promote a universal, rules-based, open, non-discriminatory and equitable multilateral trading system under the World Trade Organization, including through the conclusion of negotiations under its Doha Development AgendaIndicator 17.10.1: Worldwide weighted tariff-averageTM_TAX_WMFN: Worldwide weighted tariff-average, most-favoured-nation status, by type of product (%)TM_TAX_WMPS: Worldwide weighted tariff-average, preferential status, by type of product (%)Target 17.11: Significantly increase the exports of developing countries, in particular with a view to doubling the least developed countries’ share of global exports by 2020Indicator 17.11.1: Developing countries’ and least developed countries’ share of global exportsTX_IMP_GBMRCH: Developing countries’ and least developed countries’ share of global merchandise imports (%)TX_EXP_GBMRCH: Developing countries’ and least developed countries’ share of global merchandise exports (%)TX_EXP_GBSVR: Developing countries’ and least developed countries’ share of global services exports (%)TX_IMP_GBSVR: Developing countries’ and least developed countries’ share of global services imports (%)Target 17.12: Realize timely implementation of duty-free and quota-free market access on a lasting basis for all least developed countries, consistent with World Trade Organization decisions, including by ensuring that preferential rules of origin applicable to imports from least developed countries are transparent and simple, and contribute to facilitating market accessIndicator 17.12.1: Weighted average tariffs faced by developing countries, least developed countries and small island developing StatesTM_TAX_DMFN: Average tariff applied by developed countries, most-favored nation status, by type of product (%)TM_TAX_DPRF: Average tariff applied by developed countries, preferential status, by type of product (%)Target 17.13: Enhance global macroeconomic stability, including through policy coordination and policy coherenceIndicator 17.13.1: Macroeconomic DashboardTarget 17.14: Enhance policy coherence for sustainable developmentIndicator 17.14.1: Number of countries with mechanisms in place to enhance policy coherence of sustainable developmentSG_CPA_SDEVP: Mechanisms in place to enhance policy coherence for sustainable development (%)Target 17.15: Respect each country’s policy space and leadership to establish and implement policies for poverty eradication and sustainable developmentIndicator 17.15.1: Extent of use of country-owned results frameworks and planning tools by providers of development cooperationSG_PLN_PRVRIMON: Proportion of results indicators which will be monitored using government sources and monitoring systems - data by provider (%)SG_PLN_RECRIMON: Proportion of results indicators which will be monitored using government sources and monitoring systems - data by recipient (%)SG_PLN_PRVNDI: Proportion of project objectives of new development interventions drawn from country-led result frameworks - data by provider (%)SG_PLN_RECNDI: Proportion of project objectives in new development interventions drawn from country-led result frameworks - data by recipient (%)SG_PLN_PRVRICTRY: Proportion of results indicators drawn from country-led results frameworks - data by provider (%)SG_PLN_RECRICTRY: Proportion of results indicators drawn from country-led results frameworks - data by recipient (%)SG_PLN_REPOLRES: Extent of use of country-owned results frameworks and planning tools by providers of development cooperation - data by recipient (%) SG_PLN_PRPOLRES: Extent of use of country-owned results frameworks and planning tools by providers of
Not seeing a result you expected?
Learn how you can add new datasets to our index.
Apache License, v2.0https://www.apache.org/licenses/LICENSE-2.0
License information was derived automatically
You are an analyst at "Megaline," a federal mobile operator. The company offers two tariff plans to customers: "Smart" and "Ultra." To adjust the advertising budget, the commercial department wants to understand which tariff generates more revenue.
You need to conduct a preliminary analysis of the tariffs on a small sample of customers. You have data on 500 users of "Megaline": who they are, where they are from, which tariff they use, how many calls and messages they sent in 2018. You need to analyze customer behavior and conclude which tariff is better.
"Smart" Tariff: - Monthly fee: 550 rubles - Included: 500 minutes of calls, 50 messages, and 15 GB of internet traffic - Cost of services beyond the tariff package: 1. Call minute: 3 rubles (Megaline always rounds up minutes and megabytes. If the user talked for just 1 second, it counts as a whole minute); 2. Message: 3 rubles; 3. 1 GB of internet traffic: 200 rubles.
"Ultra" Tariff: - Monthly fee: 1950 rubles - Included: 3000 minutes of calls, 1000 messages, and 30 GB of internet traffic - Cost of services beyond the tariff package: 1. Call minute: 1 ruble; 2. Message: 1 ruble; 3. 1 GB of internet traffic: 150 rubles.
Note: Megaline always rounds up seconds to minutes and megabytes to gigabytes. Each call is rounded up individually: even if it lasted just 1 second, it is counted as 1 minute. For web traffic, separate sessions are not counted. Instead, the total amount for the month is rounded up. If a subscriber uses 1025 megabytes in a month, they are charged for 2 gigabytes.
Step 1: Open the file with data and study the general information
File paths:
- /datasets/calls.csv
- /datasets/internet.csv
- /datasets/messages.csv
- /datasets/tariffs.csv
- /datasets/users.csv
Step 2: Prepare the data - Convert data to the required types; - Find and fix errors in the data, if any. Explain what errors you found and how you fixed them. You will find calls with zero duration in the data. This is not an error: missed calls are indicated by zeros, so they do not need to be deleted.
For each user, calculate: - Number of calls made and minutes spent per month; - Number of messages sent per month; - Amount of internet traffic used per month; - Monthly revenue from each user (subtract the free limit from the total number of calls, messages, and internet traffic; multiply the remainder by the value from the tariff plan; add the corresponding tariff plan's subscription fee).
Step 3: Analyze the data Describe the behavior of the operator's customers based on the sample. How many minutes of calls, how many messages, and how much internet traffic do users of each tariff need per month? Calculate the average, variance, and standard deviation. Create histograms. Describe the distributions.
Step 4: Test hypotheses - The average revenue of users of the "Ultra" and "Smart" tariffs is different; - The average revenue of users from Moscow differs from the revenue of users from other regions. Moscow is written as 'Москва'. You can put it in your value, when check the hypothesis
Set the threshold alpha value yourself.
Explain: - How you formulated the null and alternative hypotheses; - Which criterion you used to test the hypotheses and why.
Step 5: Write a general conclusion
Formatting: Perform the task in Jupyter Notebook. Fill the program code in the cells of type code
, and the textual explanations in the cells of type markdown
. Apply formatting and headers.
Table users
(user information):
- user_id
: unique user identifier
- first_name
: user's first name
- last_name
: user's last name
- age
: user's age (years)
- reg_date
: date of tariff connection (day, month, year)
- churn_date
: date of tariff discontinuation (if the value is missing, the tariff was still active at the time of data extraction)
- city
: user's city of residence
- tariff
: name of the tariff plan
Table calls
(call information):
- id
: unique call number
- call_date
: call date
- duration
: call duration in minutes
- user_id
: identifier of the user who made the call
Table messages
(message information):
- id
: unique message number
- message_date
: message date
- user_id
: identifier of the user who sent the message
Table internet
(internet session information):
- id
: unique session number
- mb_used
: amount of internet traffic used during the session (in megabytes)
- session_date
: internet session date
- user_id
: user identifier
Table tariffs
(tariff information):
- tariff_name
: tariff name
- rub_monthly_fee
: monthly subscription fee in rubles
- minutes_included
: number of call minutes included per month
- `messages_included...