I will provide data set (100+ values) in excel (attached) and I need you to provide formula in excel that calculates with distribution function that is based on that data.
1) finding proper distribution and its parameters from the data (doesn’t need to be normal distribution)
2) do formula f(X) that returns value from cumulative distribution function (probability that value X is bigger than random value from distribution)
3) Make distribution parameters dependent on "condition" column - calculate them only for values in "condition" column that are smaller than input value C (provided by user) - function f(X,C)
Classical statistics, nothing fancy.
If im ok with result there is several more datasets for analysis.
15 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
Hi, I have gone through your project description and would like to help you on this project.i am a professional Civil Engineer and an expert in [login to view URL] free to contact me anytime. Best Regards
Hi Ondrej, I am good in excel and can help you in Getting cumulative distribution function for provided data [login to view URL] message me so as to discuss further on the [login to view URL]
hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I feel fit myself for this project. please contact with me. Thanks.