1/1

Case: Server Downtime

1

After getting outstanding grades in high school and

scoring very high on his ACT and SAT tests, Clayto

n Haney had his

choice of colleges but wanted to follow his parents

' legacy and enrolled at Northwestern University. C

layton soon

learned that there is a big difference between gett

ing high grades in high school and being a good stu

dent. Although

he was recognized as being quite bright and very qu

ick to pick up on things, he had never learned how

to study. As a

result, after slightly more than two years at North

western, Clayton was invited to try his luck at ano

ther university.

To the chagrin of his parents, Clayton decided that

college was not for him.

After short stints working for a computer manufactu

rer and for a VOD company, Clayton landed a job wor

king for

the EDS company. EDS contracts to support informati

on technology implementation and application for co

mpanies

in the United States and throughout the world. Clay

ton had to train himself in virtually all aspects o

f personal

computers and local area networks and was assigned

to work for a client in the Chicago area.

Clayton's first assignment was to research the down

time on one of the client's primary network servers

. He was

asked to study the downtime data available and to m

ake a short presentation of his analysis and his

recommendations to the company's management. Althou

gh Clayton is very good at solving computer problem

s, he

has had no training or experience in analyzing data

, so he is going to need some help. Fortunately, yo

u are currently

at the EDS company, as an intern. Please help!

A preview of the data Clayton has collected is pres

ented in the table:

Problem Experienced

Date

Downtime (minutes)

Bi

-

weekly Virus Scan

03/01/2019

45

Lockup

03/01/2019

25

Memory Errors

05/01/2019

14

Memory Errors

06/01/2019

10

Lockup

08/01/2019

26

...

(

T

he complete data

array

is in the

excel file serverevents

2019

-

2020

.xlsx)

Required Tasks:

1.

Construct a frequency distribution showing the numb

er of times the server was down for each downtime c

ause

category.

2.

Develop a bar chart that displays the data from the

frequency distribution in question 1.

3.

Develop a histogram that displays the downtime data

.

4.

How does the type of problem experienced affect dow

ntime?

5.

Develop a pie chart that breaks down the percentage

of total downtime that is attributed to each downt

ime

cause during the period.

6.

write short written report that discusses the d

owntime data. Make sure you merge the useful tables

, graphs

and charts into the report.