7 Replies Latest reply: Feb 8, 2016 6:11 PM by Sunny Talwar

# Mean and Stdev in Straight Tbale

i am attaching sample excel file and i have, and it is a straight table

dimension: assignedpcp

expression1(member count): count(Distinct memnbr)

expression2(inpatient):  sum(costinpatient)/count(Distinct memnbr)   // [costinpatient also a dimension]

No i need to write two more expressions :

mean (86851.43/642=1353) ,[ 642 is count(Distinct Assignedpcp and 86851.43 is the total of column inpatient)]

and

stdev .

The Expected  values of mean and stdev  are in the attached excel sheet.

• ###### Re: Mean and Stdev in Straight Tbale

I don't understand your calculation of Standard deviation in the attached Excel file. Can you check if it is correctly done?

• ###### Re: Mean and Stdev in Straight Tbale

okay I will..

Thank you.

• ###### Re: Mean and Stdev in Straight Tbale

Thank you

• ###### Re: Mean and Stdev in Straight Tbale

Hi sunny see the image attached so that u can get an idea of what i need in stdev column exactly

Thank you

• ###### Re: Mean and Stdev in Straight Tbale

Script:

Table:

[Member Count],

Inpatient,

Mean,

Stdev

FROM

NewStdev.xls

(biff, embedded labels, table is Sheet1\$);

FinalTable:

[Member Count],

Inpatient,

Mean,

Stdev

Resident Table

Order By APCP desc;

DROP Table Table;

Straight Table

Dimension: AssignedPCP

Expressions

=Avg(TOTAL Inpatient)

=Aggr(RangeStdev(Above(Inpatient, 1, RowNo())), AssignedPCP)

Chart on the left is a table box using the data from Excel. Chart on the right is where I am calculating the same thing in the chart.

• ###### Re: Mean and Stdev in Straight Tbale

I am not importing data from Excel i am importing from sql but i want the same results as u did  inpatient field is not there in data its a label i named  in straight table for the expression  Sum(costinpatient)/count(distinct memnbr),.

• ###### Re: Mean and Stdev in Straight Tbale

May be if you share the raw data it would be easier to help.