Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Data Analysis Data Analysis Basics Getting to Know Your Data Summarizing Data: Maximum, Minimum, Range

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

I am using Google Sheet, selecting all the times and then paste the interval on the Summary Sheet bu I get 0.00.00

1 Answer

Kevin LG
Kevin LG
5,641 Points

I've seen this issue come up a few times in the questions here so I'm posting this to those I feel might be relevant to this answer. I hope my solution helps.

From what I've gathered, either the number formatting gets changed for some of us or a mysterious apostrophe is placed in front of the numbers in the cells with numerical values (this is what happened to my dataset) when they're imported from the CSV file. This may be from unchecking the "Convert text to numbers, dates, and formulas" box. Leaving that box checked may prevent all of this. If you're already past that point, keep reading below.

You may need to adjust the cells under the "5K, 10K, Official Time, etc.." column to the "Duration" setting in the "Number" section in the "Format" toolbar.

I also had the apostrophe problem with the values under "Bib, Age, Overall, Gender, Division", and reformatted them to use the "0" Number setting to remove the unwanted apostrophe.

This video helped me understand the apostrophe issue.

As the previous lessons had mentioned, we must make sure to validate and clean our data to prevent issues like these. Best of luck everyone!