MrExcel Message Board


Go Back   MrExcel Message Board > Question Forums > Excel Questions

Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old Mar 30th, 2004, 07:09 AM   #1
dneunabe
 
Join Date: Feb 2004
Posts: 12
Default Simple question. Calculating Z scores

I am trying to assign values to two cells (e.g. mean and standard deviation) based on values in three others cells, containing age, education, and gender. E.G. the value for the mean in cell B12 is assigned based on the age range of a person, their educational status (also a range), and their gender. Hence, the value in a cell is conditional based on three conditions. I have a 3 way table, so it is a matter of the formula "telling" which number belongs in my formula for calculating standard scores based on means and SDs--e.g. simple z-score calculations.

as an aside, does the Excel for Scientists from Mr. Excel solve this type of problem?

Thanks much!
dan neunaber
__________________
Dan
dneunabe is offline   Reply With Quote
 

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump


All times are GMT +1. The time now is 07:31 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
All contents Copyright 1998-2009 by MrExcel Consulting.