Charting results from a mathematics experiment - rate x time = distance + unique variable

1. Charting results from a mathematics experiment - rate x time = distance + unique variable

My 5th grade kid's science experiment is "Calculating the Speed of the Perfect Knife Throw". Unfortunately, while I'm a whiz at reading and writing, my excel and math skills are woeful, so I turn to this forum hoping someone might tender assistance.

There are four (4) factors to depict, all of which I have recorded:

1. Distances at 10', 12.5' and 15'

2. Fractions of a second it takes from the release to target impact

3. Number of attempts thrown from each distance (20 each, so there are a total of 60 attempts)

4. Whether the blade stuck into the wood target ("hit") or dropped to the ground ("miss")

I envision that the horizontal axis should be labeled "Attempts" (1-20), and the vertical axis should be labeled "Fractions of a Second" (.05, .10, .15, .20, .25, .30, .35, .40). I envision a grid indicating different fractions of second dots corresponding to each attempt, where the "hits" are one color/shape and the "misses" are another color/shape.

The excel information that my kid typed is not formatted; it's just raw data, and is therefore unreadable for purposes of presentation.

Cheers to anyone willing to send me in the best direction!

2. Re: Charting results from a mathematics experiment - rate x time = distance + unique varia

Hi Dan Harris,

I have seen the data but found incomplete & also your requirement is not clear .please provide more details .

Punnam

3. Re: Charting results from a mathematics experiment - rate x time = distance + unique varia

I don't understand what is in Column B. can you explain?

There are 20 times in D3:D22. This is a time for each throw from 15 feet. You refer to hits and misses. How can you tell which of the 20 are hits and which are misses?

4. Re: Charting results from a mathematics experiment - rate x time = distance + unique varia

Punnam and Glenn,

Thank you gentlemen for replying. The excel spreadsheet that I submitted is indeed incomplete. It represents some of the data that my kid input; column B, for instance does represent the times it took for each knife to strike the target, but all of those attempts were "misses". Other data (not currently input) from 12.5' shows 9 out of 20 hits, since the blade stuck into the wooden target. My kid didn't do that input because I could tell that it's all over the place without proper formatting.

The excel remains incomprehensible because I don't know how to format/formula the columns.

The best I can do is draw it, whereby the dots on the line graph correspond to individual attempts (20) at each distance (10, 12.5, 15... sorry, the 20 was in error), where each attempt is shown as either a "hit" (green circle) or "miss" (red square). I imagine I would need different graphs, showing different attempts at each distance. As I imagine it, each attempt's rate (speed) corresponds to the dots on the line graph.

With great appreciation for any guidance, if it can be provided.

Dan

There are currently 1 users browsing this thread. (0 members and 1 guests)