« ProjectCasino day game, posted late. »

Project

  01/16/19 22:24, by Cayleigh

Google Sheets project

I wanted to learn more about google sheets functions. I chose to figure out the functions for mean, median, mean deviation, median deviation, variance, and standard deviation. I also made graphs, to show the differences in brands more easily.

In able to do the functions I needed data, so I took six different brands of organic non-dairy milk. I looked at the nutrition labels for each of the brand's unsweetened milk. Using the calories, protein, and calcium from each, I made three separate graphs: one comparing the calories of each brand, one comparing the protein, and the last comparing calcium.

Then I went online to learn how to do each function that I wanted to figure out. I only took one set of data at a time (calories, protein, and calcium) to use for my functions, so I ended up with three sets of each different function. I first started out by doing the mean absolute deviation by hand. This involves finding the mean of your data, then taking the absolute value of each number of the data set minus the mean, then taking the mean of all those absolute values. Once figuring out the function in google sheets, I made sure the answers matched before doing the rest of the functions. Thank you for taking the time to read through. I really like using google sheets, I find it really fascinating, so this was a fun project for me. 

Here is the link to my spreadsheet: https://docs.google.com/spreadsheets/d/1m9MBzNbNTn10Uz7s43Fw3ydovrYQY4pmJ-RV9xJDJk4/edit?usp=sharing

(If the above URL is not a link, copy and paste into google)

 

 

14 comments

Comment from: [Member]

10/10

01/16/19 @ 22:50
Comment from: [Member]

This is really cool, Cayleigh.
9/10

01/17/19 @ 08:12
Comment from: [Member]

9/10

01/17/19 @ 09:29
Comment from: [Member]

I give it a 9/10, sounds really interesting. I wanted to let you know the link isn´t working, it is just showing up as regular words.

01/17/19 @ 09:33
Comment from: [Member]

9/10

01/17/19 @ 11:16
Comment from: [Member]

9/10

01/17/19 @ 14:12
Comment from: [Member]

Original.

9/10.

01/17/19 @ 15:07
Comment from: [Member]

8/10

01/17/19 @ 16:31
Comment from: [Member]

9/10.

Very detailed.

01/17/19 @ 17:38
Comment from: [Member]

Informative. I like it.
8/10

01/17/19 @ 21:24
Comment from: [Member]

Fun idea

9/10

01/17/19 @ 21:53
Comment from: [Member]

8/10

01/17/19 @ 22:35
Comment from: [Member]

8/10

01/17/19 @ 23:31
Comment from: [Member]

10/10

01/18/19 @ 07:34


Form is loading...

April 2019
Sun Mon Tue Wed Thu Fri Sat
 << <   > >>
  1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30        

Search

Random photo

Second Guesses

  XML Feeds

Blog software

©2016 Laurel Charter School