Thread Tools Display Modes
Old 04-14-2012, 03:30 AM
Dog80 Dog80 is offline
Join Date: Dec 2003
Location: Athens, Greece
Posts: 3,354
How to normalize two sets of values for comparison?

I have two sets of values. The first is crude oil barrel price and ranges from 20 to 150. The other set is gasoline price per liter before taxes and this ranges from 0.30 to 0.80.

I want to make a graph that compares the two prices and see if the peaks and valleys match.

I tried that on Excel yesterday, but while the first range appeared nicely, the second range was almost a flat line. Apparently I have to do some kind of manipulation to amplify the second range so the two can be compared.

Any ideas?
Old 04-14-2012, 03:35 AM
nivlac nivlac is offline
Charter Member
Join Date: May 2001
Location: Golden State
Posts: 2,356
Read up on z-values or z-scores.
Old 04-14-2012, 03:37 AM
penultima thule penultima thule is online now
Join Date: Apr 2009
Location: Sydney, Australia
Posts: 2,365
You have set oil on the Y1 axis and gasoline on the Y2?
Then adjust the max & min values in the formatting of each Y axis.
Old 04-14-2012, 09:19 AM
ultrafilter ultrafilter is offline
Join Date: May 2001
Location: In another castle
Posts: 18,988
Originally Posted by nivlac View Post
Read up on z-values or z-scores.
Exactly. There's even an Excel function to compute these, so you don't have to do anything fancy here.


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

All times are GMT -5. The time now is 09:09 AM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2018, vBulletin Solutions, Inc.

Send questions for Cecil Adams to:

Send comments about this website to:

Terms of Use / Privacy Policy

Advertise on the Straight Dope!
(Your direct line to thousands of the smartest, hippest people on the planet, plus a few total dipsticks.)

Publishers - interested in subscribing to the Straight Dope?
Write to:

Copyright 2018 STM Reader, LLC.

Copyright © 2017