DID
New member
- Joined
- Jan 14, 2014
- Messages
- 15
- Reaction score
- 0
- Points
- 0
Hello everybody, Im new here, but has been following the forum for some time.
I really hope that today you can help me with the formula I need for Excel here is my setup:
I have several data sets (up to 600.000 rows in total). In column A, I have a number (e.g. 1) represents data set 1 (i.e. row #2 till row #3.000 all marked as "1" i Column A). Data set 2 i represented as "2" still in column A, but ranging from row #3001 till ca #6000. And so it continues up to ca. 600.000, where I have ca. 3500 data sets. In Column B I have the corresponding results from the different data sets.
Now, I would like to make a formula for determining the Standard deviation and Variance for the different data sets corresponding results.
In other words, what I would like to the program to do is: "For all the "1"'s in Column A, I want to calculate the Variance and Std.Dev., and for all the "2" in Column A..... etc"
I really hope that you understand what I mean, and that you are able to help me...
All the best,
DID
I really hope that today you can help me with the formula I need for Excel here is my setup:
I have several data sets (up to 600.000 rows in total). In column A, I have a number (e.g. 1) represents data set 1 (i.e. row #2 till row #3.000 all marked as "1" i Column A). Data set 2 i represented as "2" still in column A, but ranging from row #3001 till ca #6000. And so it continues up to ca. 600.000, where I have ca. 3500 data sets. In Column B I have the corresponding results from the different data sets.
Now, I would like to make a formula for determining the Standard deviation and Variance for the different data sets corresponding results.
In other words, what I would like to the program to do is: "For all the "1"'s in Column A, I want to calculate the Variance and Std.Dev., and for all the "2" in Column A..... etc"
I really hope that you understand what I mean, and that you are able to help me...
All the best,
DID