I have attached a sample file with some explanation of what I am trying to do. Any help you guys could give me would be great. I think it is something simple that I am just not trying, however, it is 2:13 AM and I am tired! Thanks for your help!
Michael
Hi,
extend the table to give you xf and x2f, then calculate sum of squares, and then SD.
See attachment
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Thank you very much that does help. I was hoping that I could do it without creating any more columns but I do not think that is possible with this software. I really appreciate it.
Michael
You can, but it does get complicated:
=SQRT((SUMPRODUCT(B3:B11,B3:B11,C3:C11)-((SUMPRODUCT(B3:B11,C3:C11)^2)/(SUM(C3:C11))))/(SUM(C3:C11)-1))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks