Scatter plot



Final assignment
•Deadline January 28th
•Own issue
•Usage of tools introduced in course
•

Relationship of two interval variables
•Correlation
•
•Weight x height
•Unemployment rate x purchase power
•Hours of reading x points in test
•
•

Three types of correlation in a scatter plot undefined



Scatterplot



outliers
overplotting


Log axis
•Solution when there is a lot of small values and a few high values
•Typical situation: population
•Problem: it does not work for 0 and negative numbers
•
Right click here
a quantity representing the power to which a fixed number (the base) must be raised to produce a
given number (eg for 100 it is 2 because 10power2 is 100)
- does not work for zeros!!! (solution replace (ctrl+h) by number between 0 and 1 (e.g. 0.1)
Excel leaves the labels as not transformed, but it change look of axis

Both axes logged



Add point labels



•Overlays need to be managed manualy
•Use short names or abbreviations


Add lines
•Trend line
•Linear
•Exponential
•
•Quartals
•

•



Add quartals



•
Right click here
From minimum to average
From average to maximum

•



Trend line
•


Set of boxplots