How to get output from time t

[Joshua Samuel Wolsey]

Hello all

I'm still a fairly novice STATA user and my instructors either have no experience with STATA or aren't available. I've attempted to search for the answer online but found that I simply do not know enough about STATA in order to ask the right question and get the right answer.
I'm about to do a project with some Rate of Force Development calculations and was hoping STATA could make it a lot easier.

I want to group the data in sets of time, so from 0-10ms (1,2,3,4...10), with the corresponding force for each point in time.
The data I'll be working on will be exported to an Excel-sheet with time in ms and the corresponding force exerted at that time.
E.g.

time (ms)	Force (Nm)
1	50
2	75
3	100

My goal is to calculate an average force/time, so I wanted to take segments of the total recording and do calculations on each of them but the total recording might be around 15 seconds long sampled at 1000hz, so a lot of data I dont need. If there was a way to segment the data I need from the noise, I'd save myself a lot of grunt work.

So my question is: Is this possible in STATA and how would one do it?

Thanks in advance!


- Joshua

[Jared Greathouse]

Please watch this.

[Joshua Samuel Wolsey]

Please watch this.

I appreciate the video, I've yet any data to present so my question was a methodological one.
If it's too abstract, I'll return once I have some actual data to present.

[Jared Greathouse]

Yeah this is super abstract, get some data and then return here to this post.

Answering questions on Statalist is a little like making a risotto. I need (in general) both a) code that's been attempted and b) data that illustrates the problem. If I told you "Make me mushroom risotto" but I didn't give you the recipe, you'd likely be like "Uhhhhhh how, I don't know the recipe you're looking for." in 99.9% of cases, there needs to be example data and code provided, unless you're asking purely theoretical stats questions/software questions that have no basis in analysis.