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.