Using VBA to Establish a Sampling Model for Food Surveillance Market Investigation

碩士 === 逢甲大學 === 統計學系 === 105 === Domestic food security problems in recent years, to arouse people's great atten-tion to food security, but food kind is numerous in quantity and the project needing measuring is various, if adopt comprehensive test and consume a lot of resources, so monitor and...

Full description

Bibliographic Details
Main Authors: KUO,CHIH-YEN, 郭峙延
Other Authors: LIN,LIE-FEN
Format: Others
Language:zh-TW
Published: 2017
Online Access:http://ndltd.ncl.edu.tw/handle/f68ub3
Description
Summary:碩士 === 逢甲大學 === 統計學系 === 105 === Domestic food security problems in recent years, to arouse people's great atten-tion to food security, but food kind is numerous in quantity and the project needing measuring is various, if adopt comprehensive test and consume a lot of resources, so monitor and check on the food security on the Food Surveillance Market. This research will carry on the discussion to the sample method of market research after the food with statistics principle and Credibility Theory, the analytic target includes materials and dispersed materials continuously type and draw the annual trend picture then calculate several dispositions in order to carry on all counties and cities and sample of weight of each of counties and cities; And all counties and cities sample and count and dispose and consider three kinds of different situations separately, including considering the counties and cities output, considering the counties and cities output and considering the counties and cities output and annual standard deviation coefficient. And predict the quality assessing the method in the group by this to these three ways. And besides output factor, the intersection of time and relation and make a variation important factor that intensity consider in order to predict the method also, can make all sample of counties and cities count and dispose and get more appropriate data result, use VBA procedure to analyze movements and every trend picture and data analysis result appear fast finally, systemic sample way of market research after setting up food.