LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pm pm is offline
external usenet poster
 
Posts: 122
Default Normalizing data?

Hi everyone. I have a collection of 32 values from an experimental group
(16) and a control group (16). Each set of data was taken over 4 days. So,
for example, Day1 I did experimental 1-4 and control 1-4. Day2, experimental
5-8, control 5-8, etc....

My data collection tool can be calibrated differently on each day
(potentially). I am looking for a way to normalize this data. Any
suggestions? Ideally, if Day 1's control avg was 24 and Day 2's was 27, I'd
like to normalize all of Day 1 and Day 2 based on the control values for that
day.

Thanks in advance....it's been awhile since stats!
 
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
normalizing data Vance New Users to Excel 3 August 16th 09 12:25 AM
Normalizing Data k1ngr Excel Discussion (Misc queries) 6 December 17th 08 03:21 PM
normalizing data -- a twist Brad Excel Worksheet Functions 6 June 4th 05 03:42 PM
normalizing data 4gokycats Excel Discussion (Misc queries) 1 March 27th 05 03:09 AM
Normalizing data formula? Jessica Excel Discussion (Misc queries) 1 January 25th 05 10:48 PM


All times are GMT +1. The time now is 01:43 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"