Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a doozy! I have been asked to breakout an R2 calculation...well,
when I did and "put" the numbers back together. They do not match... The numbers a Original R2 #: 0.293. The breakouts a 0.311, 0.284, 0.0857 which when "put" back together comes up to: 0.234. The instantances for each of these numbers a 126, 127, 106 respectively. The difference between the original R2 and the "put" together is 0.058519. I have used sumproduct, average, sum etc...but I cannot match the numbers up... Anyone have any ideas on this and how to make equal?? Thanks, Hans |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sports Comp Ladder tabulating help needed | Excel Worksheet Functions | |||
Little more help needed for my IF formula | Excel Discussion (Misc queries) | |||
Needed: worksheet export help | Excel Discussion (Misc queries) | |||
VLOOKUP help needed! | Excel Worksheet Functions | |||
Custom percent format needed | Excel Worksheet Functions |