The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 356 Weeks Ago |
| Questions Answered: | 20103 |
| Tutorials Posted: | 20155 |
MBA, PHD
Phoniex
Jul-2007 - Jun-2012
Corportae Manager
ChevronTexaco Corporation
Feb-2009 - Nov-2016
Question description
Â
Â
Â
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:
Click the Assignment Files tab to submit your assignment.
Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k Y-----------ou -----------for----------- us-----------ing----------- ou-----------r w-----------ebs-----------ite----------- an-----------d a-----------cqu-----------isi-----------tio-----------n o-----------f m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l