Comparing Data from Rotary Arm Sensor to Theoretical Square Wave

Click For Summary
SUMMARY

The discussion focuses on overlaying a theoretical square wave onto collected data from a rotary arm sensor to analyze discrepancies. The user collected 5000 data points and seeks guidance on how to plot both datasets in Excel. The solution involves entering the theoretical square wave data into Excel and creating a second data series on the same chart for comparison. This method allows for a visual representation of the differences between the actual sensor data and the ideal square wave pattern.

PREREQUISITES
  • Understanding of rotary arm sensor data collection
  • Proficiency in Excel for data plotting
  • Knowledge of theoretical square wave characteristics
  • Basic skills in data analysis and visualization
NEXT STEPS
  • Research how to generate theoretical square wave data for specific parameters
  • Learn advanced Excel charting techniques for data comparison
  • Explore data analysis methods to quantify discrepancies between datasets
  • Investigate sensor calibration techniques to improve data accuracy
USEFUL FOR

Engineers, data analysts, and researchers working with sensor data and those interested in data visualization techniques in Excel.

mpm166
Messages
14
Reaction score
0
I have collected 5000 points of data from a sensor on a rotary arm (which I was trying to control to move with a position time graph that follows the pattern of a square wave)

My question is, once I've plotted the graph in excel, how can I overlay a perfect (theoretical) square wave to show the discrepencancies in the collected data from the desired setpoint?
 
Engineering news on Phys.org
Do you know the position vs. time data for the perfect square wave?

Enter them into excel, and create a second data series on the same chart.
 

Similar threads

  • · Replies 4 ·
Replies
4
Views
9K
Replies
2
Views
2K
  • · Replies 12 ·
Replies
12
Views
4K
  • · Replies 3 ·
Replies
3
Views
4K
  • · Replies 8 ·
Replies
8
Views
2K
  • · Replies 4 ·
Replies
4
Views
6K
  • · Replies 4 ·
Replies
4
Views
2K
  • · Replies 7 ·
Replies
7
Views
1K
  • · Replies 10 ·
Replies
10
Views
3K
  • · Replies 9 ·
Replies
9
Views
12K