Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have two sets of data (2 very large columns) same type, same source,
different data sets. One set is correct the other (that I want to normalize) has a +10 shift in the (arithm.) mean and +8 difference in the Stand. Dev I do the normalization now with histograms by subtracting 10 from the data that I normalize till I get a perfect histogram overlay (bell) How to do this with a statistical function in Excel? I tried STANDARDIZE using the array to normalize for A1 (variable) and constants for A2 and A3 (mean and Stand. Dev. computed from the the coreect data set) but the value that I obtain makes no sense. Anyone can help me with this problem? -- Frank |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Normalize frequency | Excel Discussion (Misc queries) | |||
Q: Using lookups to normalize a database? | Excel Discussion (Misc queries) | |||
Normalize the second pie in a pie of pie chart | Charts and Charting in Excel |