Data Lab Analysis

    The aims of the assignment are to engender a good understanding of, and skills in, the following aspects of the Data Lab class: • Using a spreadsheet to make sense of data; • Presenting your analyses in visual and written form; • Utilising regression to understand relationships within data; • Applying analytical methods to support enterprise decision-making Submission requirements will be detailed for each section, Part A and Part B, separately. You may be required to complete a peer assessment form to measure the contribution of each group member to the assignment. 1. Introduction The Telecommunications Syndicate collects data from officially recognised international sources on the subscription rates of different types of telecommunications technology, e.g. broadband internet, 4G, etc. for different countries. This is considered to be the most current and accurate global data available, and includes national estimates. The data has been collected since 1981 and is considered by most governments and organisations to be the most reliable source of data to compare themselves with other countries. 2015 is the most recent data available. You work for a small start-up company that is interested in selling products to future users of mobile technology. The product relies on users having the ability to download content rapidly, so they must have good access to mobile data. Your CEO has managed to get access to a small portion of the Syndicate’s dataset, i.e. subscription rates in 5 different countries. He can get access to more data but this is costly and he wants to know if there is value in the data before he purchases it. Your CEO would like a statistical analysis of the data. Unfortunately, your small company does not have a dedicated data analyst. You have been asked to analyse the data and provide suitable management insight for the entire company. Your insight will be used by the company to decide whether or not to develop the product, what countries to focus on and whether or not the entire dataset for over 100 countries should be purchased. 2. A more detailed remit The CEO has seen the data published by the Syndicate, and while he does not fully understand the impact of the data, he believes that insight can be drawn from it. The CEO has requested that you conduct analysis for him on the following broad areas: Comparison of countries across technologies: The CEO is interested in understanding the different rate of subscriptions across different countries. The COE would like to understand whether or not factors such as GDP are influential. Comparison of technologies within countries: The CEO wants to understand whether or not the rate of adoption is similar across different technologies within a country, i.e. was 1G adopted at a similar rate as 3G, etc. Comparison through time: The CEO is interested in understanding what the future may hold for each country for 4G by understanding past patterns in the data and potentially using these as the basis for future projections. The CEO has a basic understanding of statistics and would welcome analysis at two levels: Exploratory analysis using summary statistics and visualisation: The CEO would like summary statistics that he can communicate within the organisation and to future venture capitalists. In particular, the CEO is interested in using visualisation to communicate effectively with the venture capitalists. Inferential analysis: The CEO is aware of more advanced analytical models such as regression. He lacks detailed knowledge of such methods, but would like you to explore the use of regression modelling to provide insight that might be used to predict future adoption.