Solved

Annual Failure Rate calculation

Posted on 2014-04-24
4
3,092 Views
Last Modified: 2014-04-24
Experts,

I need assistance on what is the best way to present a device's annual failure rate.

I am reporting on devices by each month.  Fields are the following:

Month_year       Device_Name     Total Device        Failure Total     Failure Percentage
2014-01                3050 HDC         29559                      184           0.0747
2014-02                3050 HDC         30053                         55           0.022
2014-03                3050 HDC         30388                         21           0.0083

I only have data from January 2014, so I average the failure Percentage field?  Or calculate (sum (failure total) / sum (total device)) *100
Or something else..

Thanks
0
Comment
Question by:Maliki Hassani
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 20

Expert Comment

by:Russ Suter
ID: 40020739
I'm not getting the same numbers you are.

According to my calculations the failure percentages are as follows:

29559      184      0.006224838
30053      55      0.0018301
30388      21      0.000691062

That being said, your method does work and should give you the most accurate representation of the data.
0
 

Author Comment

by:Maliki Hassani
ID: 40020810
The formula I was using to get the percentage is (( failure/total) *12).
this worked because I was only reporting on the current monthly failure rate.  (told by management)

So now that they want to report on the Annualized failure rate, How should I write my formula?

Do I average the failure Percentage field?  
Formula:  averaged comes to:  0.035


Or

calculate (sum (failure total) / sum (total device)) *100
Formula:   90000   /      260  = 0.288888889
0
 
LVL 20

Accepted Solution

by:
Russ Suter earned 500 total points
ID: 40020904
Realistically, report it any way you want.

Since they're asking you to make up data you can make up the answers as well.

More practically, I would average the failure percentage fields. At least it's easy to track that backwards and justify the value. If that's not what they want then they'll probably tell you.

Often people don't need what they are asking for. This is especially true of managers.
0
 

Author Closing Comment

by:Maliki Hassani
ID: 40021522
Thanks.. you are right about that..
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

622 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question