The purpose of this assignment is for students to synthesize the concepts learned throughout the course, provide students an opportunity to build critical thinking skills, develop businesses and organizations, and solve problems that require data.
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 either a bar chart or a pie chart that displays the data from the frequency distribution in part 1.
- Evaluate the mean, median, standard deviation, and variance of the downtime minutes for the month of November.