Excell Data Analysis
Name
Course
School
Date
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 | |
| STANDARD 15.84045181DEVIATION | ||
| 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
References
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 Measurement, 45(1), 94-97.
Place an Order
Plagiarism Free!
Create an Account
Create an account at Top Tutor Online
- Allows you to track orders.
- Receive personal messages.
- Send messages to a tutor.
Post a Question/ Assignment
Post your specific assignment
- Tutors will be notified of your assignment.
- Review your question and include all the details.
- A payment Link will be sent to you.
Wait for your Answer!
Make payment and wait for your answer
- Make payment in accordance with the number of pages to be written.
- Wait for your Answer as a professional works on your paper.
- You will be notified when your Answer is ready.