The Straight Dope

Go Back   Straight Dope Message Board > Main > General Questions

Reply
 
Thread Tools Display Modes
  #1  
Old 04-14-2012, 03:30 AM
Dog80 Dog80 is offline
Guest
 
Join Date: Dec 2003
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?
Reply With Quote
Advertisements  
  #2  
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.
Reply With Quote
  #3  
Old 04-14-2012, 03:37 AM
penultima thule penultima thule is offline
Guest
 
Join Date: Apr 2009
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.
Reply With Quote
  #4  
Old 04-14-2012, 09:19 AM
ultrafilter ultrafilter is offline
Guest
 
Join Date: May 2001
Quote:
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.
Reply With Quote
Reply

Bookmarks

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 07:20 AM.


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

Send questions for Cecil Adams to: cecil@chicagoreader.com

Send comments about this website to: webmaster@straightdope.com

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: sdsubscriptions@chicagoreader.com.

Copyright 2013 Sun-Times Media, LLC.