• Home
  • Free Trial
  • Sign In
  • Techdegree
  • Tracks
  • Library
  • Community
  • Support
  • Jobs
    • Newest
      • Newest
      • Active
      • Unanswered
      • Featured
    • All Topics
      • All Topics
      • • General Discussion
      • • 21st Century Skills
      • • Android
      • • APIs
      • • Business
      • • C#
      • • Computer Science
      • • CSS
      • • Data Analysis
      • • Databases
      • • Design
      • • Development Tools
      • • Digital Literacy
      • • Equity, Diversity, and Inclusion (EDI)
      • • Go
      • • HTML
      • • Java
      • • JavaScript
      • • Learning Resources
      • • Machine Learning
      • • PHP
      • • Python
      • • Quality Assurance
      • • Ruby
      • • Security
  • Anne Grader
    Anne Grader
    552 Points

    Why does google sheets sort the values in "2017" from min to max?

    Posted December 19, 2021 11:27pm by Anne Grader
    Anne Grader
    552 Points
    • Data Analysis
    • Data Analysis Basics
    • Getting to Know Your Data
    • Summarizing Data: Maximum, Minimum, Range

    1 Answer

  • nicolaspeterson
    nicolaspeterson
    8,569 Points

    Can someone explain why Ben uses absolute references?

    Posted October 21, 2021 2:12am by nicolaspeterson
    nicolaspeterson
    8,569 Points
    • Data Analysis
    • Data Analysis Basics
    • Getting to Know Your Data
    • Is Our Data Normal?

    1 Answer

  • Mason Burke
    Mason Burke
    329 Points

    I understand the process of setting up the stdev but it keeps coming up NONE or %0.00

    Posted June 10, 2021 10:25pm by Mason Burke
    Mason Burke
    329 Points
    • Data Analysis
    • Data Analysis Basics
    • Getting to Know Your Data
    • Is Our Data Normal?

    0 Answers

  • Francesco Gambardella
    Francesco Gambardella
    2,094 Points

    Cannot calculate the value min and/or max, I get 0.00.00

    Posted February 7, 2021 9:51am by Francesco Gambardella
    Francesco Gambardella
    2,094 Points
    • Data Analysis
    • Data Analysis Basics
    • Getting to Know Your Data
    • Summarizing Data: Maximum, Minimum, Range

    1 Answer

  • Benjamin Dahlhoff
    Benjamin Dahlhoff
    4,484 Points

    It seems that Google Sheets expects a semicolon instead of a comma as separator in the COUNTIFS function.

    Posted January 8, 2021 5:31pm by Benjamin Dahlhoff
    Benjamin Dahlhoff
    4,484 Points
    • Data Analysis
    • Data Analysis Basics
    • Getting to Know Your Data
    • Is Our Data Normal?

    1 Answer

  • Hayder Morsel
    Hayder Morsel
    3,055 Points

    There doesn't seem to be an 'aggregate column' option in the chart setup menu?

    Posted October 13, 2020 6:08pm by Hayder Morsel
    Hayder Morsel
    3,055 Points
    • Data Analysis
    • Data Analysis Basics
    • Getting to Know Your Data
    • Charting Our Data: Part 1

    2 Answers

  • Andy Qui Le
    Andy Qui Le
    10,130 Points

    Why did we receive a floating value when we use MODE function in Google Spreadsheet instead of getting a duration?

    Posted September 23, 2020 4:09am by Andy Qui Le
    Andy Qui Le
    10,130 Points
    • Data Analysis
    • Data Analysis Basics
    • Getting to Know Your Data
    • Summarizing Data: Mean, Median, Mode

    0 Answers

  • Asa Arnold
    Asa Arnold
    1,266 Points

    S1 vs S2 in "=MIN('2017'!S2:S26411)"

    Posted July 24, 2020 9:28am by Asa Arnold
    Asa Arnold
    1,266 Points
    • Data Analysis
    • Data Analysis Basics
    • Getting to Know Your Data
    • Summarizing Data: Maximum, Minimum, Range

    1 Answer

  • Nick Evershed
    Nick Evershed
    6,415 Points

    Standard deviation getting confusing

    Posted July 21, 2020 9:26am by Nick Evershed
    Nick Evershed
    6,415 Points
    • Data Analysis
    • Data Analysis Basics
    • Getting to Know Your Data
    • Analyzing Data Spread

    1 Answer

  • Michael Erotokritou
    Michael Erotokritou
    2,399 Points

    Second and Third standard deviation

    Posted April 29, 2020 11:36am by Michael Erotokritou
    Michael Erotokritou
    2,399 Points
    • Data Analysis
    • Data Analysis Basics
    • Getting to Know Your Data
    • Is Our Data Normal?

    1 Answer

  • Erlend Dybvik Indrelid
    Erlend Dybvik Indrelid
    5,843 Points

    Min function doesn't work: no output

    Posted July 12, 2019 4:05pm by Erlend Dybvik Indrelid
    Erlend Dybvik Indrelid
    5,843 Points
    • Data Analysis
    • Data Analysis Basics
    • Getting to Know Your Data
    • Summarizing Data: Maximum, Minimum, Range

    3 Answers

  • Rouillie Wilkerson
    Rouillie Wilkerson
    10,407 Points

    I deleted the cut and paste data and get an incorrect answer, now. How do I correct it without starting from scratch?

    Posted June 27, 2019 12:01am by Rouillie Wilkerson
    Rouillie Wilkerson
    10,407 Points
    • Data Analysis
    • Data Analysis Basics
    • Getting to Know Your Data
    • Is Our Data Normal?

    0 Answers

  • Rouillie Wilkerson
    Rouillie Wilkerson
    10,407 Points

    I'm getting the wrong answer of "52820"...

    Posted June 19, 2019 10:02pm by Rouillie Wilkerson
    Rouillie Wilkerson
    10,407 Points
    • Data Analysis
    • Data Analysis Basics
    • Getting to Know Your Data
    • Is Our Data Normal?

    1 Answer

  • Meagan Lampton
    Meagan Lampton
    524 Points

    How can I go back to review wrong answers?

    Posted April 4, 2019 7:49pm by Meagan Lampton
    Meagan Lampton
    524 Points
    • Data Analysis
    • Data Analysis Basics
    • Getting to Know Your Data
    • Getting Friendly with Data

    1 Answer

  • Max Erlich
    Max Erlich
    3,581 Points

    Where do these numbers come from?

    Posted March 29, 2019 5:37pm by Max Erlich
    Max Erlich
    3,581 Points
    • Data Analysis
    • Data Analysis Basics
    • Getting to Know Your Data
    • Analyzing Data Spread

    2 Answers

  • Michelle Rosenstock
    PLUS
    Michelle Rosenstock
    Courses Plus Student 3,256 Points

    Why answer B is wrong Quick Question 2 on Median

    Posted February 15, 2019 3:38pm by Michelle Rosenstock
    Michelle Rosenstock
    Courses Plus Student 3,256 Points
    • Data Analysis
    • Data Analysis Basics
    • Getting to Know Your Data
    • Getting Friendly with Data

    2 Answers

  • Tim Borrego
    Tim Borrego
    1,684 Points

    Will there be other Data Vis courses in addition to "Introduction to Data Visualization with Matplotlib"?

    Posted March 26, 2018 3:30am by Tim Borrego
    Tim Borrego
    1,684 Points
    • Data Analysis
    • Data Analysis Basics
    • Getting to Know Your Data
    • Visualizing Data

    1 Answer

  • Bernardo Augusto García Loaiza
    PLUS
    Bernardo Augusto García Loaiza
    Courses Plus Student 792 Points

    What is the reason to get or reference three standard deviations?

    Posted December 28, 2017 3:56am by Bernardo Augusto García Loaiza
    Bernardo Augusto García Loaiza
    Courses Plus Student 792 Points
    • Data Analysis
    • Data Analysis Basics
    • Getting to Know Your Data
    • Is Our Data Normal?

    3 Answers

  • Josie Nagy
    Josie Nagy
    14,992 Points

    Summarizing Data - How do I calculate the Range value?

    Posted December 21, 2017 2:55pm by Josie Nagy
    Josie Nagy
    14,992 Points
    • Data Analysis
    • Data Analysis Basics
    • Getting to Know Your Data
    • Summarizing Data: Mean, Median, Mode

    2 Answers

  • Noah Fields
    Noah Fields
    13,985 Points

    Why divide by 60 and then 24 instead of 1440?

    Posted December 13, 2017 8:22pm by Noah Fields
    Noah Fields
    13,985 Points
    • Data Analysis
    • Data Analysis Basics
    • Getting to Know Your Data
    • Charting Our Data: Part 2

    9 Answers

  • Brendan Whiting
    seal-mask
    .a{fill-rule:evenodd;}techdegree seal-36
    Brendan Whiting
    Front End Web Development Techdegree Graduate 84,692 Points

    Standard deviation symbol is uppercase sigma?

    Posted December 8, 2017 3:39am by Brendan Whiting
    .a{fill-rule:evenodd;}techdegree seal-36
    Brendan Whiting
    Front End Web Development Techdegree Graduate 84,692 Points
    • Data Analysis
    • Data Analysis Basics
    • Getting to Know Your Data
    • Analyzing Data Spread

    3 Answers

  • Geo Gs
    Geo Gs
    2,785 Points

    how can i change he MODE format if im on excel i do not see the DURATION option

    Posted December 6, 2017 3:34am by Geo Gs
    Geo Gs
    2,785 Points
    • Data Analysis
    • Data Analysis Basics
    • Getting to Know Your Data
    • Summarizing Data: Mean, Median, Mode

    1 Answer

  • Mathias Schulenburg
    Mathias Schulenburg
    2,679 Points

    How to do this in excel?

    Posted December 4, 2017 10:45pm by Mathias Schulenburg
    Mathias Schulenburg
    2,679 Points
    • Data Analysis
    • Data Analysis Basics
    • Getting to Know Your Data
    • Charting Our Data: Part 1

    1 Answer

  • Lidia Matzek
    Lidia Matzek
    5,481 Points

    Why is this not working:

    Posted December 4, 2017 8:45pm by Lidia Matzek
    Lidia Matzek
    5,481 Points
    • Data Analysis
    • Data Analysis Basics
    • Getting to Know Your Data
    • Is Our Data Normal?

    2 Answers

  • pat barosy
    pat barosy
    6,759 Points

    Using minimum function on google sheets--data analytics

    Posted December 3, 2017 5:53pm by pat barosy
    pat barosy
    6,759 Points
    • Data Analysis
    • Data Analysis Basics
    • Getting to Know Your Data
    • Summarizing Data: Maximum, Minimum, Range

    3 Answers

Posting to the forum is only allowed for members with active accounts.
Please sign in or sign up to post.

    Treehouse

  • About
  • Blog
  • Careers
  • Community
  • Stories
  • Shop
  • Contact
  • Gift Card

See Full Catalogue

Techdegree

  • Web Development
  • Front End Web Development
  • Full Stack JavaScript
  • Python Development
  • Data Analysis

Tracks

  • Learn to Code for Beginners
  • Beginning Python
  • Beginning SQL
  • Beginning Java
  • ...see more

Courses

  • JavaScript Basics
  • Intro to HTML & CSS
  • Python Basics
  • CSS Layout
  • ...see more

Explore

  • Perks
  • Treehouse for Libraries
  • Treehouse for Teams
  • Twitter
  • YouTube
  • Facebook
  • LinkedIn
  • Instagram
Terms & Conditions | Privacy

© 2022 Treehouse Island, Inc.