Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 170
Default Normalize

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Normalize frequency Knowledge001 Excel Discussion (Misc queries) 1 November 22nd 05 12:20 AM
Q: Using lookups to normalize a database? Charles W. Stricklin Excel Discussion (Misc queries) 2 September 2nd 05 02:24 PM
Normalize the second pie in a pie of pie chart Judy Charts and Charting in Excel 1 January 21st 05 11:48 AM


All times are GMT +1. The time now is 04:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"