Hello everyone. I am a chemistry student, and my class recently released a high altitude weather balloon. There were several "pods" connected to the weather balloon, each monitoring different variables: pressure, temperature, altitude, etc. Each pod collected altitude and then one of these variables. We would like to be able to compare these variables, however we have a problem. Each pod measured its variable at different times, so the different variables don't "match up" from pod to pod. I was able to correct this by using the altitude data to align all of the variables, however we now have "gaps" in our data. I've attached a screen shot as an example. I've created trendlines for the different variables using "moving average" for the type of trendline. Is there some way for me to extract these values from the trendline so I can created a new spreadsheet without gaps? Any help would be wonderful, and I'm sorry if anything is unclear, I'll be happy to clarify. Thanks!
Bookmarks