Monday 18 November 2013

Scatter Plots, Excel and finding averages

Objectives:

  • Line of best fit 

  • Use Excel to display data

  • Calculating the mean, median, mode and range for statistical data.

  • Frequency polygons

 ___________________________________________

Scatter Plots

See an Excel tutorial on how to draw a scatter plot and line of best fit

 

Review of mean, median and mode:




 





Remember that very large or very small figures in a list of data can affect the mean and the range.
The median and the mode are less affected.


Frequency Polygons



Just as 'averages' can be misleading, look at this link to see how graphs of statistical data can be misleading.


Homework

(P143      Ex 8    Q5)

(P153      Ex 10  Q3, Q11)

P158      Ex 11  Q3

P160       Ex4A  Q6

P164/165   Ex 4B  Q7