So far, I have written about averages and correcting your data set. In both articles, I have stressed the importance of recognizing outliers and acting according to generally accepted methods. In this article, I will provide the means to identify outliers and their effect on a data set using histograms.
Filtered articles: "Excel"
Filtered articles: "Excel"
Statistical Analysis of Performance Data Part 3 - HistogramsPublished by Nicholas Dille on 11/16/2011 | 1 Comments | 1,357 Views |
![]() |
Statistical Analysis of Performance Data Part 1 - AveragesPublished by Nicholas Dille on 06/27/2011 | 7 Comments | 2,073 Views In the first article about the statistical analysis of performance data, I will be dealing with averages. I will explain why it is a bad idea to work with averages of averages (like when storing intermediate results), why relying on averages can be dangerous and what good averages look like. |
![]() |
Online Statistical Analysis of Performance DataPerformance Monitor is usually used to record performance data of one or more systems and analyze the collected data at a later point in time. As this is useful for offline performance analysis and scalability tests, real-time access to performance data is cumbersome. The graphing node of PerfMon does not offer statistical data in a useful manner. In this article, I demonstrate how to retrieve performance data for a metric and analyze it on-the-fly using PowerShell. |
![]() |
Performance Monitoring Round-UpIn the course of the last six months, I have published nine articles about performance monitoring, why it is a crucial task and how the different subsystems of the operating system. To wrap up this series, this article offers an overview of the topics covered in the individual articles as well as a summary of my recommendations. |
![]() |
Performance Monitoring Part 8 - Analyzing a Performance Monitor Database using ExcelIn the last post of this series about performance monitoring, I have described how to use Windows Performance Monitor to log counter values into a SQL database. Now I'll show you that Excel is a tremendous tool to quickly analyze the collected data. Excel offers a feature called pivot tables. It allows some data mining either on a local data set contained in an Excel sheet or on a database which Excel is connected to. Therefore, this article describes how to create a connection to the database and create nifty charts using Excel. |
![]() |
Performance Monitoring Part 7 - Using Performance Monitor with a DatabaseAfter a lot of theory about performance monitoring, this article demonstrates how the Windows Performance Monitor can be used to log to a database - even from multiple machines. Most of you have probably used Performance Monitor before. It allows you to monitor performance metrics (local and remote) in real-time and to log performance data from multiple machines for later analysis. In this article, I will focus on the latter because collecting and analysing performance data from multiple machines is a time consuming task. |
![]() |
Creating Your Very Own Office 2007 Ribbon - No Programming Necessary!Published by Nicholas Dille on 09/18/2009 | 3 Comments | 4,118 Views The famous German IT magazine c't has recently published an article about creating your own and modifying existing ribbons in Office 2007. Not again, you may be thinking. But the article shows how a simple DLL helps without any knowledge of programming. |
![]() |
Programming Sins Regarding the Registry (Using the Example of Microsoft Excel)Published by Helge Klein on 08/13/2009 | 2 Comments | 4,596 Views While browsing through the registry I found the following "gem". It illustrates nicely how programmers are not supposed to store settings in the registry: |
![]() |
Most Viewed Posts
| 155,442 Views |
Where is the Hosts File on Windows x64?by Helge Klein (06/04/2009) |
| 83,164 Views |
Deleting a Local User Profile - Not as easy as one Might Assumeby Helge Klein (10/16/2008) |
| 53,146 Views |
Printer Driver Isolation in Windows 7 and Server 2008 R2by Helge Klein (04/08/2009) |
| 44,285 Views |
How to Reduce the Size of Roaming Profilesby Helge Klein (11/17/2008) |
| 32,171 Views |
Aufbau einer KMS Infrastrukturby Thorsten Christoffers (03/19/2009) |






