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 .   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