| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
determining variance in percentages
John was in school for 23 out of 30 days last month, which means he was in
school 76.66% of the days. We expected him to be in school for 28 days, or 93.33% of the days. How do I calculate the variance in the percentages? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
determining variance in percentages
Try this
=(A2/B2)/(C2/B2) Format as % Where A2= actual attendance - 23 B2= Max attendance - 30 C2= optimum attandance - 28 Mike "emaypsu" wrote: John was in school for 23 out of 30 days last month, which means he was in school 76.66% of the days. We expected him to be in school for 28 days, or 93.33% of the days. How do I calculate the variance in the percentages? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
determining variance in percentages
How about this scenario?
attended 23 days out of expected 30, for 76% projected 25 days out of expected 28 for 89% does your formula differ? "Mike H" wrote: Try this =(A2/B2)/(C2/B2) Format as % Where A2= actual attendance - 23 B2= Max attendance - 30 C2= optimum attandance - 28 Mike "emaypsu" wrote: John was in school for 23 out of 30 days last month, which means he was in school 76.66% of the days. We expected him to be in school for 28 days, or 93.33% of the days. How do I calculate the variance in the percentages? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
determining variance in percentages
Hi,
No it doesnt. I have to confess I don't understand the reasoning that gives 100% attendance score if attendance is only 28 out of 30 days but that's your logic not mine. Mike "emaypsu" wrote: How about this scenario? attended 23 days out of expected 30, for 76% projected 25 days out of expected 28 for 89% does your formula differ? "Mike H" wrote: Try this =(A2/B2)/(C2/B2) Format as % Where A2= actual attendance - 23 B2= Max attendance - 30 C2= optimum attandance - 28 Mike "emaypsu" wrote: John was in school for 23 out of 30 days last month, which means he was in school 76.66% of the days. We expected him to be in school for 28 days, or 93.33% of the days. How do I calculate the variance in the percentages? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
determining variance in percentages
Thanks. I was using this scenario to apply it to what I was actually
calculating. I appreciate your help. -- Elaine "Mike H" wrote: Hi, No it doesnt. I have to confess I don't understand the reasoning that gives 100% attendance score if attendance is only 28 out of 30 days but that's your logic not mine. Mike "emaypsu" wrote: How about this scenario? attended 23 days out of expected 30, for 76% projected 25 days out of expected 28 for 89% does your formula differ? "Mike H" wrote: Try this =(A2/B2)/(C2/B2) Format as % Where A2= actual attendance - 23 B2= Max attendance - 30 C2= optimum attandance - 28 Mike "emaypsu" wrote: John was in school for 23 out of 30 days last month, which means he was in school 76.66% of the days. We expected him to be in school for 28 days, or 93.33% of the days. How do I calculate the variance in the percentages? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Variance | Excel Discussion (Misc queries) | |||
| Variance Column | Excel Discussion (Misc queries) | |||
| variance % | Excel Worksheet Functions | |||
| Pivot Tables - Variance and Variance % | Excel Discussion (Misc queries) | |||
| Pivot Tables - Variance and % Variance fields | Excel Discussion (Misc queries) | |||
Linear Mode
