7 Replies Latest reply on Jan 3, 2014 2:36 AM by Jan Siroky

    Time series - scatter plot of daily sums and averages

    Jan Siroky

      I have time series data with energy consumption and outside temperature (sample each 5 minutes). I need to investigate relation between daily energy consumption (sum) and daily average outdoor temperature.

       

      The only way I found so far is the following. Draw lines chart with two lines (daily sum of en. consumption and daily average of outside temp.). Then copy the data and past them as a new data source. Then I can draw the scatter plot I need and and try to find a polynomial model.

       

      Is there easier way how to do this?

       

      Thank you,

      Jan