ALTERNATIVE
ASSIGNMENT FOR WEEK 3 The Business Side of Standard Deviation

You are a statistician analyst for a local cable company and you
must present an analysis of the financial data to the executives, including
predicted number of customers in three ranges using Empirical rule, and in two
ranges using Chebyshev rule.

The table below shows a sample of customer
statements for the month of February 2017

AMOUNTS DUE BY CUSTOMERS OF A CABLE TV LLC IN JANUARY 2017

Generate 30 values using the following procedure

1.
Open EXCEL

2.
Open Data

3.
Click on Data Analysis

4.
Choose Random Number
generator

5.
Enter 1 in Number of
Variables

6.
Enter 30 in the Number
of random numbers field

7.
Choose Normal; in the
Distribution field

8.
Choose New worksheet

Calculate the mean and the standard deviation of the data in the table

Discuss what the mean and the standard deviation means.

Analyze data using the empirical rule and the Chebyshev rule,

Create a 10-slide (first slide: Title of the presentation and introduction
of participants, last slide: Executive summary of the findings.) Microsoft®
PowerPoint® presentation including detailed speaker notes in which you include
the following:

• Graphs of data.
• Explain the role of the mean and the standard deviation
  in the analysis.
• Present detailed findings of the problem
• Explain any other uses for standard deviation in a
  business setting.

Click the Assignment Files tab to submit your assignment.