Rounding & Estimation Word Problems

Related Pages Math Worksheets Lessons for Fourth Grade Free Printable Worksheets

Printable “Rounding Numbers” Worksheets: Round Numbers using the Number Line Round to nearest 10 Round to nearest 100 Round to nearest 1000, 10000, 100000 Rounding Word Problems

Rounding Word Problems Worksheets

In these free math worksheets, students practice how to use rounding to estimate and check the answers to word problems.

How to use estimation or rounding? Estimation or rounding is a useful tool for checking answers because it allows you to quickly determine if an answer is reasonable or not.

Here are some steps you can follow to use estimation to check an answer: Step 1: Make sure you understand what you are being asked to find and what information you have been given. Step 2: Round any numbers given in the problem to the nearest whole number, or to the nearest ten, hundred, or thousand, depending on the level of accuracy needed. Step 3: Use mental math to perform calculations quickly. For example, if you need to add 23 and 45, round them both to 20 and 50 and add those instead. This will give you an estimate that is close to the actual answer. Step 4: Once you have an estimate, compare it to the actual answer you calculated. If the estimate is close to the actual answer, you can be confident that your calculation is correct. If the estimate is significantly different from the actual answer, you may need to review your work and make corrections.

By using estimation to check your answers, you can catch errors early and avoid making mistakes that could lead to incorrect results.

Click on the following worksheet to get a printable pdf document. Scroll down the page for more Rounding Word Problems Worksheets .

Rounding Word Problems Worksheet

More Rounding Word Problems Worksheets

Printable (Answers on the second page.) Rounding Worksheet #1 Rounding Worksheet #2 Rounding Worksheet #3 Rounding Worksheet #4 Rounding Worksheet #5

Online Round multi-digit number Worksheet #1

Rounding Multi-digit Numbers to any place value

Rounding Word Problems Use your estimated answer for part a) to check your answer for part b).

  • For the bake sale, Connie baked 144 cookies. Esther baked 49 more cookies than Connie. a. About how many cookies did Connie and Esther bake? Estimate by rounding each number to the nearest ten before adding. b. Exactly how many cookies did Connie and Esther bake?
  • Raffle tickets were sold for a school fundraiser to parents, teachers, and students. 563 tickets were sold to teachers. 888 more tickets were sold to students than to teachers. 904 tickets were sold to parents. How many tickets were sold to parents, teachers, and students? a. About how many tickets were sold to parents, teachers, and students? Round each number to the nearest hundred to find your estimate. b. Exactly how many tickets were sold to parents, teachers, and students?
  • From 2010 to 2011, the population of Queens increased by 16,075. Brooklyn’s population increased by 11,870 more than the population increase of Queens. a. Estimate the total combined population increase of Queens and Brooklyn from 2010 to 2011. (Round the addends to the nearest thousand to estimate.) b. Find the actual total combined population increase of Queens and Brooklyn from 2010 to 2011.
  • There were 3,905 more hits on the school’s website in January than February. February had 9,854 hits. How many hits did the school’s website have during both months? a. About how many hits (roud ro the nearest thousand) did the website have during January and February? b. Exactly how many hits did the website have during January and February?
  • On Sunday, 77,098 fans attended a New York Jets football game. The same day 3,397 more fans attended a New York Giants game than the Jets game. How many football fans watched the Jets and Giants play on Sunday? a. Round each number to the nearest thousand to find an estimate of how many fans there are. b. What was the actual number of fans who watched the games?

Related Lessons & Worksheets

Round to nearest 10 (2-digit) (eg. 45 -> 50) Round to nearest 10 (3-digit) (eg. 725 -> 730) Round to nearest 100 (3-digit) (eg. 651 -> 700) Round to nearest 10 or 100 (3-digit)

Round to nearest 100 (4-digit) (eg. 2,754 -> 2,800) Round to nearest 1000 (eg. 3,542 -> 4,000) Round to nearest 10, 100, 1000

Round the nearest thousands

More Printable Worksheets

Mathway Calculator Widget

We welcome your feedback, comments and questions about this site or page. Please submit your feedback or enquiries via our Feedback page.

Problem solving with estimation and rounding

I can use my knowledge of estimation and rounding to solve problems.

Lesson details

Key learning points.

  • It may be helpful to estimate an answer to check the magnitude is correct.
  • It can be useful to use rounding to significant figures when dealing with very big or very small numbers in context.
  • Estimates can help when making decisions about maximum or minimum possible answers in real life contexts.
  • You can use Fermi estimation to find approximate solutions to problems.

Common misconception

Using the wrong limits when dividing or subtracting in order to find the upper limit of a calculation or lower limit of a calculation.

Drawing a number line to show with subtraction will help students see how to achieve an upper or lower limits of an error interval calculation. When using division, reiterating the division of number is the same as multiplying by its reciprocal.

Estimate - A quick estimate for a calculation is obtained from using approximate values, often rounded to 1 significant figure.

This content is © Oak National Academy Limited ( 2024 ), licensed on Open Government Licence version 3.0 except where otherwise stated. See Oak's terms & conditions (Collection 2).

Starter quiz

6 questions.

An image in a quiz

SkillsYouNeed

  • NUMERACY SKILLS

Estimation, Approximation and Rounding

Search SkillsYouNeed:

Numeracy Skills:

  • A - Z List of Numeracy Skills
  • How Good Are Your Numeracy Skills? Numeracy Quiz
  • Money Management and Financial Skills
  • Real-World Maths
  • Numbers | An Introduction
  • Special Numbers and Mathematical Concepts
  • Systems of Measurement
  • Common Mathematical Symbols and Terminology
  • Apps to Help with Maths
  • Subtraction -
  • Multiplication ×
  • Positive and Negative Numbers
  • Ordering Mathematical Operations - BODMAS
  • Mental Arithmetic – Basic Mental Maths Hacks

Check out our new eBooks:

Fundamentals of Numeracy - The Skills You Need Guide to Numeracy

The Skills You Need Guide to Numeracy

  • Ratio and Proportion
  • Percentages %
  • Percentage Calculators
  • Percentage Change | Increase and Decrease
  • Calculating with Time
  • Introduction to Geometry: Points, Lines and Planes
  • Introduction to Cartesian Coordinate Systems
  • Polar, Cylindrical and Spherical Coordinates
  • Properties of Polygons
  • Simple Transformations of 2-Dimensional Shapes
  • Circles and Curved Shapes
  • Perimeter and Circumference
  • Calculating Area
  • Three-Dimensional Shapes
  • Net Diagrams of 3D Shapes
  • Calculating Volume
  • Area, Surface Area and Volume Reference Sheet
  • Graphs and Charts
  • Averages (Mean, Median & Mode)
  • Simple Statistical Analysis
  • Statistical Analysis: Types of Data
  • Understanding Correlations
  • Understanding Statistical Distributions
  • Significance and Confidence Intervals
  • Developing and Testing Hypotheses
  • Multivariate Analysis
  • Introduction to Algebra
  • Simultaneous and Quadratic Equations
  • Introduction to Trigonometry
  • Introduction to Probability

Subscribe to our FREE newsletter and start improving your life in just 5 minutes a day.

You'll get our 5 free 'One Minute Life Skills' and our weekly newsletter.

We'll never share your email address and you can unsubscribe at any time.

Sometimes, you may find it helpful to know the approximate answer to a calculation.

You may be in a shop and want to know broadly what you’re going to have to pay.

You may need to know roughly how much money you need to meet a couple of bills.

You may also want to know roughly what the right answer to a more complicated calculation is likely to be, to check that your detailed work is correct.

Whatever your precise need, you want to know how to estimate or approximate the right answer.

One very simple form of estimation is rounding. Rounding is often the key skill you need to quickly estimate a number. This is where you make a long number simpler by ‘rounding’, or expressing in terms of the nearest unit, ten, hundred, tenth, or a certain number of decimal places.

For example, 1,654 to the nearest thousand is 2,000. To the nearest 100 it is 1,700. To the nearest ten it is 1,650.

The way it works is straightforward:  you look at the number one place to the right of the level that you are rounding to and see whether it is closer to 0 or 10.

In practice, this means that if you’ve been asked to round to the nearest 10, you look at the units. If you are rounding to three decimal places, you look at the fourth decimal place (the fourth number to the right of the decimal point) and so on. If that number is 5 or over, you round up to the next number, and if it is 4 or under, you round down.

Round Up or Round Down?

We round numbers to reduce their number of digits while keeping the result as close to the original number as possible.

Numbers that are less than 5 get rounded down.

Numbers that are 5 or higher get rounded up.

Rounding to one decimal place:

  • 1.47 rounds to 1.5
  • 1.42 rounds to 1.4
  • 1.4535412 rounds to 1.5

Rounding: Worked Examples

Express 156 to the nearest 10

In this example you look at the tens and units. The hundreds will not change. You need to decide whether 56 will be rounded up to 60 or down to 50.

Looking at the units, you know that 6 is more than 5, so you round up.

The answer is 160.

Express 0.4563948 to three decimal places.

As you're working to three decimal places, the answer will start 0.45 and you need to determine the third number after the decimal point

To work out whether the third number is 6 or 7, you need to look at the fourth number, which is 3. As 3 is less than 5, you round down.

The answer therefore is 0.456.

You can use the technique of rounding to start estimating the answer to more complex problems.

Estimating can be considered as ‘slightly better than an educated guess’. If a guess is totally random, an educated guess might be a bit closer.

Estimation, or approximation, should give you an answer which is broadly correct, say to the nearest 10 or 100, if you are working with bigger numbers.

Probably the simplest way to estimate is to round all the numbers that you are working with to the nearest 10 (or 100, if you are working in thousands at the time) and then do the necessary calculation.

For example , if you are estimating how much you will have to pay, first round each amount up or down to the nearest unit of currency, pound, dollar, euro etc. or even to the nearest 10 units (£10, $10, €10), and then add your rounded amounts together.

Many stores like to give prices ending in .09 and especially 0.99. The reason for this is that a shirt that costs 24.99 'sounds' cheaper than one that costs 25.00. When shopping for numerous items it can be useful to keep a running tally, an estimate of the total cost, by rounding items to the nearest currency unit, £, $, € etc.

If you are trying to work out how much carpet you will need, round the length of each wall up to the nearest metre or half-metre if the calculation remains simple, and multiply them together to get the area.

If you are relying on your calculation to make sure that you have enough of something, whether money or carpet, always round up. That way you will always over-estimate. Even engineers take this approach when thinking about the design of a structure before doing a detailed specification. It’s better to have a component that’s a bit stronger than it needs to be than one that is too weak.

You want to buy carpet for two rooms. The first is 3.2m by 2.7m. The second is smaller, 1.16m by 2.5m. How much carpet do you need to buy to be sure of having enough for both rooms?

The first room is approximately 3m by 3m, which is 9m 2 .

The second is just over 1m by 2.5m. Strictly speaking, you would round this to 1m by 2.5m, or 2.5m 2 .

In total, then, that’s 11.5m 2 . It’s hard to buy carpet in anything except whole m 2 , so you’ll need to round up to 12m 2 . In each case, you have rounded up one of the numbers by more than you have rounded the other one down, so you’re probably fine.

A quick check with a calculator will, indeed, confirm that you need exactly 11.54m 2 . 12m 2 will be plenty.

You’ve decided to add another room to the carpet buying. The last room is 3.9m by 2.2m. How much carpet do I need for all three rooms?

3.9m is rounded up to 4m. 2.2m rounds down to 2m.

2 × 4 is 8m 2 , which gives a total, for all three rooms of 20m 2 .

However, in rounding down to 2m, you have taken out 0.2m. In rounding up to 4m, you have only added 0.1m.

You may not order quite enough carpet although you might get away with it because you rounded up to 12m 2 for the first two rooms.

However, to be absolutely sure, you probably want to round 2.2m up, to 2.5m.

Multiply 2.5 by 4 to get 10m 2 . This means you need 22m 2 of carpet for all three rooms.

A quick check with a calculator will confirm that 20m 2 is not quite enough: You need 20.9m 2 exactly.

Need a refresher on how to calculate area? See our page Calculating Area for help.

Estimated Time of Arrival (ETA)

Estimated time of arrival is used frequently used when travelling.  Trains, buses, planes, ships and in-car satellite navigation (sat-nav) all use ETA.

The ETA is based on distance and speed of travel, it is ‘estimated’ because it cannot take into account changes to speed during the journey.  Your flight may arrive early because of favourable tail winds.  Your road trip may take longer than expected because of traffic.

The ETA is usually calculated by a computer and can change during your trip. As you near your destination, more data becomes available so the estimated time that you will arrive becomes more accurate.

A Special Case: Estimating for Work

You will almost certainly come across ‘estimates’ for work to be done, whether from a builder, plumber, mechanic or other tradesperson.

In this case, the tradesperson concerned has probably estimated how much time they are likely to take to do the work, multiplied it by their hourly or daily rate, and perhaps added additional charges for materials or a call-out.

They may also have added a ‘ contingency ’ for extra work needed, which is likely to be 10 or 20%, and will mean that you are not unpleasantly surprised by the bill if they find something unexpected that needs fixing.

An ‘estimate’ is not legally binding. It is just what it says: an estimate.

However, a ‘quote’ or ‘quotation’ for work done is legally binding on cost, provided that the work done is what was quoted for. However, if you have asked for extra work: ‘just add that bit’ or ‘do that while you’re here’, don’t be surprised if the bill is larger than you were expecting.

A Useful Skill

You may be wondering why you’d ever use estimation when you have a calculator on your phone.

The ability to estimate will mean that you will know if the answer you get from the calculator is not right, and do it again.

Continue to: Mental Arithmetic – Basic Mental Maths Hacks Real World Maths

Also see: Probability an Introduction Special Numbers and Concepts Averages (Mean, Median and Mode)

Home

Reading & Math for K-5

  • Kindergarten
  • Learning numbers
  • Comparing numbers
  • Place Value
  • Roman numerals
  • Subtraction
  • Multiplication
  • Order of operations
  • Drills & practice
  • Measurement
  • Factoring & prime factors
  • Proportions
  • Shape & geometry
  • Data & graphing
  • Word problems
  • Children's stories
  • Leveled Stories
  • Sentences & passages
  • Context clues
  • Cause & effect
  • Compare & contrast
  • Fact vs. fiction
  • Fact vs. opinion
  • Main idea & details
  • Story elements
  • Conclusions & inferences
  • Sounds & phonics
  • Words & vocabulary
  • Reading comprehension
  • Early writing
  • Numbers & counting
  • Simple math
  • Social skills
  • Other activities
  • Dolch sight words
  • Fry sight words
  • Multiple meaning words
  • Prefixes & suffixes
  • Vocabulary cards
  • Other parts of speech
  • Punctuation
  • Capitalization
  • Narrative writing
  • Opinion writing
  • Informative writing
  • Cursive alphabet
  • Cursive letters
  • Cursive letter joins
  • Cursive words
  • Cursive sentences
  • Cursive passages
  • Grammar & Writing

Breadcrumbs

  • Word Problems

Math Workbooks for Grade 5

Download & Print From only $2.60

Estimating & rounding word problems

Fast, approximate answers.

Students use rounding and estimating to arrive at or select approximate answers to questions. The underlying operations are addition, subtraction, multiplication and division.  

rounding and estimation problem solving

These worksheets are available to members only.

Join K5 to save time, skip ads and access more content. Learn More

More word problem worksheets

Explore all of our math word problem worksheets , from kindergarten through grade 5.

What is K5?

K5 Learning offers free worksheets , flashcards  and inexpensive  workbooks  for kids in kindergarten to grade 5. Become a member  to access additional content and skip ads.

Our members helped us give away millions of worksheets last year.

We provide free educational materials to parents and teachers in over 100 countries. If you can, please consider purchasing a membership ($24/year) to support our efforts.

Members skip ads and access exclusive features.

Learn about member benefits

This content is available to members only.

  • Forgot Password?

EW

  • Featured Articles
  • Report Card Comments
  • Needs Improvement Comments
  • Teacher's Lounge
  • New Teachers
  • Our Bloggers
  • Article Library
  • Featured Lessons
  • Every-Day Edits
  • Lesson Library
  • Emergency Sub Plans
  • Character Education
  • Lesson of the Day
  • 5-Minute Lessons
  • Learning Games
  • Lesson Planning
  • Subjects Center
  • Teaching Grammar
  • Leadership Resources
  • Parent Newsletter Resources
  • Advice from School Leaders
  • Programs, Strategies and Events
  • Principal Toolbox
  • Administrator's Desk
  • Interview Questions
  • Professional Learning Communities
  • Teachers Observing Teachers
  • Tech Lesson Plans
  • Science, Math & Reading Games
  • Tech in the Classroom
  • Web Site Reviews
  • Creating a WebQuest
  • Digital Citizenship
  • All Online PD Courses
  • Child Development Courses
  • Reading and Writing Courses
  • Math & Science Courses
  • Classroom Technology Courses
  • A to Z Grant Writing Courses
  • Spanish in the Classroom Course
  • Classroom Management
  • Responsive Classroom
  • Dr. Ken Shore: Classroom Problem Solver
  • Worksheet Library
  • Highlights for Children
  • Venn Diagram Templates
  • Reading Games
  • Word Search Puzzles
  • Math Crossword Puzzles
  • Geography A to Z
  • Holidays & Special Days
  • Internet Scavenger Hunts
  • Student Certificates

Newsletter Sign Up

Prof. Development

  • General Archive
  • Have Some Fun
  • Expert Interviews
  • Math Corner
  • New Teacher Advisor
  • Strategies That Work
  • Voice of Experience
  • Improvement
  • Lessons from Our Schools
  • Whatever it Takes
  • School Climate Archive
  • Classroom Mgmt. Tips
  • Behavior Management Tips
  • Motivating Kids
  • Fit to Be Taught
  • Rural Education
  • Urban Education
  • Community Involvement
  • Best Idea Ever
  • Read About It
  • Book Report Makeover
  • Bulletin Board
  • Parent Issues
  • Goal Setting/Achieving
  • Teacher Lifestyle Tips
  • Classroom Problem Solver
  • Strategy of the Week
  • Teacher’s Lounge
  • Grouping/Scheduling
  • In a Sub’s Shoes
  • SchoolDoodles
  • Teach for America Diaries
  • Teaming Up to Achieve
  • Earth Science Demos
  • Interdisciplinary
  • Language Arts
  • The Reading Room
  • All Columnists...
  • Dr. Fred Jones
  • Emma McDonald
  • Dr. Ken Shore
  • School Issues: Glossary
  • Top PD Features
  • Books in Education
  • Reader's Theater
  • Reading Coach
  • Teacher Feature
  • School Improvement
  • No Educator Left Behind
  • Turnaround Tales
  • School Climate
  • Responsive Classroom Archive
  • Community Context
  • School Choice
  • School to Work
  • Problem Solving Archive
  • Homework Hassles
  • Teacher’s Lounge
  • Virtual Workshop
  • In a Sub’s Shoes
  • Academic Subjects
  • Readers’ Theater
  • Math Mnemonics
  • Math Cats Math Chat
  • Prof. Dev. Columnists

Search form

Explain rounding and estimating.

Explain Rounding and Estimating Whole Number Rounding is a way of simplifying numbers to make them easier to understand or work with. Rounding can be used when an exact number isn't needed, and an approximate answer will do. For example, at the minute this is being written, exactly 299,588,632 people live in the United States (See the U.S. Census Bureau Population Clock .), but that number changes every day. And it's not likely you'll need to know exactly how many people live in the United States at any given moment. Instead, you could simplify that number by "rounding" it to 300 million. How does that work? Follow the steps below to learn how to round a whole number.

  • Find the "round off" digit. The round off digit is the place value of the number you're rounding to . For example, if you want to round a number to the nearest ten, the round off digit is the number in the tens' place. If you want to round a number to the nearest hundred, the round off digit is the number in the hundreds' place.
  • Look at the number to the right of the round off digit. If that number is less than 5, don't change the round off digit. If that number is 5 or more, add one to the round off digit.

Change all the digits to the right of the round off digit to zeros.

Estimating is another way of making numbers easier to work with when we don't need to know exactly how many; we just need to know about how many. An estimate is really an "educated guess," in other words, a guess that's based on some prior knowledge or facts.

Rounding and Estimating Worksheets

Rounding and Estimating Interactive Activities

  • Estimation Contest
  • Estimating Quotients
  • Rounding Numbers
  • School Express
  • Teachnology
  • Estimation: Hundreds
  • Rounding Flashcards

EW Lesson Plans

rounding and estimation problem solving

EW Professional Development

Ew worksheets.

rounding and estimation problem solving

 

rounding and estimation problem solving

Sign up for our free weekly newsletter and receive

top education news, lesson ideas, teaching tips and more!

No thanks, I don't need to stay current on what works in education!

COPYRIGHT 1996-2016 BY EDUCATION WORLD, INC. ALL RIGHTS RESERVED.

COPYRIGHT 1996 - 2024 BY EDUCATION WORLD, INC. ALL RIGHTS RESERVED.

  • SchoolNotes.com
  • The Educator's Network

rounding and estimation problem solving

Syllabus Edition

First teaching 2021

Last exams 2024

Rounding & Estimation ( CIE IGCSE Maths: Extended )

Revision note.

Dan

Rounding & Estimation

How do i round numbers to a given place value.

  • This number will determine whether to round up or round off
  • e.g. the two nearest 100's to 1294 are 1200 and 1300
  • e.g. the nearest 2 decimal places to 3.4 9 7 are 3.49 and 3.50
  • If the circled number is 5 or more then you round to the bigger number
  • If the circled number is less than 5 then you round to the smaller number
  • e.g. 1297 to the nearest 100 is 13 00
  • e.g. 3.497 to two decimal places (nearest 100th) is 3.50 (exactly two decimal places in answer)

How do I round to significant figures?

  • You just need to identify the relevant place value
  • The first significant figure of 3097 is 3
  • The first significant figure of 0.006207 is 6
  • e.g. 0 is the second significant figure of 3 0 97
  • e.g. 9 is the third significant figure of 30 9 7
  • Circle the number to the right
  • Use this to determine whether the given significant figure rounds up or rounds off

Why do we use estimation?

  • We estimate to find approximations for difficult sums
  • Or to check our answers are about the right size (right order of magnitude)

How do I estimate?

  • We round numbers to something sensible before calculating
  • 3.65 × 10 -4 ➝ 4 × 10 -4
  • 1080 ➝ 1000
  • 1180 ➝ 1200
  • It wouldn’t usually make sense to round a number to zero

How do I know if I have underestimated or overestimated?

  • If you round both numbers up then you will overestimate
  • If you round both numbers down then you will underestimate
  • Subtraction and division are more complicated
  • Increasing  a and/or decreasing b will increase the answer so you will overestimate
  • Decreasing  a and/or increasing  b will decrease the answer so you will underestimate
  • If both numbers are increased or both are decreased then you can not easily tell if it is an underestimate or underestimate

Worked example

Round each number to 1 significant figure.

17.3 → 20 3.81 → 4 11.5 → 10

Perform the calculation with the rounded numbers.

An estimate is 8. This is an overestimate as the numerator was rounded up and the denominator was rounded down.

You've read 0 of your 10 free revision notes

Get unlimited access.

to absolutely everything:

  • Downloadable PDFs
  • Unlimited Revision Notes
  • Topic Questions
  • Past Papers
  • Model Answers
  • Videos (Maths and Science)

Join the 100,000 + Students that ❤️ Save My Exams

the (exam) results speak for themselves:

Did this page help you?

Author: Dan

Dan graduated from the University of Oxford with a First class degree in mathematics. As well as teaching maths for over 8 years, Dan has marked a range of exams for Edexcel, tutored students and taught A Level Accounting. Dan has a keen interest in statistics and probability and their real-life applications.

Corbettmaths

Estimation Practice Questions

Click here for questions, click here for answers.

estimating, approximations, approximating

GCSE Revision Cards

rounding and estimation problem solving

5-a-day Workbooks

rounding and estimation problem solving

Primary Study Cards

rounding and estimation problem solving

Privacy Policy

Terms and Conditions

Corbettmaths © 2012 – 2024

  • International
  • Education Jobs
  • Schools directory
  • Resources Education Jobs Schools directory News Search

Rounding reasoning & problem solving

Rounding reasoning & problem solving

Subject: Mathematics

Age range: 7-11

Resource type: Worksheet/Activity

alarter

Last updated

2 October 2016

  • Share through email
  • Share through twitter
  • Share through linkedin
  • Share through facebook
  • Share through pinterest

docx, 17.47 KB

Creative Commons "Sharealike"

Your rating is required to reflect your happiness.

It's good to leave some feedback.

Something went wrong, please try again later.

lorraivalentina

great activity.

Empty reply does not make any sense for the end user

Great thanks - really good to get my LA Yr5er thinking.

This is really good for your HA and as extension. Just what I needed

haixalo2021991

This is a great problem solving activity on problem solving, thanks

Report this resource to let us know if it violates our terms and conditions. Our customer service team will review your report and will be in touch.

Not quite what you were looking for? Search by keyword to find the right resource:

rounding and estimation problem solving

Query Exercise: Solving The 201 Buckets Problem

When you run a query, SQL Server needs to estimate the number of matching rows it’ll find – so that it can decide which indexes to use, whether to go parallel, how much memory to grant, and more.

For example, take any Stack Overflow database , and let’s say I have an index on Location, and I want to find the top-ranking users in Lithuania:

INDEX Location ON dbo.Users(Location); * FROM dbo.Users Location = N'lithuania' BY Reputation DESC;

Then SQL Server has to guess how many people are in Lithuania so it can decide whether to use the index on Location, or do a table scan – because if there are a lot of folks in Lithuania, then it would mean a lot of key lookups to get the Reputation value for each of them.

We’ll run the query in the small StackOverflow2010 database and review the actual execution plan :

rounding and estimation problem solving

In the top right operator, the Index Seek, SQL Server only estimated 5 rows, but 84 rows actually came back. Now, that’s not really a problem for this particular query because:

  • SQL Server used the index – which makes the query fast
  • SQL Server did 84 key lookups instead of 5 – but still, that’s less logical reads than a table scan
  • The query went single-threaded – but there was so little work that it didn’t matter
  • The query didn’t spill to disk – there’s no yellow bang on the sort operator

As our database grows, though, the lines start to blur. Let’s run the same query on the largest current version of the StackOverflow database and see what happens in the actual execution plan :

rounding and estimation problem solving

The top right operator, the Index Seek, shows just 8 rows estimated, but 2,554 rows were actually found. As our data size grows, these estimate variances start to become problematic. Now granted, this succeeds in the same way the 2010 query succeeds: we get an index seek, it’s still less logical reads than a key lookup plan would be, the single-threaded thing isn’t a problem for a 27 millisecond query, and we don’t spill to disk.

However, if we start to join to other tables (and we will, in the next Query Exercise), then this under-estimation is going to become a problem.

Why is the estimate wrong?

We do indeed have statistics on the Location index, and they were created with fullscan since we just created the index. Let’s view the statistics for the large database:

SHOW_STATISTICS('dbo.Users', 'Location')

And check out the histogram contents – we’ll page down to Lithuania:

rounding and estimation problem solving

Or rather, we’ll page down to where you would  expect Lithuania to be, and there’s a problem: Lithuania’s not there. SQL Server’s statistics are limited to just 201 buckets, max. (Technically, it’s up to 200 buckets for “normal” values in the table, plus 1 bucket for null.)

SQL Server does the best job it can of picking outliers in order to paint a perfect picture of the data, but it’s hard with just 201 buckets.

Typically – but not always – when SQL Server picks the locations that it’ll use for outliers, it uses  around the top 200 locations by size, but this can vary a lot depending on the sort order of the column and the distribution of the data. Let’s look at the top locations:

TOP 250 Location, COUNT(*) AS recs FROM dbo.Users GROUP BY Location ORDER BY COUNT(*) DESC;

And Lithuania is at row 240 in this case:

rounding and estimation problem solving

So it’s a big location –  but not big enough to hit the top 201 , which means it’s not going to get accurate estimates. The estimates are derived by looking at which bucket Lithuania is in – in the screenshot below, it’s row 100:

Lithuania is higher than Lisbon, but less than London, so it’s in the row 100 bucket. The row 100’s AVG_RANGE_ROWS is 7.847202, which means that any location between Lisbon and London has an  average number of rows of about 8. And that’s where the estimate is coming from in our query:

rounding and estimation problem solving

Your challenge: get an accurate estimate.

You can change the query, the database, server-level settings, you name it. Anything that you would do in a real-life situation, you can do here. However, having done this exercise in my Mastering classes, I can tell you a couple things that people will try to do, but don’t really make sense.

You don’t wanna dump the data into a temp table first. Sometimes people will extract all of the data into a temp table, and then select data out of the temp table and say, “See, the estimate is accurate!” Sure it is, speedy, but look at your estimate from when you’re pulling the data out of the real table – the estimate’s still wrong there.

You don’t wanna use a hard-coded stat or index for just ‘Lithuania’. That only solves this one value, but you’ll still have the problem for every other outlier. We’re looking for a solution that we can use for most big outliers. (It’s always tricky to phrase question requirements in a way that rules out bad answers without pointing you to a specifically good answer, hahaha.)

Put your queries in a Github Gist and the query plans in PasteThePlan , showing your new accurate estimates , and include those link in your comments. Check out the solutions from other folks, and compare and contrast your work. I’ll circle back next week for a discussion on the answers. Have fun!

10 Comments . Leave new

' src=

My Gist https://gist.github.com/Paul-Fenton/83b0829263e9586868e1bd29fc2d6ccf

Query Plan https://www.brentozar.com/pastetheplan/?id=r19_spQjC

Create a new column “PopularLocation” which is set to the Location if it’s one of the top 250 locations.

Then change the query to look like:

SELECT * FROM dbo.Users WHERE Location = N’Lithuania’ OR PopularLocation = N’Lithuania’ ORDER BY Reputation DESC;

The estimate is now “84 of 85 rows (98%)” instead of “84 of 5 rows (1680%)”

' src=

I love the creativity! But…

Now the query is doing a table scan for just 84 rows. Check the estimates on other values, like India or San Diego

' src=

Sorry, cannot test it right now, just thinking out loud, perhaps filtered stats may solve it… I know it won’t probably work for other locations, but perhaps if we use parameter for the location, and using RECOMPILE hint that will be more accurate… Again sorry , but cannot test it right now…..

Uri, please reread the post more carefully and respect the time of others. Thank you.

' src=

Sometimes I need to cheat mssql because I want to see what will happen when there are many rows.

UPDATE STATISTICS dbo.Users([Location]) WITH rowcount =500000000000;

This gives 77 rows in Lithuanian. I known its not real life but for testing it is sometimes useful.

HAHAHA! That’s a funny idea, love it.

' src=

Code: https://gist.github.com/samot1/8d6e3bc5feee76b7959841cae8f81b97 Plan: https://www.brentozar.com/pastetheplan/?id=HJnkAt4oR

Idea: I just created a filtered statistic for every location starting with A, with B, with C … with Z

This way I have not just 200 statistic steps but 5200 which is enough to cover the most larger locations and get the correct estimates.

Drawback: you may or may not have to use OPTION(RECOMPILE) to use the correct statistic. When you put the location into a variable and use it in the query or have the PARAMETERIZATION option on your database set to FORCED you always have to use RECOMPILE to get the correct estimate.

PS: in a real scenario there may be much better options to archive the correct estimate, but you would need to know, how exactly the database is queried (which queries, how often, what happens with the results, how busy is the server …) and use all this information to decide the best option (which could be to simply ignore the wrong estimates too, since the overhead is bigger than the result)

Thomas – that is intriguing! I love the creativity.

I like the drawbacks that you put in the Gist – there are totally drawbacks here, for sure. For example, each stat has to be updated separately, so we just made our maintenance window explode. However, if someone is advanced enough to use this solution, I’d also expect them to be advanced enough to have relatively infrequent, targeted statistics updates.

I like it! I think you’ll also like the solution I talk about in next week’s post.

I had another much worse idea but it didn’t work (even if it could/should): CREATE PARTITION FUNCTION pf_a_to_z (NVARCHAR(100)) AS RANGE RIGHT FOR VALUES (‘A’, ‘B’, ‘C’, ‘D’, ‘E’, ‘F’, ‘G’, ‘H’, ‘I’, ‘J’, ‘K’, ‘L’, ‘M’, ‘N’, ‘O’, ‘P’, ‘Q’, ‘R’, ‘S’, ‘T’, ‘U’, ‘V’, ‘W’, ‘X’, ‘Y’, ‘Z’) CREATE PARTITION SCHEME ps_a_to_z AS PARTITION pf_a_to_z ALL TO ([PRIMARY]) ALTER TABLE [dbo].[Users] DROP CONSTRAINT [PK_Users_Id]; — drop old PK

CREATE UNIQUE CLUSTERED INDEX pk_Users_id ON dbo.Users (Id, Location) ON ps_a_to_z (Location) — base table (=clustered index) must be partition aligned, to allow STATISTICS_INCREMENTAL = ON on the location index GO CREATE NONCLUSTERED INDEX [Location] ON [dbo].[Users] ([Location]) WITH (DROP_EXISTING = ON, DATA_COMPRESSION = NONE, SORT_IN_TEMPDB = ON, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, STATISTICS_INCREMENTAL = ON ) ON ps_a_to_z (Location); GO

now I have a table who is partitioned by the location, the STATISTICS_INCREMENTAL = ON says, that it should get one statistic per partition (plus a combined one), but sadly the SQL server eliminates the statistics all besides one but didn’t use the partitions statistic, so the estimates are still wrong.

And I have several drawbacks, e.g. I need to specifiy the location to be able to query the UserID efficent and I can have the same UserId twice in several locations, except I create another unique nonclustered index on the UserId …

[…] Query Exercise: Solving The 201 Buckets Problem (Brent Ozar) […]

And because you just have to get your two cents in: Cancel reply

Brent Ozar

Hi! I’m Brent Ozar.

I make Microsoft SQL Server go faster. I love teaching, travel, cars, and laughing. I’m based out of Las Vegas. He/him. I teach SQL Server training classes , or if you haven’t got time for the pain, I’m available for consulting too.

  • Subscribe *

Insert/edit link

Enter the destination URL

Or link to existing content

IMAGES

  1. Add/Subtract Estimation Worksheet

    rounding and estimation problem solving

  2. rounding and estimation

    rounding and estimation problem solving

  3. [Solved]: Problem 1: (Rounding Numbers) The method Math.fl

    rounding and estimation problem solving

  4. Estimation Rounding Worksheets

    rounding and estimation problem solving

  5. Third Grade Math Skill Builders interactive help on standardized tests

    rounding and estimation problem solving

  6. Rounding Word Problems 3rd Grade

    rounding and estimation problem solving

COMMENTS

  1. PDF Problem Solving: Rounding and Estimating

    Problem Solving: Rounding and Estimating Front End Estimation The name comes from the way that you round. Instead of rounding each number to a given place value, we round whatever number is in the front. With front end estimation, we only round and calculate with numbers in the leftmost place or the very last number on the left. This means that all

  2. PDF Name: Period: Date: Problem Solving: Rounding and Estimating Guided Notes

    Sample Problem 3: Estimate the answer using rounding method. Front End Estimation The name comes from the way that you round. Instead of rounding each number to a given place value, we round whatever number is in the front. With front end estimation, we only round and calculate with numbers in the leftmost place or the very last number on the left.

  3. 8.1: Estimation by Rounding

    We could make a less accurate estimation by observing that 5,203 is near 5,000. The number 5,000 has only one nonzero digit rather than two (as does 5,200). This fact makes the estimation quicker (but a little less accurate). We then estimate the difference by \(5,000 - 3,000 =2,000\). and conclude that \(5,203 - 3,015\) is about 2,000.

  4. 1.2: Problem Solving and Estimating

    Name the number to the left of the decimal point. Write "and" for the decimal point. Name the "number" part to the right of the decimal point as if it were a whole number. Name the decimal place of the last digit. Example 1. Name the decimal \ (4.3\). Solution. Try It Now 1. Name the decimal \ (6.7\).

  5. Rounding Word Problems (printable, online, answers)

    Step 2: Round any numbers given in the problem to the nearest whole number, or to the nearest ten, hundred, or thousand, depending on the level of accuracy needed. Step 3: Use mental math to perform calculations quickly. For example, if you need to add 23 and 45, round them both to 20 and 50 and add those instead.

  6. Lesson: Problem solving with estimation and rounding

    Q1. A degree of accuracy shows how precise a or measurement is. For example, to the nearest cm, nearest 10, 1 s.f. and so on. Q2. Alex buys paper £4.95, USB £ , stamps £5.20, crisps £0.95, staples £1.10 and plug £1.99. He pays with a £20 note and receives about £2 back in change. Estimate the cost of the USB.

  7. Problem Solving: Rounding and Estimating

    Problem Solving: Rounding and Estimating . Volume. Speed. Enter Full Screen. Video Duration Elapsed Time: 00:00 / Total Time: 00:00. Timeline Progress. Playback 0% complete. Problem Solving: Rounding and Estimating . Section Lecture Video: Problem Solving: Rounding and Estimating ...

  8. Estimation, Approximation and Rounding

    Rounding is often the key skill you need to quickly estimate a number. This is where you make a long number simpler by 'rounding', or expressing in terms of the nearest unit, ten, hundred, tenth, or a certain number of decimal places. For example, 1,654 to the nearest thousand is 2,000. To the nearest 100 it is 1,700.

  9. PDF Name: Period: Date: Problem Solving: Rounding and Estimating Guided Notes

    Sample Problem 3: Estimate the answer using rounding method. Front End Estimation The name comes from the way that you round. Instead of rounding each number to a given place value, we round whatever number is in the front. With front end estimation, we only round and calculate with numbers in the leftmost place or the very last number on the left.

  10. Grade 4 estimating and rounding word problem worksheets

    These grade 4 word problem worksheets involve the use of rounding to estimate answers. Students are given a word problem and are asked to estimate the answer, by rounding numbers appropriately and choosing the correct arithmetic operation. Worksheet #1 Worksheet #2 Worksheet #3 Worksheet #4. Worksheet #5 Worksheet #6.

  11. 1-8 Problem Solving Rounding and Estimating

    1-8 Bell Work - Problem Solving Rounding and Estimating. 1-8 Exit Quiz - Problem Solving Rounding and Estimating. 1-8 Guided Notes SE - Problem Solving Rounding and Estimating. 1-8 Guided Notes TE - Problem Solving Rounding and Estimating. 1-8 Lesson Plan - Problem Solving Rounding and Estimating.

  12. Rounding Practice Questions

    The Corbettmaths Practice Questions on Rounding. Previous: Similar Shapes Area/Volume Practice Questions

  13. Estimating & rounding word problems

    Fast, approximate answers. Students use rounding and estimating to arrive at or select approximate answers to questions. The underlying operations are addition, subtraction, multiplication and division. Worksheet #1 Worksheet #2 Worksheet #3 Worksheet #4. Worksheet #5 Worksheet #6.

  14. Explain That: Rounding and Estimating

    Explain Rounding and Estimating Explain Rounding and Estimating Whole Number Rounding is a way of simplifying numbers to make them easier to understand or work with. Rounding can be used when an exact number isn't needed, and an approximate answer will do. For example, at the minute this is being written, exactly 299,588,632 people live in the United States (See the U.S. Census Bureau ...

  15. 1.5: Problem Solving and Estimating

    Solution. There are two approaches we could take to this problem: 1) estimate the number of boards we will need and find the cost per board, or 2) estimate the area of the deck and find the approximate cost per square foot for deck boards. We will take the latter approach.

  16. PDF Year 5 Estimate and Approximate Reasoning and Problem Solving

    Reasoning and Problem Solving Estimate and Approximate Reasoning and Problem Solving Estimate and Approximate Developing 1a. Various answers (depending on what the children choose to round to), for example: Taron's answer is likely to be incorrect because (when rounding to the nearest 100) an approximate answer to

  17. How to Teach Rounding and Estimating

    Then we'll try to estimate the answer by using the rounded numbers: 20,000 + 100 = 20,100. So by using front-end estimation, we managed to estimate that the answer to 15,345 + 122 is around 20,100. You can also use a calculator to find the exact answer and compare the estimation with the exact answer.

  18. Rounding & Estimation

    Identify the two options that the number could round to. e.g. the two nearest 100's to 1294 are 1200 and 1300. Be careful if your digit is a 9 and the next number up will affect the higher place values. e.g. the nearest 2 decimal places to 3.4 9 7 are 3.49 and 3.50. If the circled number is 5 or more then you round to the bigger number.

  19. Estimation Practice Questions

    Next: Triangular Numbers Practice Questions GCSE Revision Cards. 5-a-day Workbooks

  20. Rounding reasoning & problem solving

    Rounding reasoning & problem solving. Just a simple worksheet I created to extend all pupils into reasoning when rounding numbers to the nearest 10,100 & 1000. I have taken ideas from WhiteRose resources and laid them out into F (Fluency), R (Reasoning) and PS (Problem solving). Could be used as a teaching resource or assessment on the objective.

  21. PDF 1-8 Problem Solving: Rounding and Estimating

    Lesson about problem solving: rounding and estimating. PreAlgebraCoach.com . Author: Rafae Created Date: 5/25/2017 7:40:32 PM ...

  22. Query Exercise: Solving The 201 Buckets Problem

    As our data size grows, these estimate variances start to become problematic. Now granted, this succeeds in the same way the 2010 query succeeds: we get an index seek, it's still less logical reads than a key lookup plan would be, the single-threaded thing isn't a problem for a 27 millisecond query, and we don't spill to disk.

  23. PDF Name: Period: Date: Problem Solving: Rounding and Estimating Assignment

    Estimate the speed of the plane after it has slowed down by rounding each number to the nearest ten. kilometers per hour→ kilometers per hour