Solved Exercises on Using Data to Solve Problems in Grade 5

Master using data to solve problems: analyzing data sets, making decisions with data, drawing conclusions, and applying statistical measures to real-world scenarios through these 5 detailed exercises.

Solution: Exercises 1 to 3
1 School Survey Problem
Exercise 1
A school surveyed 100 students about their favorite lunch option: Pizza (35), Sandwich (25), Salad (15), Pasta (20), Soup (5). The school wants to decide which lunch to offer most often. Based on the data, which option should be offered most frequently? Justify your answer using statistical reasoning.
Definition:

Data-Driven Decision: Making choices based on statistical analysis of collected data

Mode: The value that appears most frequently in a dataset

Problem-Solving Method:
  1. Analyze the data to identify the most popular choice
  2. Calculate percentages for better understanding
  3. Determine which option represents the mode
  4. Make a recommendation based on statistical evidence
Data
Pizza:35, Sand:25, Sal:15, Past:20, Soup:5
Mode
Pizza
Percent
35%
Step 1: Identify the most popular choice

• Pizza: 35 students

• Sandwich: 25 students

• Pasta: 20 students

• Salad: 15 students

• Soup: 5 students

Step 2: Calculate percentages

• Pizza: 35/100 = 35%

• Sandwich: 25/100 = 25%

• Pasta: 20/100 = 20%

• Salad: 15/100 = 15%

• Soup: 5/100 = 5%

Step 3: Identify the mode

• Pizza appears most frequently (35 times)

• Pizza is the mode of this dataset

Step 4: Make a recommendation

• Pizza is the most popular choice at 35%

• This represents the largest group of students

• Recommendation: Offer pizza most often

Pizza (35%) should be offered most frequently
Final answer:

The school should offer pizza most often since it is the mode (most popular choice) with 35% of students preferring it.

Applied rules:

• Mode identification: Find the most frequently occurring value

• Percentage calculation: Part ÷ Whole × 100

• Data-driven decision: Use statistical evidence for recommendations

2 Store Inventory Problem
Exercise 2
A store recorded daily sales for one week: Monday ($240), Tuesday ($180), Wednesday ($220), Thursday ($300), Friday ($260), Saturday ($400), Sunday ($150). The store manager needs to determine which days to schedule extra staff. Based on the data, which days would you recommend for extra staffing? Use mean and median to justify your answer.
Definition:

Mean (Average): The sum of all values divided by the number of values

Median: The middle value when data is arranged in order

Sales
$150,$180,$220,$240,$260,$300,$400
Mean
$250
Median
$240
Step 1: Calculate the mean sales

• Sum: $240 + $180 + $220 + $300 + $260 + $400 + $150 = $1,750

• Count: 7 days

• Mean = $1,750 ÷ 7 = $250

Step 2: Calculate the median sales

• Arrange in order: $150, $180, $220, $240, $260, $300, $400

• With 7 values (odd), median is the 4th value

• Median = $240

Step 3: Identify days above average

• Days with sales > $250: Thursday ($300), Friday ($260), Saturday ($400)

Step 4: Make staffing recommendations

• Saturday ($400) has the highest sales

• Thursday and Friday also have above-average sales

• Recommend extra staff on Thursday, Friday, and Saturday

Extra staff: Thursday, Friday, Saturday
Final answer:

Extra staff should be scheduled on Thursday, Friday, and Saturday as these days have sales above the mean of $250.

Applied rules:

• Mean calculation: Sum ÷ Count

• Median identification: Middle value of ordered data

• Comparison: Compare values to mean for decision-making

3 Sports Team Performance
Exercise 3
A track team recorded their running times (in seconds) for a 400m race: 65, 72, 68, 70, 66, 75, 69, 71, 67, 73. The coach wants to identify the typical performance time and determine which runners performed significantly better than average. Calculate the mean and identify runners who finished faster than the mean time.
Definition:

Typical Performance: The average or median value representing normal performance

Significant Performance: Times that are notably different from the average

Times
65,66,67,68,69,70,71,72,73,75
Mean
69.6 sec
Better Times
≤ 69.6 sec
Step 1: Calculate the mean time

• Sum: 65 + 72 + 68 + 70 + 66 + 75 + 69 + 71 + 67 + 73 = 696

• Count: 10 runners

• Mean = 696 ÷ 10 = 69.6 seconds

Step 2: Identify runners faster than mean

• Faster times: 65, 66, 67, 68, 69 seconds

• These are all less than 69.6 seconds

Step 3: Calculate median for comparison

• Arrange in order: 65, 66, 67, 68, 69, 70, 71, 72, 73, 75

• With 10 values (even), median is average of 5th and 6th values

• Median = (69 + 70) ÷ 2 = 69.5 seconds

Step 4: Analyze results

• Mean time: 69.6 seconds (typical performance)

• Runners faster than average: 5 out of 10 runners

• Top performers: Those with times of 69 seconds or less

Mean: 69.6 sec, Better performers: 5 runners
Final answer:

The mean time is 69.6 seconds. Five runners (with times 65, 66, 67, 68, and 69 seconds) performed better than the average.

Applied rules:

• Mean calculation: Sum of values ÷ Number of values

• Comparison: Compare individual values to the mean

• Performance analysis: Identify values that exceed expectations

Data-Driven Problem Solving Fundamentals
Mean = Sum ÷ Count
Mean Formula
Mean
Average
Central tendency measure
Median
Middle Value
Robust measure
Mode
Most Frequent
Popular choice indicator
Data Analysis: Examine data to identify patterns, trends, and insights.
Statistical Reasoning: Use measures like mean, median, and mode to make informed decisions.
Tip 1: Always organize data before analysis to identify patterns easily.
Tip 2: Use mean for average performance, median for middle performance.
Tip 3: Mode helps identify the most popular choice or common occurrence.
Tip 4: Compare individual values to measures of central tendency to identify outliers.
Solution: Exercises 4 to 5
4 Product Sales Analysis
Exercise 4
A toy store tracked monthly sales of five different toys: Action Figures (45), Dolls (38), Building Blocks (52), Puzzles (28), Board Games (40). The store wants to decide which toys to promote in their next advertisement campaign. Using statistical measures, recommend which toys to feature and explain your reasoning.
Definition:

Product Performance: How well different products sell relative to each other

Marketing Strategy: Using data to make informed decisions about product promotion

Sales
AF:45, Dolls:38, BB:52, Puz:28, BG:40
Sorted
28,38,40,45,52
Mean
40.6
Step 1: Calculate the mean sales

• Sum: 45 + 38 + 52 + 28 + 40 = 203

• Count: 5 toys

• Mean = 203 ÷ 5 = 40.6 units

Step 2: Calculate the median sales

• Arrange in order: 28, 38, 40, 45, 52

• With 5 values (odd), median is the 3rd value

• Median = 40 units

Step 3: Identify the mode

• Each toy sold a different number of units

• No repeating values, so no mode exists

Step 4: Identify top-performing toys

• Toys selling above mean (40.6): Building Blocks (52), Action Figures (45)

• Building Blocks is the highest performer (52 units)

Step 5: Make promotion recommendations

• Feature Building Blocks and Action Figures in the campaign

• These are the two best-selling products

• Capitalize on their proven popularity

Promote: Building Blocks (52), Action Figures (45)
Final answer:

Feature Building Blocks and Action Figures in the advertisement campaign as they are the two top-selling products, exceeding the mean sales of 40.6 units.

Applied rules:

• Mean comparison: Identify values above average performance

• Top performers: Focus marketing efforts on best-selling items

• Resource allocation: Invest in promoting successful products

5 Attendance Tracking Problem
Exercise 5
A community center recorded weekly attendance for a fitness class over 8 weeks: 15, 18, 16, 20, 14, 19, 17, 21. The center wants to plan resources for the upcoming months. Calculate mean, median, and range to help them plan. How many participants should they expect on average, and what capacity should they prepare for?
Definition:

Capacity Planning: Using historical data to predict future resource needs

Range: The difference between the highest and lowest values in a dataset

Attendance
15,18,16,20,14,19,17,21
Sorted
14,15,16,17,18,19,20,21
Stats
Mean:17.5, Med:17.5, Rng:7
Step 1: Calculate the mean attendance

• Sum: 15 + 18 + 16 + 20 + 14 + 19 + 17 + 21 = 140

• Count: 8 weeks

• Mean = 140 ÷ 8 = 17.5 participants

Step 2: Calculate the median attendance

• Arrange in order: 14, 15, 16, 17, 18, 19, 20, 21

• With 8 values (even), median is average of 4th and 5th values

• Median = (17 + 18) ÷ 2 = 17.5 participants

Step 3: Calculate the range

• Highest value: 21

• Lowest value: 14

• Range = 21 - 14 = 7 participants

Step 4: Analyze the data for planning

• Average attendance: 17.5 participants

• Typical attendance: 17-18 participants

• Range indicates variation of 7 participants

Step 5: Make capacity recommendations

• Expected average: 17-18 participants

• Maximum expected: 21 participants (highest observed)

• Recommendation: Prepare for 20-22 participants to accommodate peak attendance

Mean: 17.5, Median: 17.5, Range: 7, Capacity: 20-22
Final answer:

On average, expect 17.5 participants. Plan for 20-22 participants to accommodate peak attendance, as the range shows variation of 7 participants from lowest to highest.

Applied rules:

• Planning with data: Use mean for average expectations

• Capacity buffer: Plan for values higher than mean to account for variation

• Range consideration: Account for data spread in planning decisions

Comprehensive Summary: Using Data to Solve Problems
Mean = Sum ÷ Count
Mean Formula
Key definitions:

Data-Driven Decision Making: Making choices based on statistical analysis of collected data

Mean (Average): The sum of all values divided by the number of values

Median: The middle value when data is arranged in numerical order

Mode: The value that appears most frequently in a dataset

Range: The difference between the highest and lowest values in a dataset

Statistical Reasoning: Using measures of central tendency to draw conclusions

Capacity Planning: Using historical data to predict future resource needs

Performance Analysis: Evaluating data to identify trends and outliers

Data-driven problem-solving methodology:
  1. Collect data: Gather relevant information for the problem
  2. Organize data: Arrange data in a systematic way
  3. Calculate measures: Find mean, median, mode, and range
  4. Analyze patterns: Look for trends, outliers, and relationships
  5. Draw conclusions: Interpret statistical measures in context
  6. Make decisions: Use data to inform choices and recommendations
  7. Validate: Check that conclusions make logical sense
Tip 1: Always organize data before analysis to identify patterns easily.
Tip 2: Compare individual values to the mean to identify exceptional performance.
Tip 3: Use the mode to identify the most popular choice or common occurrence.
Tip 4: Consider the range when planning to account for data variation.

Common errors: Forgetting to organize data, misinterpreting statistical measures, ignoring context.
Key concepts: Statistical reasoning, data interpretation, problem-solving, decision-making.
Essential formulas and rules:

• Mean: Sum of values ÷ Number of values

• Median: Middle value of sorted data (or average of two middle values)

• Range: Maximum value - Minimum value

• Percentage: (Part ÷ Whole) × 100

• Comparison: Individual values vs. statistical measures

• Decision-making: Use data to inform recommendations

Exercise with Visualization: Data-Driven Decision Making
Exercise 6: Analyzing Weekly Sales Trends
Analyze weekly sales data to make business decisions:
Week 1: $200, Week 2: $250, Week 3: $180, Week 4: $300, Week 5: $220, Week 6: $280
Calculate: Mean, Median, Range for decision making

Analysis: The chart shows how statistical measures help make data-driven decisions for business planning.

  • Mean: Average weekly sales ($238.33)
  • Median: Middle value of sales ($235)
  • Range: Variation in sales ($120)
  • Peak week: Week 4 ($300)

Questions & Answers

Question: How do I know which statistical measure to use when making decisions?

Answer: Choose based on your question:

  • Mean: When you want the average or typical value
  • Median: When you want the middle value (not affected by extremes)
  • Mode: When you want to know the most common value
  • Range: When you want to know how spread out the data is

For example, if you want to know typical sales, use the mean. If you want to know the most popular item, use the mode!

Question: What if the mean is not a whole number? Should I still use it?

Answer: Yes, you can still use the mean even if it's not a whole number:

  • The mean represents the average conceptually
  • Round to an appropriate decimal place if needed
  • Use the mean for comparison purposes

For example, if mean sales are $238.33, you can say average sales are about $238 per week!

Question: How do I use data to make predictions about the future?

Answer: Use historical data to predict future trends:

  • Calculate averages: Use mean for typical future values
  • Consider range: Account for possible variations
  • Look for patterns: Identify trends in the data
  • Plan conservatively: Prepare for likely scenarios

For example, if average attendance is 17.5, plan for about 18 people but prepare for up to 22 to be safe!