Case 1:

Scenario:Cloud Data Services (CDS), headquartered in Memphis, provides information technology services, specifically application hosting services in the cloud for several clients in the southern United States. CDS hosts software applications on their network servers. While CDS has achieved great success and customers rate CDS's services highly, lately, some customers have been complaining about downtime on one of the primary network servers. The given dataset, found in the Signature AssignmentExcelTemplate, contains the downtime data for the month of November.

Usethe data analytics skills learned in Week 3 andanalyzethe downtime data.

Makea short presentation to CDS's management including the following:

1. Usingused MicrosoftExcelPivot Tables, construct a frequency distribution showing the number of times during the month that the server was down for each downtime cause category.
2. Develop a bar chart that displays the data from the frequency distribution in part 1.
3. Develop a pie chart that breaks down the percentage of total downtime that is attributed to each downtime cause during the month.
4. Evaluate the mean, median, standard deviation, and variance of the downtime minutes for the month of November.

Date 11/01/16 11/02/16 11/03/16 11/04/16 11/07/16 11/07/16 11/07/16 11/07/16 11/10/16 11/10/16 11/11/16 11/14/16 11/16/16 11/18/16 11/18/16 11/18/16 11/21/16 11/22/16 11/27/16 11/30/16 11/28/16 11/28/16 Problem Experienced Lockups Lockups Memory Errors Lockups Weekly Virus Scan Lockups Memory Errors Memory Errors Slow Startup Weekly Virus Scan Memory Errors Memory Errors Manual Re-start Memory Errors Weekly Virus Scan Lockups Memory Errors Memory Errors Memory Errors Weekly Virus Scan Memory Errors Lockups Downtime Minutes 25 35 10 40 60 30 35 20 45 60 30 10 20 35 60 25 35 20 40 60 15 25