Standard Deviation Logic

Question

Need some ideals. I have data and i want to create a standard deviation base off of the data. Im going to give you a example below:
I want to take the values and produce a standard deviation report by test via each parameter, im using microsoft reporting services rdlc when th id is 1, thats a indication that test started
over. Take a look the output im trying to produce below under "OutPut" what would the best way to go about this

Raw Data:

ID	Test	Param	Values
1	Apple	Black	3
2	Apple	Orange	4
3	Apple	Yellow	1
4	Apple	Blue	5
5	Apple	Red	3
1	Apple	Black	1
2	Apple	Orange	2
3	Apple	Yellow	5
4	Apple	Blue	5
5	Apple	Red	2
1	Grapes	Black	2
2	Grapes	Orange	3
3	Grapes	Yellow	1
4	Grapes	Blue	4
5	Grapes	Red	4
6	Grapes	Purple	2
7	Grapes	Violet	3
8	Grapes	Green	1
9	Grapes	RedOrange	2
10	Grapes	PurpleBlue	3
11	Grapes	DarkGreen	4
1	Grapes	Black	2
2	Grapes	Orange	3
3	Grapes	Yellow	1
4	Grapes	Blue	4
5	Grapes	Red	4
6	Grapes	Purple	2
7	Grapes	Violet	3
8	Grapes	Green	1
9	Grapes	RedOrange	2
10	Grapes	PurpleBlue	3
11	Grapes	DarkGreen	4

"OUTPUT"

ID	Test	Param	Values	Values	StdDev
1	Apple	Black	3	1	?
2	Apple	Orange	4	2	?
3	Apple	Yellow	1	5	?
4	Apple	Blue	5	5	?
5	Apple	Red	3	2	?


1	Grapes	Black	2	2	?
2	Grapes	Orange	3	3	?
3	Grapes	Yellow	1	1	?
4	Grapes	Blue	4	4	?
5	Grapes	Red	4	4	?
6	Grapes	Purple	2	2	?
7	Grapes	Violet	3	3	?
8	Grapes	Green	1	1	?
9	Grapes	RedOrange	2	2	?
10	Grapes	PurpleBlue	3	3	?
11	Grapes	DarkGreen	4	4	?

Shahan Ayyub · Answer

Hi! Please check this image to calculate the standard deviation of values. Instead of SUM the control also provides STDEV Function. Is this helpful ???

Shahan Ayyub · Answer

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???

David Smith · Answer

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

David Smith · Answer

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

Shahan Ayyub · Answer

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 ???

David Smith · Answer

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

Shahan Ayyub · Answer

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 ??

David Smith · Answer

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

David Smith · Answer

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.

Shahan Ayyub · Answer

Hi! Please check this image to calculate the standard deviation of values. Instead of SUM the control also provides STDEV Function. Is this helpful ???

Shahan Ayyub · Answer

Hi! Please check this image to calculate the standard deviation of values. Instead of SUM the control also provides STDEV Function. Is this helpful ???

David Smith · Answer

Thanks for responding. I have visual 2010 already. I already have the report control  and datasource . but now i want to get the standard deviation i dont wont the sum. so how would i do that? I know there are aggregate function call stdev. im trying to see how to apply the stdev function in my situation. i have the first report already. now im trying to create stdev report using the same dataset as my first report

Shahan Ayyub · Answer

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 ???