A spreadsheet is developed for modeling wind distribution through the Weibull distribution. Two parametes of the Weibull distribution are sufficient for the modeling. The Excel macro has been used to determine these parameters. The parameters are determined by six methods: graphical method (GM), maximum likelihood method (MLM), method of moments (MM), energy pattern factor model (EPFM), empirical method (EM), and modified maximum likelihood method (MMLM). Each of these six methods has a corresponding button on the spreadsheet; this button calculates parameters "k" and "c" of the Weibull distribution on activation. These buttons also find the average wind speed and statistical errors; root mean square errors (RMSE); chi-square statistics, and the coefficient of determination for validation of the results. To check the effectiveness of the spreadsheet, the wind speed data of Volkel, Gilze-Rijen, Eindhoven, and Herwijnen, cities in the Netherlands, during the years 2015 and 2016, were used. The data were obtained from the Royal Netherlnds Meterological Institute. The spreadsheets also generates the probability density function using parameter values obtained by the six methods; these are shown on a single plot of the probabilities against the wind speed.
分享
引用
