

FlashChat  Actuarial Discussion  Preliminary Exams  CAS/SOA Exams  Cyberchat  Around the World  Suggestions 
DW Simpson Global Actuarial & Analytics Recruitment 

Thread Tools  Search this Thread  Display Modes 
#21




Quote:
=SUMPRODUCT(MAX(A1:A4*(B1:B4=C1:C4))) That wasn't hard. I wasn't copying yours. I had already had that preprogrammed using a scaler in a single cell instead of a vector in column C. One easy change. Counter challenge. Given a column of probabilities in A1:A20 (summing to 1) and values in B1:B20, calculate the Coefficient of Variation of the distribution in a single cell. '=(SUMPRODUCT(A1:A20,B1:B20,B1:B20)SUMPRODUCT(A1:A20,B1:B20)^2)^0.5/SUMPRODUCT(A1:A20,B1:B20)
__________________
Come on. Let's go space truckin'. Come on! 
#23




I don't start nerd fights, I just finish them. Ok maybe I started this one. But I am still waiting for my props on post #18 herein for being the best solution and as a yet unrecognized Star Trek pun
__________________
Come on. Let's go space truckin'. Come on! 
#24




Quote:
__________________
Removed a dated athletic reference under pressure from a friend. You can still give money to help fund research on neurofibromatosis (nf). General info at www.ctf.org Team donation page here. 
#25




__________________
Come on. Let's go space truckin'. Come on! 
#26




Quote:
__________________
FSA ~ Fellow Slyder Aficionado 
#27




__________________
Carol Marler, "Just My Opinion" Pluto is no longer a planet and I am no longer an actuary. Please take my opinions as nonactuarial. My latest favorite quotes, updated Apr 5, 2018. Spoiler: 
#28




I'll sidestep your challenge, DP, but agree that your SUMSQ is the best solution to the original problem.
The reason I'll sidestep is that it appears that SUMPRODUCT can be used to replace the array formula in any situation. But to me this raises a question since it seems really odd behaviour by SUMPRODUCT. e.g. in the formula SUMPRODUCT(MAX(A1:A4*(B1:B4=C1:C4))), the inner part, MAX(A1:A4*(B1:B4=C1:C4)), appears to return a vector of 4 value, each of which equals the MAX value. At least that's what I see when I evaluate using F9. It also makes some sort of sense that it doesn't return a single value, because if it did, then one should be able to enter MAX(A1:A4*(B1:B4=C1:C4)) directly (with out CSE) and get the answer. Which one can't. So in the first formula, SUMPRODUCT seems to be receiving a vector of 4 identical values but is not summing them. This appears to be different behaviour to what you would see if you directly entered, say, SUMPRODUCT(A1:A4). In this case, A1:A4 is summed up (I guess you could argue that it's first being multiplied by a unit vector) I'm curious as to whether I've misunderstood something or whether SUMPRODUCT really does behave differently depending on the context  the context appearing to be whether it receives a direct reference to a vector or the whether it receives a vector as a result of the evaluation of some internal formula. Any thoughts? Last edited by Hedges; 10242018 at 02:14 AM.. 
#29




Quote:
__________________
Come on. Let's go space truckin'. Come on! 
Thread Tools  Search this Thread 
Display Modes  

