Estimation of Weibull Distribution Parameters by Using Excel Solver Tool for Wind Speed Data at Al-Aziziyah, Libya

Abstract

In latest years, the Weibull distribution was a widely used, acceptable, and suggested distribution for expressing the wind speed frequency distribution in literatures. In this paper, the excel solver tool (EST) was used to improve the estimation of the Weibull distribution coefficients for the wind speed data used in the paper presented by Hosni Mokhtar, et al. [1], which studies the assessment of seven methods for calculating the Weibull distribution parameters for Al-Aziziyah city, Libya, with the results indicating that the Modified Maximum Likelihood Method (MML), Maximum Likelihood Method (MLM) and Empirical method of Justus (EMJ) are the most appropriate methods. Various goodness of fit tests at different heights at site are used to evaluate the applicability of these methods. A comparing of relative inaccuracy of power density estimate findings from earlier and current investigations is also carried out to illustrate the accuracy of employing a solver excel tool. The findings of this study show that using solver excel to estimate Weibull parameters is a viable option, and that it may be more suitable than other approaches. A most significant benefit of EST is that it does not need the formulation of complicated mathematical equations that require the use of difficult numerical techniques to solve. It’s relatively simple to estimate the Weibull parameters if simply the wind speed distribution is known.