Deakin College

Deakin College in association with DEAKIN UNIVERSITY MIS171 Business Analytics (T2 2016) Assignment Two Marks: 20% Due Date: By 5pm Friday 16 September 2016 Background This assignment requires you to perform inferential techniques on the dataset (“Phone.xlsx”) used in Assignment 1 and then report your findings to a person with little or no knowledge of statistical data analysis. As for Assignment 1,the assignment is to be completed in groups of two or three and is to be submitted both electronically and in identical hardcopy.There will be a link 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 the form of a memorandum(maximum of two pages). Scenario As was the case in Assignment 1, you are playing the role of Hasan Choudhury,an analyst at an electronics and communication magazine. Lionel Ronaldo,one of the senior editors at the magazine, has written to you again regarding the phone dataset. His memorandum is reproduced below. For Attention: Hasan Choudhury,Analyst 27/08/2016 From: Lionel Ronaldo,Senior Editor Regarding: Further analysis of Phone dataset Dear Hasan 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, using the data set “Phone.xlsx”.Some of these calculations will be based on your answers in