Excell Data Analysis

Excell Data Analysis





Case 1

Pivot table showing the frequency distribution during November that the server was down for each downtime cause category (Agresti & Kateri, 2011). We can see that memory error was the most frequent downtime cause, while manual Re-start and slow startup were the least downtime causes during the month of November.

Row Labels Count of Downtime Minutes
Lockups 6
Manual Re-start 1
Memory Errors 10
Slow Startup 1
Weekly Virus Scan 4
Grand Total 22

Bar chart

Below is a bar chart displaying the data from the frequency distribution table above.

Pie chart

The pie chart below breaks down the percentage of total downtime that is attributed to each downtime cause during November

The table below shows the downtime data for the month of November and the downtime minutes’ descriptive statistics (Agresti & Kateri, 2011). The mean time for downtime is 33 minutes, the median is 32.5, the standard deviation is 15.84045181 and the variance is 250.9199134 (Vaughn, 2008).

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

Case 2

The table below shows the observation dates which are 6 years apart, their corresponding Consumer price indexes and national inflation rates.

observation_dateCPIAUCSLNational inflation rate1951-11-0126.3201957-11-0128.4107.9407294831963-11-0130.7808.3421330521969-11-0137.50021.832358671975-11-0155.30047.466666671981-11-0193.80069.620253161987-11-01115.40023.027718551993-11-01146.00026.516464471999-11-01168.40015.342465752005-11-01198.10017.636579572011-11-01227.16914.673902072017-11-01247.5928.990223138

Below is a line graph of the percentage changes (national inflation rates) as in the table above

From the analyses above, it is evident that the period between 01-11-1975 and 01-11-1981 with an inflation rate of 69.62025316


Agresti, A., & Kateri, M. (2011). Categorical data analysis. In International encyclopedia of statistical science (pp. 206-208). Springer Berlin Heidelberg.

Vaughn, B. K. (2008). Data analysis using regression and multilevel/hierarchical models, by Gelman, A., & Hill, J. Journal of Educational Measurement45(1), 94-97.

Place an Order

Plagiarism Free!

Scroll to Top