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

Undergrad Calculate the Angular Velocity of an Arm from a Data Set
  • · Replies 4 ·
Replies
4
Views
9K
I need help, please, designing a pool sensor for breaking . . .
  • · Replies 2 ·
Replies
2
Views
2K
MATLAB MATLAB Code For Analyzing Experimental Data
  • · Replies 12 ·
Replies
12
Views
4K
MATLAB MATLAB API For Wave Flume Data Analysis
  • · Replies 3 ·
Replies
3
Views
4K
Graphing the Superposition of Two Standing Waves
  • · Replies 8 ·
Replies
8
Views
2K
Tri Axis Accelerometer Data Help
  • · Replies 4 ·
Replies
4
Views
6K
Plotting a Scatter Diagram from a Large Data Set
  • · Replies 4 ·
Replies
4
Views
2K
Undergrad Finding power figures from graph data
  • · Replies 7 ·
Replies
7
Views
1K
Undergrad Data analysis - Comparing temperature data from multiple sources
  • · Replies 10 ·
Replies
10
Views
3K
Time Constant ≠ Time constant from experiment
  • · Replies 9 ·
Replies
9
Views
12K