Google Spreadsheet Post #877
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Nov 20, 2012
user mqoue said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/TKlUbRjYFqc)
Hello,
I'm trying to match up dates from store sales to the spot price of gold in order to see what level of correlation exists. I currently have two sets of data: 1) Dates and Total Sales for the day and 2) Date and Close Spot Price of Gold for the day
The issues I'm having is that some of the dates in data set 1 do not exist in data set 2
All I'm trying to do is match up the Close Spot Price of Gold from data set 2 with the Dates and Total Sales in data set 1
Here is the link to the spreadsheet:
https://docs.google.com/a/
Thank you for your help
Robert
--------------------------------------------------------------------------------
following is a solution to the problem
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Nov 20, 2012
user mqoue said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/TKlUbRjYFqc)
Merging two seperate sets of time data into one
Hello,
I'm trying to match up dates from store sales to the spot price of gold in order to see what level of correlation exists. I currently have two sets of data: 1) Dates and Total Sales for the day and 2) Date and Close Spot Price of Gold for the day
The issues I'm having is that some of the dates in data set 1 do not exist in data set 2
All I'm trying to do is match up the Close Spot Price of Gold from data set 2 with the Dates and Total Sales in data set 1
Here is the link to the spreadsheet:
https://docs.google.com/a/
Thank you for your help
Robert
--------------------------------------------------------------------------------
following is a solution to the problem
No comments:
Post a Comment