GPS, irregular area under graph project

Click For Summary
SUMMARY

The discussion focuses on calculating the area under a curve representing speed (MPH) over time (hrs) using data from a GPS track in a GPX file. The user is exploring methods such as Riemann sums, lines of best fit, and segmenting the graph to find the area accurately. The suggested approach involves using Excel to compute a left-hand Riemann sum by organizing time and speed data into columns and performing calculations to estimate the area under the curve. The user seeks insights on the accuracy of this method.

PREREQUISITES
  • Understanding of Riemann sums and their applications in calculus
  • Familiarity with handling GPX files and extracting data
  • Proficiency in Excel for data manipulation and calculations
  • Basic knowledge of graphing and interpreting speed vs. time data
NEXT STEPS
  • Research advanced techniques for numerical integration, such as Simpson's Rule
  • Learn how to visualize data using graphing tools like Matplotlib in Python
  • Explore methods for improving accuracy in Riemann sums
  • Investigate GPS data processing libraries, such as GPSBabel or GDAL
USEFUL FOR

This discussion is beneficial for students in calculus, data analysts working with GPS data, and anyone interested in numerical methods for estimating areas under curves.

kvon989
Messages
2
Reaction score
0
Hello,

I am trying to solve a calculus problem, and do not know quite how to approach it.
I am doing a project on a GPS track, I have mapped out an area with GPS, the GPX file gives speed, lat, long, time and some other data. I am comparing the area under the curve of MPH(Y axis) and Time(hrs X-axis) with the arc length of the traveled path compared to actual distance traveled via car odometer.

I have completed the data gathering, and am having difficulties approaching the graph, and finding the area under the curve to find the distance.

The Graph is attached.

My approaches:

1. Separate the points and find the area under each and every 2 points
Although this would work, it would take me a very long time.

2. Finding lines of best fit, possibly splitting up the graph into multiple sections and finding lines of best fit, but they again, the accuracy would not be the greatest.

3. Using Reimons sum or a modification of it.

Note: Their are 203 points...

Any insight, tips, or suggestions would be extremely helpful.

Thanks
 

Attachments

  • Screen Shot 2012-03-19 at 4.23.33 PM.png
    Screen Shot 2012-03-19 at 4.23.33 PM.png
    16.3 KB · Views: 503
Physics news on Phys.org
How is this data saved? You can do a Riemann sum on your computer fairly easily probably... for example if you have a csv file (or anything else you can open in excel) you have two columns:
col A is time stamps
col B is speeds

for col C entry j is colA(entry j+1)-colA(entry j).
Then colD(entry j) = colB(entry j)*colC(entry j)
sum(colD) is a left hand Riemann sum
 
It is an excel file, I will try this now.

How accurate will the area be?
 

Similar threads

  • · Replies 2 ·
Replies
2
Views
3K
  • · Replies 24 ·
Replies
24
Views
4K
  • · Replies 8 ·
Replies
8
Views
2K
  • · Replies 8 ·
Replies
8
Views
3K
  • · Replies 15 ·
Replies
15
Views
3K
  • · Replies 3 ·
Replies
3
Views
2K
  • · Replies 2 ·
Replies
2
Views
3K
  • · Replies 14 ·
Replies
14
Views
3K
  • · Replies 2 ·
Replies
2
Views
1K
  • · Replies 3 ·
Replies
3
Views
2K