Updating Implan Agriculture Data
Our university has purchased the 2013 state data set in order to perform a contribution of agriculture analysis. In the past, we have updated the agriculture sectors using newer data published by NASS and ERS; however, new reporting methods by ERS has made this job more difficult, if not impossible using our current method.
I have attached an excel file showing our past methods used for updating the agriculture sectors. We would basically take data from either NASS's value of production or ERS's cash receipts and use those as the new output values from which to calculate the remaining fields. Since the ERS cash receipt data is now being reported in condensed form, I'm no longer sure how to break apart each sector to determine the new total sector value. Could you please advise a proper method for updating? Is an update even necessary?
Thanks!
Was this post helpful?
-
IMPLAN SupportHello, That is unfortunate indeed. One recommendation would be to use the most recently available detailed ERS data and create calculate the proportions each of them make up of their aggregate ERS sector, then apply those proportions to the latest ERS figures to break them out into more detail. This would be equivalent to projecting the latest detailed ERS data using the trend in the aggregate value. These approaches assume that each detail crop makes up the same proportion of the larger crop category across time – i.e., that each detail crop grows/shrinks at the same rate as the other detailed crops in that aggregate crop category. This probably wouldn’t be a bad assumption in the short-term but would become less defensible over time. Luckily the Census of Agriculture, which is conducted every 5 years, would provide data at a more detailed level which should allow you to update those proportions. It may also be possible that NASS reports the more detailed values somewhere, but are likely significantly harder to find than ERS data.0
Please sign in to leave a comment.
Comments
1 comment