# Comparing Time Series Data

Six Sigma – iSixSigma › Forums › General Forums › General › Comparing Time Series Data

- This topic has 6 replies, 5 voices, and was last updated 9 years, 2 months ago by Liu.

- AuthorPosts
- November 30, 2010 at 3:26 pm #53658
I have two sensors from two suppliers that measure temperature, pressure and conductivity of sea water at different depths.

One sensor is the reference so I want to know how the new sensor compares to the reference.

The data is non-normal and varies over time (the sensor is moving up and down through the water).

Is there a statistical tool I can use to analyze the data? I’m using MiniTab.

0November 30, 2010 at 10:18 pm #191013

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.1. Data normality is not an issue.

2. While the data you are describing has been gathered over time your question is concerned with agreement and not temporal variation therefore time series issues are not the focus of your concern.

If you want to test for simple agreement – that is to say examine the results for bias or trending you could use the Bland-Altman test.

If you want to treat one as the standard you might be able to build calibration curves but given the fact that you are varying temperature, conductivity, and depth (pressure would be a function of depth) you will have to have multiple independent sample readings at various combinations of these variables and these variable combinations would have to be such that in the data set used for calibration they were independent of one another.

0December 1, 2010 at 2:19 pm #191014Robert,

Thank you for the response. I realized after I posted that what I need to look at is a scatter plot. Pressure is the independent variablle and temperature and conductivity are a function of depth.

I read about how you could run a regression on each data set and compare the regressions using ANCOVA. The data does not fit a linear regression very well, R^2 = 5%.

I found this article that describes using a GLM with a covariate to do the analysis.

http://www.minitab.com/en-US/support/answers/answer.aspx?id=1248&langType=1033I think there may be an error for which column to use as the covairate.

0December 2, 2010 at 9:54 pm #191015

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.You say “The data does not fit a linear regression very well, R^2 = 5%.”

a) A regression of what against what?

b) Regardless of the regression – did you plot the data first to make sure that a simple linear fit made sense?

With respect to b) if you tested the sensors over a wide enough range of depth it is very likely that the response across the depth range is not a simple straight line. All measuring devices have a region of linear response and, when the things being measured fall outside their measurement specification range the plot of response against whatever is being measured becomes curvilinear.

0December 4, 2010 at 5:07 am #191016

StrayerParticipant@Straydog**Include @Straydog in your post and this person will**

be notified via email.Also consider stratification. You have more than two variables so your scatter plot can be more meaningful if you use the two most critical variables then stratify them according to additional variables. Search this site or elsewhere for techniques.

0December 8, 2010 at 12:07 am #191022

KennettParticipant@AndrewKennett**Include @AndrewKennett in your post and this person will**

be notified via email.As I understand your question you have sets of data pairs — one result from your standard and one from the new sensor, so for each parameter just run a paired t-test.

0January 6, 2011 at 7:40 pm #191111I agree with you too. If you take one sensor as reference, then what you need to do is to make a 2-sample t-test of both sensors to check p-value. That’s enough!

0 - AuthorPosts

You must be logged in to reply to this topic.