LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 37
Default Normalizing/Standardizing Data

Hi,

I am comparing data from 2008 and 2009 but want to ensure I am not comparing
apples & oranges. I am hoping some one can help me.
2009:
10 projects total
8 projects done correctly
1 project done partially correct
1 project done wrong
80% done correctly
10% done partially correct
10% done wrong

2008:
13 projects total
12 projects done correctly
1 project done partially correct
1 project done wrong
92.3% done correctly
7.7% done partially correct
7.7% done wrong

Question: am I comparing apples to apples when I say 7.7% were done
incorrectly in 2008 and 10% were done incorrectly in 2009? I think the total
number of projects is skewing my data and some how I should normalize/equate
the total before doing a percentage check. What do you think?

I am also doing the same review dollar-wise and doing it dollar-wise shows
things were better in 2009 as compared to 2008. Do I need to do something
with the dollars also to make the dollars from one year to the next be equal,
or just the quantity needs to be equal? Or, not at all?

Thanks.




 
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? pm Excel Worksheet Functions 2 September 11th 09 05:24 AM
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


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