Problem 1 the data (what is needed for the problems) is in worldpopulation
Sorry, I had a mistake in my dataset, for Macedonia in 1980 I had "2", not the correct "1792"
Problem 2 Calc > Calculator, Store in:c6 Expression: '2000' - '1980'
Data > Sort > Sort Column: Country c6, by Columns c6
shows that India had the largest increase (323million) and Bulgaria had the largest decrease (1million)
Problem 3 Calc > Calculator, Store in:c6 Expression: ('2000' - '1980') / '1980' * 100
Data > Sort > Sort Column: Country c6, by Columns c6
shows that Northern Mariana Islands had an increase of 324% and Montserrat had a decrease of 50%. (?????)
Problem 4 Data > Subset worksheet, Rows that match (click on Condition) '1980' > 10000
Data > Sort > Sort Column: Country c6, by Columns c6
shows that Uganda had the largest increase (90%) and Hungary had the largest decrease (5%)
Problem 5 Calc > Calculator, Store in: c6, Expression: '2000' / 'Area'
Data > Sort > Sort Column: Country c6, by Columns c6
shows that Puerto Rico has the 20th position with 1131 people per square mile
Problem 6 Calc > Calculator, Store in: log(1980) Expression: LOGT('1980')
same for 2000
Graph > Scatterplot, Simple > Y variables= log(2000), X variables= log(1980), Labels: title: Population Change from 1980 to 2000, Dr. Rolke, subtitle on log scale, ok
click on axis labels and edit
add text with T symbol, add line with lines symbol, select line, right-click, Edit line, change to arrow.
BONUS We have
log('2010') = 0.0741 + 0.996 log('2000')
so
log('2010') = 0.0741 + 0.996 log(3916) = 0.0741 + 0.996·3.61151 = 3.65267
and so
Population in 2010 = 103.65257 = 4493