• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Preparing Control Charts & usage of Appropriate Statistical Techniques

Sam RS

New Member
Hi All,
I believe there should be a Section for clarification of Statistical Concept doubts. Anyways posting it here, since it is related to a graphical technique

There is a Query or Doubt for clarification:---

To prepare Control Charts( using Line Graphs) in Excel

For preparing Control Charts, 3 measures are used viz:
a) Mean
b) UCL ( Upper Control Limit) i.e. + 3 sigma
c) LCL ( Lower Control Limit) i.e. -3 sigma

This is for Reporting purpose to understand the Current Trends within a Business related Process…

All the collected data-points/ rows/ observations/ instances are over a period of time…Most Importantly, each of these Instances/ Rows are Independent of each other i.e. a different business transaction… Again all these are values ranging from 0 to + ve values in Crores/ lakhs in $…There are NO -ve values in the given Data Table or the Dataset.

Business Case Study—

There are totally 3 parameters to be considered:
a) Lab Samples in Volumes
b) Charge Entry ( raised for each procedure or business transaction at a Healthcare centre/ hospital)
c) Total Sum of Collections

For point A, the sample is within specified range…Hence, Mean is an appropriate measure…
For pointsts b & c, however, both UCL & LCL are in diametrically wide- range of values ranging from -ve x,(6 zeroes) upto +ve(7 zeroes)…while trying to prepare Control Charts.

Preparing Control Charts may be fine with Mean as a standard measure for point a & generally in day-to-day normal cases…but not in the case of Points b & c (as described above).
Both — Mean ( or Arithmetic Mean) & Geometric Mean are ruled out for this particular scenario based on the outcomes. Geometric Mean is meant for Cumulative Financial Transactions.

Which Statistical Measure would be appropriate in the aforesaid case:
a) Median
b) Trimmed Mean OR
c) Harmonic Mean ???
Kindly elaborate upon the reasons for doing so i.e. selection of a specified Statistical Technique???
 

Attachments

  • Lab - Weekly Volumes (WtOut Formula).xlsx
    80.7 KB · Views: 6
Back
Top