Case Study – Mom Needing Help on Science Fair Graphs/Charts

I saw this posting on the ExcelForum site.  Please read it, copy it to Excel and give some thought on how you would handle this challenge.  Remember, a kid’s future is at stake Smile.   This is right out of the posting.  No file sample, no drawing, and no other information.

So, what Excel solution would you develop for this chart request?

Leave a comment with your ideas.  Tomorrow I will post my solution and a detailed step-by-step Excel tutorial and video demonstration.  Good luck!

 

Help with Science Fair Graphs/Charts

Hoping someone can help an overwhelmed mom help her child create graphs for Science Fair – yes, it should be taught in school….

I can do basic charts, but I have 2 test subjects that did 3 trials of 3 sports using a video game substitute and then the real sport. The data we have includes the number of steps taken and the before and after pulse rates. I have absolutely NO CLUE how to do a chart to compare the data. My data is below but it did not copy exactly as it is in the data table.

What I came up with so far is 3 separate column charts showing the increase in pulse rates for each sport, but it would be nice if I could get the data into a single graph with all 3 sports on one. I am totally lost, in over my head.

Many thanks if anyone steps up to help.

Subject A
Wii Sports Real Sports
Pulse Before Pulse After Steps Taken Pulse Before Pulse After Steps Taken
Tennis
Trial 1 80 88 10 80 120 1119
Trial 2 80 84 11 88 128 1242
Trial 3 84 88 10 84 124 1181

Bowling
Trial 1 84 88 5 84 88 246
Trial 2 80 84 6 80 88 263
Trial 3 80 80 7 82 88 255

Baseball
Trial 1 80 84 19 96 112 887
Trial 2 80 88 20 80 96 961
Trial 3 84 88 20 88 104 924

 

Subject B
Wii Sports Real Sports
Pulse Before Pulse After Steps Taken Pulse Before Pulse After Steps Taken
Tennis
Trial 1 64 96 14 68 72 1028
Trial 2 68 96 46 68 88 2316
Trial 3 72 100 50 64 88 1678

Bowling
Trial 1 76 120 26 60 64 199
Trial 2 68 100 37 62 84 350
Trial 3 72 128 29 66 88 225

Baseball
Trial 1 76 96 22 64 104 825
Trial 2 72 112 26 64 108 1058
Trial 3 72 124 17 68 112 987

Leave a comment with your thoughts. I will post my solution tomorrow with a detailed Excel tutorial.





Steve=True





Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy

LEAVE A REPLY

Please enter your comment!
Please enter your name here