Statistical analysis and playing around with incidence rates

#1
Dear TalkStats Members,

I am a bloody noob to R (used SPSS till now) and decided to learn R now.

My first quest would be following:

I have incidence rates in an Excel file for a disease, which look quite like this:

Year Total Male Female
2003 0.3 0.4 0.2
2004 0.3 0.3 0.3
.....
2013 0.4 0.3 0.5


My goal would be to:

1. analyze if there is a statistical significant change from 2003 to 2013 in the incidence rates or not.

2. maybe "project" the incidence rates for 2015 2020, like a linear regression ? Or maybe someone of you has a better idea to spice up the data.

What method should I use and how can I apply that via R ?

Best regards :wave:

AAWWR Mike