Homebrewed Electricity > Frequently Asked Questions (FAQs)

How can I do the relation between (standard deviation and mean wind speed)

(1/2) > >>

firas:
Pleas, if anyone can tell me,
how can I do the scatter plot of the relation between Std. and Mean wind speed.

David HK:
I think you need some expert help on this subject and recommend that you go to the Excel Help Forum for assistance.

There are some very clever people on that web site.  The URL is here:-

http://www.excelforum.com/

You will need to register, which is easy, and, if possible, upload your file (I assume it is Excel format) so that the experts can play with it. Please be very specific in explaining what you wish to achieve.

David in Hong Kong

firas:
Thank you very much Mr. David

SparWeb:
The users of the Excel group may not know your goal, however.

Typically wind speed recordings are presented in histogram format, and then a Weibull distribution is fit to the data.
They may not know this if you do not bring up the subject, and even so lead you astray.

It looks like you have enough data to build a very detailed histogram.
I am unfamiliar with any uses of mean-versus-standard-deviation graphs, but I'm not a statistician.

Here's my old wind data:

firas:
Dear SparWeb,
which method do you think it is perfect way to make best data fit (weibull distribution)?
firas

Navigation

[0] Message Index

[#] Next page