Standard Deviation Logic

Hi!

You are right that Max() can not give directly what mode does. I was thinking from different point of view. Why not you create a column in Your Database where you can calculate mode by creating a dummy column COUNT(*) and get MAX(Count(*)).

What is your backend tool???

Im a little confused the mode is the number that occur most:

example

5 3 4 5 5 6

so the mode would be 5.

so how would the Max () determine the mode. if i were use the max function it would give me 6

give me a hour and a half, and i will do so

In your this piece of Dataset you have provided in the first post what should be the value of Mode can you provide an example ??? Mode is not available directly but can be get byusing Max() function. Can you post a solved example for Mode ???

Thanks I already did it, i actually , the count, min, max, avg, stdDev, is there a way to calculate the mode?

For getting a count for a values:

Where I have told you to calculate the StDev for a value, in the same box, drag "Test" one more time and calculate "Count" for it. Now you have 2 values in "Values Listbox".

Is this helpful ??

Question reguarding the rdlc file.

How do you choose a distinct value via a string or text in the expression properties. I know how to do it for access, but how do you choose a distinct value for expression in the rdlc file.

I want to produce the output below

example:

Test          Param

black           cat
black           car
black           hat
blue            cat
blue            car
blue            hat

Output:

Test         TotalParam

black              3
blue               3

Thanks i was already doing it, im still working on the report now, instead of me grouping by columns I group by rows. Im going to group by columns  to see how it would look. but , im adding the count, min, max, avg, stddev.

im trying to see how to add the mode.

Slick while we are on this , im going to create the query in access and then automate the query to a table and then show the report from report reviewer. what do you think?

you have been so helpful.

Hi!

Please check this image to calculate the standard deviation of values.
Instead of SUM the control also provides STDEV Function.

Is this helpful ???

Hi!

Please check this image to calculate the standard deviation of values.
Instead of SUM the control also provides STDEV Function.

Is this helpful ???

Hi!

Please check this image to calculate the standard deviation of values.
Instead of SUM the control also provides STDEV Function.

Is this helpful ???

Hi!

Group columns Test and Param and then Sum Values.

I am using VS2010 Professional.

For that:

• Draw Report Control.
• Create new Report.
• Add new Datasource.
• Select Column(s) for Group, then Column(s) for Sum.
• and after finishing Wizard Bind Report with this new report.

Is this helpful ???