|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to use lookup functions to calculate statistical paras using named ranges
I have an Excel table attached with data from study in small animals.
Each line includes nr, gender, code and 3 body weights measured on Day0, D1 and D2. I like to take averages, counts (n) and stdevs for each code-group and on each Day using named ranges. However, calculating averages is no problem but for count and stdev there is a problem as I may need to used lookup functions. Can someone help me with this? Problem fields are marked in yellow backgound In the table, right from the original data, the same data or copied and sorted by code to easily calculate above parameters using simple formulas for comfirmation of used formulas. Thanks in advance Roland |
#2
|
||||
|
||||
See attached.
3 solutions. |
#3
|
|||
|
|||
Great, thanks tp p45cal
|
#4
|
|||
|
|||
Hey, would you relay the solution to be accessible to everyone that tumbles on this question?
I had a similar stdev problem. |
#5
|
||||
|
||||
|
#6
|
||||
|
||||
You could try downloading the attachment to post #2...
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
|||
|
|||
Want to extend formulae from previous attempt for means, N and sd
Thanks to p45cal this problem has been solved. However, I want to expand the formulae to individual genders male and female. Calculations of means and N are ok, I'm still suffering with sd.
I attached the updated Excel with the cells for formulae needing support in red color. Any help? Roland |
#8
|
||||
|
||||
see attached
|
#9
|
|||
|
|||
Perfect, big thans, appreciated, regards
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Use of named ranges based on cell content | Intruder | Excel | 12 | 02-25-2019 09:42 AM |
accessing individual row data in named ranges | MimiCush | Excel | 25 | 09-27-2018 01:01 PM |
Named Ranges Help | SavGDK | Excel | 5 | 05-01-2017 09:41 AM |
How to use named ranges in excel vba? | bosve73 | Excel Programming | 4 | 01-25-2012 09:26 AM |
Dynamic Named Ranges using text | hannu | Excel | 0 | 06-22-2010 04:42 PM |