Tides Scatter Graph

**andrewe123** · 04-20-2016, 04:41 PM

Hi All,
I am doing Geography Coursework and could really use some help with a scatter graph. I have 3 pieces of information:
1) dates
2) data on tides supplied by Scotland
3) data on tides provided by the MET office

Basically, the end aim is to get a scatter plot and trend line with equation to find the relationship between them and hence predict the data for the MET office as the data for 3 months is missing.
The data for the MET office is significantly smaller than for Scotland.
The lecturer said I should only use two columns of data and plot one against the other but I don't understand how.
I have already been told that this attempt is wrong and by only using two columns (Scottish and MET) I lose a set of data and have no reference for dates scatter.PNG
PLEASE HELP! My Lecturer wont give me any more guidance!

**MrShorty** · 04-20-2016, 04:58 PM

As my own nudge in the direction I think your lecturer wants you to go -- Is date/time really all that important to the problem? Sure we can see that Scottish is a function of date/time and MET is a (different) function of date and time, but is date/time really essential to finding the relationship between Scottish and MET? (What do you see if you plot MET on the Y axis and Scottish on the X axis?)