+ Reply to Thread
Results 1 to 4 of 4

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

  1. #1
    Registered User
    Join Date
    05-17-2014
    MS-Off Ver
    Excel 2003
    Posts
    2

    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!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,827

    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. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    30,754

    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?
    Glenn



  4. #4
    Registered User
    Join Date
    05-17-2014
    MS-Off Ver
    Excel 2003
    Posts
    2

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Google Distance Matrix API - Distance and Time
    By rtcwlomax in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-18-2014, 08:42 PM
  2. Variable Distance Rankings
    By NicholasL in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-16-2013, 11:46 AM
  3. Charting formula results
    By Philb1 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 09-01-2011, 07:43 AM
  4. Distance rate calculator
    By truman40 in forum Excel General
    Replies: 7
    Last Post: 11-23-2009, 04:49 PM
  5. Need help with formula for charting results
    By SRS in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 11-28-2005, 01:10 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1