My company received trade flow data from Implan for use in determining trade flows between regions in Colorado and between those regions and other states. I am having trouble interpretting the data that is yielded after running each query. We received the data in Microsoft Access format. Here are my questions: 1) What are the units yielded in a query? 2) What does the data yielded in a query represent? 3) Are the totals of all queries representative of the GDP for hte state or are they representative of total economic activity? Allow me to explain the data, the metholodology I took in aggregated commodities of trade and what data it yielded. When looking at the data table in Access, there are four columns: Commodity, OriginIndex, DestinationIndex, and Value. There is no explanation of what each column means or is represented by except that there are other tables that list all the commodity codes and the index of locations, which are all counties in the U.S. For example, the data is supposed to give us an idea of the economic value of agriculture traded from one region in Colorado to another region in Colorado. I run a query which I created. This query pulls values from the data table for selected commodity codes going from one set of counties to another set of counties. The result is added together by Access and yields a number total under the "Value" column. Let's say I run my query to find all agricultural trade from Central Colorado to the Front Range and I receive a number of 32.13. One assumption I have been making is that the value I receive is a dollar amount, perhaps in millions, but I'm unsure of this. What caused my uncertainty is that all trade to other states is a similar number for all commodities and all regions, regardless of the fact that they should be different. Eastern Colorado, for exmaple, produces 85% of Colorado's agricultural products and should have a similarly different amount traded out-of-state compared to other regions. Value traded for agriculture from other states to each region, however, are very similar (about 79,000 for each region). This is not right. In fact, value traded to each region from other states is about 79,000 for all commodities. I have attached the Excel file with all the final data on it to show anyone who wants to help me. Another discrepancy that is concerning is that the total values added together for each region are higher than the total GDP for the state of Colorado. Perhaps this is a simple data misunderstanding. Again, I am NOT working with the IMPLAN software. It was not included in our package. We do not have any manuals for the data. Is there anywhere to find the answers to my questions other than here? Thank you, Christina [file name=Goods_and_Services_Inbound_Region_Statistics.doc size=95232]http://implan.com/media/kunena/attachments/legacy/files/Goods_and_Services_Inbound_Region_Statistics.doc[/file]
Please sign in to leave a comment.