Hi all- Sort of. The calculation involves (n)(n+1)/2 "parts". Paste the following formula in C2 and copy down. Then sum Column C (not shown).
=B2*SUM(B$2:B2)
Row\Col Mut.Freq. Partial Sums A B C D
Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee
Last edited by leelnich; 06-28-2017 at 11:44 PM.
I am nor sure about your answers ...
I added in a (very) small sample what my data look like when I do it manually (which is impossible if you have more than 300 frequencies to multiply)
In blue are the formula I used.
Untitled-1.jpg
I hope this will help!
thank you again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks