Help Standardizing/Normalizing Data

[nc_waggoner]

Hello,

It's been a while since I took a Stats class, so I need to know how to normalize data like in the example below. In this case, 10 mistakes on 2 samples is far worse than 10 mistakes on 12 samples...I just need a way to view number of mistakes based on a normalized scale of samples.

Date	# of Samples	# of Mistakes
3/1/2017	2	10
3/2/2017	4	10
3/3/2017	6	10
3/4/2017	8	10
3/5/2017	10	10
3/6/2017	12	10

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[Zack Barresse]

Hi there,

The data you presented is already normalized. The concept is basically one that each row of data is boiled down to a unique record, while related records are broken out into their respective unique lists/tables. If, for example, instead of '# of samples' you had 'Sample ID', and you had repeating sets of data containing duplicate Date/# of Samples values, then we could further break out your data. Other than that, I'm not entirely sure what it is you're going after here. Could you be a bit more specific?