How to Calculate a Trend for Binary Time Series Data?

  • Context: Undergrad 
  • Thread starter Thread starter IMK
  • Start date Start date
Click For Summary
SUMMARY

This discussion focuses on calculating trends in binary time series data, specifically a sequence of binary values such as "000100111100010010101111000010101010101010000010111110000110". The user, IMK, seeks a method to visualize the trend, akin to adding a trend line in Excel to assess the rise or fall of ones versus zeros. The conversation highlights the simplicity of the arithmetic involved in determining these trends, emphasizing the need for a straightforward reference.

PREREQUISITES
  • Understanding of binary time series data
  • Familiarity with Excel graphing techniques
  • Basic arithmetic skills for trend calculation
  • Knowledge of trend analysis concepts
NEXT STEPS
  • Research methods for visualizing binary data trends in Excel
  • Learn about statistical trend analysis techniques
  • Explore time series analysis tools like R or Python's Pandas
  • Investigate the use of moving averages for binary data
USEFUL FOR

This discussion is beneficial for data analysts, statisticians, and anyone working with binary time series data who seeks to understand trend analysis and visualization techniques.

IMK
Messages
61
Reaction score
0
Hello,
So how do calculate a trend please for a set of time series data where the data values are binary thus:

000100111100010010101111000010101010101010000010111110000110

I know this must be real simple but I can’t seem to find a simple reference.
Many thanks IMK
 
Physics news on Phys.org
What do you mean by a "trend" here?
 
HallsofIvy said:
What do you mean by a "trend" here?

Hello HallsofIvy and many thanks for your reply.
The best way I can describe what I mean be the Trend is as if you plot the data sequence as a graph in Excel and then add a trend line you can see if the number of one's to zero's is rising or falling. Any I had a soak in the bath on the problem and well I think it is simple arithmatic, unless I have mist something.
IMK
 

Similar threads

Undergrad Time series analysis and data transformation
  • · Replies 8 ·
Replies
8
Views
2K
Undergrad Time series and why would we remove seasonality and trend?
  • · Replies 10 ·
Replies
10
Views
4K
Undergrad Stationary time series with seasonality...
  • · Replies 8 ·
Replies
8
Views
3K
High School How is the harmonic mean affected by additional data points?
  • · Replies 4 ·
Replies
4
Views
2K
Undergrad Filling in Missing Values in a string of data
  • · Replies 7 ·
Replies
7
Views
1K
Undergrad Looking for advice in clusterization
  • · Replies 2 ·
Replies
2
Views
2K
Undergrad Extracting characteristics from time series data
  • · Replies 3 ·
Replies
3
Views
2K
Undergrad What are the commonly used estimators in regression models?
  • · Replies 23 ·
Replies
23
Views
4K
Undergrad Fit a non-linear function to this time series
  • · Replies 6 ·
Replies
6
Views
1K
Undergrad Regression Prediction with Time Series Data
  • · Replies 1 ·
Replies
1
Views
2K