Business Analytics

MIS171 Busin" rel="nofollow">iness Analytics (T2 2016) Assignment Two Marks: 20% Due Date: By 5pm Friday 16 September 2016 Background This assignment requires you to perform in" rel="nofollow">inferential techniques on the dataset (“Phone.xlsx”) used in" rel="nofollow">in Assignment 1 and then report your fin" rel="nofollow">indin" rel="nofollow">ings to a person with little or no knowledge of statistical data analysis. As for Assignment 1,the assignment is to be completed in" rel="nofollow">in groups of two or three and is to be submitted both electronically and in" rel="nofollow">in identical hardcopy.There will be a lin" rel="nofollow">ink in" rel="nofollow">in Moodle under Week 10 for the electronic submission. Your submission will be comprised of two parts : Part 1 : Data Analysis(mostly handwritten —a maximum of 8 pages); Part 2 : A reply to Lionel Ronaldo’s questions in" rel="nofollow">in the form of a memorandum(maximum of two pages). Scenario As was the case in" rel="nofollow">in Assignment 1, you are playin" rel="nofollow">ing the role of Hasan Choudhury,an analyst at an electronics and communication magazin" rel="nofollow">ine. Lionel Ronaldo,one of the senior editors at the magazin" rel="nofollow">ine, has written to you again" rel="nofollow">in regardin" rel="nofollow">ing the phone dataset. His memorandum is reproduced below. For Attention: Hasan Choudhury,Analyst 27/08/2016 From: Lionel Ronaldo,Senior Editor Regardin" rel="nofollow">ing: Further analysis of Phone dataset Dear Hasan Thank you for your earlier response. I also need the followin" rel="nofollow">ing in" rel="nofollow">information. 1. Please provide me with a 90% confidence in" rel="nofollow">interval for : a. the mean monthly bill for ALL users? b. the proportion of ALL users who are on a post-paid plan? 2. We wrote previously that, on average, phone users spend more than $61.50 on their monthly bill. Please check if this is still the case (at 5% significance). (NOTE TO STUDENTS : In part a, you can assume s = $45.) Part 1: Data Analysis: You will need to perform a number of manual calculations, usin" rel="nofollow">ing the data set “Phone.xlsx”.Some of these calculations will be based on your answers in" rel="nofollow">in