Business Analytics Assignment Two

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 individually and is to be submitted both electronically and in identical hardcopy.

Your submission will be comprised of two parts:

Part 1: Data Analysis (mostly handwritten -a maximum of 8 pages);

Part 2: A reply to Harry Kane'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 Virat Kohli, an analyst at an electronics and communication magazine. Harry Kane, one of the senior editors at the magazine, has written to you again regarding the phone dataset. His memorandum is reproduced below.

For Attention: Virat Kohli                                              2/5/2017

From: Harry Kane

Regarding: Further analysis of Phone dataset

Dear Virat,

Thank you for your earlier response. I also need the following information.

1. Please provide me with a 90% confidence 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).

3. We also wrote previously that less than 65% of phone users are on a post-paid plan. Please verify that this is still the case (at 5% significance).

4. Please check if there is a difference in the mean monthly bill between ALL male and ALL female phone 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 phone users to within $2.50, with 90% confidence?

b. The proportion of ALL phone users who are on a post-paid plan to within 4%, with 90% confidence?

NOTE TO STUDENTS: In part a, you can assume σ = $45. I look forward to your response.

Regards

Harry Kane

Part1: 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 Assignment 1. As for Assignment 1 your data analysis section must be no more than 8 pages.

Part 2: Response to Harry

As for Assignment 1, your response must be in plain language and a maximum of two pages.