Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

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

Temi Folorunsho
Temi Folorunsho
2,848 Points

Max, Min, Range

I tried using this spreadsheet locally on my system using ms excel but i did not get the same value for min, max and range although when i used google sheets i got the same value in he video. Why is that?

1 Answer

Steven Parker
Steven Parker
216,812 Points

Just a guess; but if I recall correctly, these sample files have some filters applied by default. So possibly when you copied the data to make a local file you didn't get all the rows.