AnsweredAssumed Answered

Table of Norms

Question asked by Wicktor on May 3, 2018
Latest reply on May 4, 2018 by Wicktor

Hello everyone,

I have a Table with a list of Tests (one record for each test).

I need to create Table(s) with normative data for evaluating results of tests accordingly with Age and Gender.

Basic fields would be:

Age (from 5 to 19)

Gender (M or F)

Test_Name (about 50 different tests)

Expected_Value

Standard_Deviation

 

Since the Expected_Value and Standard_Deviation may change with time, I want values to be entered avoiding calculated fields.

 

Should I have one Table with 1 record for each Age and each Gender and each Test (15 x 2 x 50 = 1500 records) or should I split in two Tables ?

 

Many thanks for your suggestions,

Vic

Outcomes