• Understand how to calculate total marks and averages using spreadsheets.
• Learn to use formulas like =SUM() and =AVERAGE() in spreadsheet applications.
• Identify the structure of spreadsheets, including rows, columns, and cells.
• Calculate the mean and median of a dataset.
• Analyze how adding or removing values affects the mean and median.
• Visualize data using graphs, including line graphs and dot plots.
• Interpret data to derive insights and answer questions.

Notes on Mean and Median

Introduction

• The mean is the sum of all values divided by the number of values.
• The median is the middle value when the data is sorted.

Understanding Mean and Median

• Mean Calculation:
  • Example: Mean of 3 and 7 is (3 + 7) / 2 = 5.
• Median Calculation:
  • Example: For the data set [1, 3, 5], the median is 3.

Effects of Adding or Removing Values

• Adding a value greater than the mean increases the mean.
• Adding a value less than the mean decreases the mean.
• Removing a value equal to the mean does not change the mean.

Spreadsheet Usage

• Use spreadsheet software to calculate totals and averages quickly.
• Example Formula: =SUM(B3:G3) calculates total marks for a student.

Observations from Data

• The average height of a class can change based on new admissions.
• Example: If the average height is 150.2 cm and two new students with heights 149 cm and 152 cm join, the average will need recalculating.

Dot Plots and Data Distribution

• Dot plots can visually represent data and help in calculating mean and median.
• Example: A dot plot showing the number of times students rode their cycles can help find the average and median.

Important Concepts

• Mean as a Measure of Central Tendency: Represents the 'center' of the data.
• Median Stability: The median may not change with the addition of values unless they are extreme outliers.

Conclusion

• Understanding mean and median is crucial for data analysis and interpretation.