Welcome, Guest. Please login or register.

August 19, 2019, 01:28:46 pm

Author Topic: Google Sheets/graphing results help?  (Read 138 times)  Share 

0 Members and 1 Guest are viewing this topic.

catpacksnapback

  • Forum Regular
  • **
  • Posts: 83
  • The average housecat.
  • Respect: +44
Google Sheets/graphing results help?
« on: April 02, 2019, 05:15:33 pm »
0
Hi guys! Gonna (try and) make this quick.
I have a SAC due this week for Biology and I was required to make a graph showing my results. My biology teacher says the graph is fine, but here's my issue: I want to display the median on the graph - the 5 minute point across all 3 groups. Is there a way that I can do this on Google sheets? Furthermore, if you have any more advice on this graph, I would love to hear. :) Thank you.


Panicking.

2018: Media 1/2
2019: Psychology 1/2, Biology 1/2, Literature 1/2, Chemistry 1/2
The Future (probably)
2020: Biology 3/4, Literature 3/4, Chemistry 3/4, Math Methods 1/2
2021: Psychology 3/4, Math Methods 3/4, Health and Human Development 3/4
Goal: Survive (and Medicine, ideally!)
Class of 2021

MB_

  • MOTM: MAR 19
  • Forum Obsessive
  • ***
  • Posts: 255
  • Unspecified and mysterious
  • Respect: +54
Re: Google Sheets/graphing results help?
« Reply #1 on: April 02, 2019, 06:09:58 pm »
+2
I don't think there's an explicit way of showing the median on the graph. You could try changing the point type of the individual data points relating to 5 minutes. So instead of a circle, you could use a diamond or you could increase the size of the data point. You would then have to add some sort of note explaining that they signify the median.

2015-16: VCE
2017-: BSci UoM - Maths & Psych

vox nihili

  • National Moderator
  • Great Wonder of ATAR Notes
  • *****
  • Posts: 5266
  • Respect: +1359
Re: Google Sheets/graphing results help?
« Reply #2 on: April 02, 2019, 06:32:49 pm »
+2
You've already had a great answer about how to show that point (another option is to put a third line on by making another series where the x value is 5 and the y values are -1 and 11) but this is probably a bit clunky.

Just want to make a mildly anal retentive point that the five minute mark is the median, it's the midpoint of the experiment.
MED INTERVIEW TUTORING PM to secure your place early, as they fill up quickly!

Join ATARNotes Footy Tipping

2013-15: BBioMed (Biochemistry and Molecular Biology), UniMelb
2016-20: MD, UniMelb
2019: MPH, UniMelb
Year I: BIOL10002 BIOL10003 CHEM10006 MAST10011 MAST10016 PHYC10007 SPAN10001 SPAN10002
Year II: BCMB20005 BIOM20001 BIOM20002 CLAS10022 GENE20001 SPAN20020 SPAN30014
Year III: BCBM30001 BCMB30002 BCMB30010 BIOM30001 BIOM30002 PHRM30008

catpacksnapback

  • Forum Regular
  • **
  • Posts: 83
  • The average housecat.
  • Respect: +44
Re: Google Sheets/graphing results help?
« Reply #3 on: April 02, 2019, 08:46:37 pm »
0
Thank you both so much for the answers! I was wondering if there was a specific function for something like this that I had missed - I'll change the points to something spiffy in that case. :)

Just want to make a mildly anal retentive point that the five minute mark is the median, it's the midpoint of the experiment.

And always appreciative of these notes - but I'm a bit confused, did you mean the five minute mark isn't the median here? If that's what you mean, I've gotcha; I always get median confused with.. well, all the others. Hahaha! They called it the median in the coursework, but I added the distinction in my original post as I wasn't so sure either.
Panicking.

2018: Media 1/2
2019: Psychology 1/2, Biology 1/2, Literature 1/2, Chemistry 1/2
The Future (probably)
2020: Biology 3/4, Literature 3/4, Chemistry 3/4, Math Methods 1/2
2021: Psychology 3/4, Math Methods 3/4, Health and Human Development 3/4
Goal: Survive (and Medicine, ideally!)
Class of 2021