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 Assignment Excel® Template, contains the downtime data for the month of November.
Use the data analytics skills learned in Week 3 and analyze the downtime data.
Make a short presentation to CDS's management including the following:
- Using used Microsoft® Excel® Pivot Tables, construct a frequency distribution showing the number of times during the month that the server was down for each downtime cause category.
- Develop a bar chart that displays the data from the frequency distribution in part 1.
- Develop a pie chart that breaks down the percentage of total downtime that is attributed to each downtime cause during the month.
- Evaluate the mean, median, standard deviation, and variance of the downtime minutes for the month of November.