title: R trying to predict future population
body: <p>There may be a a pretty easy solution but I'm new at R so I'm having a hard time trying to understand getting this solution for this exercise im figuring out.</p>
  
  <p>I basically have the following data and want to predict a linear regression of the following data for 2020.</p>
  
  <blockquote>
    <p>data
       Geographic.Area   Census Estimates.Base    X2010    X2011    X2012    X2013
    15         Florida 18801310       18804592 18849098 19096952 19344156 19582022
          X2014    X2015    X2016 X2020
    15 19888741 20244914 20612439     0</p>
  </blockquote>
  
  <p>Each year is its own column with 2020 having a value of 0. Trying to predict its value.</p>
  
  <p>I know I have to start out with something in the following path:</p>
  
  <blockquote>
    <p>linear = lm(X2020 ~ years, data=data)</p>
  </blockquote>
  
  <p>But am getting errors and the returned numbers arent correct. How should I continue with this? The answer might be pretty simple but im still trying to understand how this works so I can predict the 2020 value.</p>
  
  <p>Edit:
  As for code I have done the following which I can see is wrong. But unsure as to what steps to take to correct it.</p>
  
  <blockquote>
    <p>linear = lm(X2020 ~ X2010 + X2011 + X2012 + X2013 + X2014 + X2015 + X2016, data=florida)
    linear</p>
  </blockquote>
  
  <p>Call:
  lm(formula = X2020 ~ X2010 + X2011 + X2012 + X2013 + X2014 + 
      X2015 + X2016, data = florida)</p>
  
  <p>Coefficients:
  (Intercept)        X2010        X2011        X2012        X2013        X2014<br>
            0           NA           NA           NA           NA           NA<br>
        X2015        X2016<br>
           NA           NA  </p>