Business Analytics (T3 2015)

Business Analytics (T3 2015) Assignment Background This assignment requires you to perform inferential techniques on the dataset(“Smartphone.xlsx”)used in Assignment 1 and then report your findings to a person with little or no knowledge of statistical data analysis. Part 1 : Data Analysis(mostly handwritten —a maximum of 8 pages); Part 2 : A reply to the Senior Editor’s questions in the form of a memorandum(maximum of two pages). Scenario As was the case in Assignment 1, you are playing the role of Linh Nguyen,an analyst at Consumer Magazine. Lasitha Dharmasena,one of the senior editors at the magazine, has written to you again regarding the Smartphone dataset. Hermemorandum is reproduced below. For Attention: Linh Nguyen, Analyst 14/12/2015 From: Lasitha Dharmasena,Senior Editor Regarding: Further analysis of Smartphone dataset Dear Linh Thank you for your earlier response. Ialso need the following information. 1. Please provide me with a 90%confidence intervalfor : a. the mean monthly bill for ALL smartphone users? b. the proportion of ALL smartphone users who are on a post-paid plan? 2. We wrote previously that, on average,smartphone users spend more than $61.50 on their monthly bill. Please check if this is still the case (at 5% significance). 3. We also wrote previously that less than 65% of smartphone users are on a post-paid plan. Please verify that this is still the case(at 5% significance). 4. Please checkif there is a difference in the mean monthly billbetween ALL male and ALL female smartphone users(at 90% confidence). 5. The dataset is a sample of 150 users.What sample size would be needed in order to be able to estimate: a. the mean monthly bill for ALL smartphone users to within $2.50, with 90% confidence? b. the proportion of ALL smartphone users who are on a post-paid planto within 4%, with 90% confidence? (NOTE TO STUDENTS 2: In part a, you can assume s = $45.) I look forward to your response. Sincerely Lasitha Dharmasen Part1: Data Analysis: You will need to perform a number of manual calculations,using thedata set“Smartphone.xlsx”.Some of these calculations will be based on your answers in Assignment 1.As for Assignment 1 your data analysis section must be no more than 8 pages. Part 2: Response to Lasitha As for Assignment 1,your response must be in plain language and a maximum of two pages. Variable : Variable descriptions: Respondent Respondent number (not relevant for analysis) Income Income of the Smartphone user in dollars ($) Gender Gender of the Smartphone user Age Age of the Smartphone user in Years State State where the Smartphone user resides LivingStatus Respondent's living status LandLine Owns a landline phone? MobilePrimary Primary phone is mobile phone? PostPaid On a post-paid plan? (No = pre-paid) MonthlyBill The amount spent last month on the Smartphone in dollars ($) MonthlyCap The monthly Smartphone cap in dollars ($) PercentForWork Use of Smartphone for work (as a % of total use) Calls The number of calls made last month SMS The number of text messages sent last month MMS The number of multi-media messages sent last month Data The data allowance on the Smartphone in MB OnlinePurchase Used the Smartphone to purchase an item online SocialNetworking Used the Smartphone to visit a social networking site MonthlySocialNet The number of visits to social networking site using the Smartphone EntertainmentContent Most frequently downloaded entertainment content SatisfactionWithProvider The level of satisfaction with the Smartphone service provider SatisfactionWithPlan The level of satisfaction with the Smartphone plan