ALTERNATIVEASSIGNMENT FOR WEEK 3 The Business Side of Standa

ALTERNATIVEASSIGNMENT FOR WEEK 3 The Business Side of Standard Deviation You are a statistician analyst for a local cable company and youmust present an analysis of the financial data to the executives, includingpredicted number of customers in three ranges using Empirical rule, and in tworanges using Chebyshev rule. The table below shows a sample of customerstatements for the month of February 2017AMOUNTS DUE BYCUSTOMERS OF A CABLE TV LLC IN JANUARY 2017 Generate 30 values using the following procedure1.Open EXCEL2.Open Data3.Click on Data Analysis4.Choose Random Numbergenerator5.Enter 1 in Number ofVariables6.Enter 30 in the Numberof random numbers field7.Choose Normal; in theDistribution field8.Choose New worksheetCalculate the mean and the standard deviation of the data in the tableDiscuss 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 introductionof participants, last slide: Executive summary of the findings.) Microsoft®PowerPoint® presentation including detailed speaker notes in which you includethe following:Graphs of data.Explain the role of the mean and the standard deviationin the analysis.Present detailed findings of the problemExplain any other uses for standard deviation in abusiness setting.Click the Assignment Files tab to submit your assignment.

Posted in Uncategorized