Search found 2 matches

by Evan
Wed Aug 02, 2006 9:13 am
Forum: ActiveX
Topic: Any function for Exponential Weighted Moving Average?
Replies: 1
Views: 4758

Any function for Exponential Weighted Moving Average?

I found the series function has Moving Average, or Exponential Average, but not Exponential Weighted Moving Average. Any idea of how to generate?
by Evan
Tue Jul 18, 2006 4:08 pm
Forum: ActiveX
Topic: How to calculate LCL, CL, UCL?
Replies: 0
Views: 5303

How to calculate LCL, CL, UCL?

How to calculate LCL, CL, UCL? What I know is UCL and LCL are CL +/- sigma. However, I don't know how to calculate CL Say a XR2 chart has 2 plots - one is Average, and another for Range. Each of these plots has its own LCL, CL and UCL lines displayed on the plot. Average plot has its own value of LC...