Excel VBA Statistics

Create a button which will open a popup in Excel. The popup will ask the user to “Enter a cell” (say “A1”), “Number of simulations” (say 1000) a “Start of histogram” (say 0), “End of histogram” (say 1), “Number of bins” (Say 10) an OK button and a Cancel button.

When the user hits OK, Excel will “hit F9” (using code of course) 1000 times and save the numbers displayed in the given cell (A1) in an array. For example, if cell A1 contains “=RAND()”, it will then save 1000 drawings from U(0,1).

Then, the code should create a new worksheet. In this sheet, display the average and the sample variance of the 1000 numbers, a histogram based on the data entered and a graph of the histogram (which will then show the empirical pdf of U(0,1))

Compétences : PHP, Architecture Logicielle, Visual Basic

en voir plus : excel vba statistics, vba statistics, sample graph data, graph sample data, ask excel, array graph, histogram vba, excel vba and, end vba, vba excel pdf, variance, save to excel, histogram, excel/vba, create excel worksheet, display number hits graph, excel contains, excel create graph, display excel cell, php popup pdf, sample visual basic excel, sheet excel visual basic, excel array, php excel array, excel cell

Concernant l'employeur :
( 1 commentaire ) lund, Sweden

Nº du projet : #2369537

Décerné à:


Excel Whiz here. Easy Job. Please see pMB

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 0 jours
(41 Commentaires)

9 freelance font une offre moyenne de $76 pour ce travail


Hi, Lets do it. Thanks djain

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(76 Commentaires)

We are the professionals you need to create this application for you. Please check PMB.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(24 Commentaires)

Hello, I see you require an Excel macro that can provide you statistics based on the histogram values given. I have sent your a private message about my skills and previous experience in similar projects. I rest-assure Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(39 Commentaires)

Hi, I have experience with this project hope to work with you in this project regards

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(12 Commentaires)

Can be done perfectly and quickly.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(51 Commentaires)

Hi, I can do this with VBA and designed user form. I'm programmer for years and very familiar with excel vba. Could you give more detail requirements: - what excel version you use: 2003, 2007,2010 windows, or 2008, Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 12 jours
(16 Commentaires)

Dear Sir, I am working on core VBA programming more than 7 years.I am read carefully of your requirement. I am very comfortable of your project Regards Monotosh

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(2 Commentaires)

Hi! Experienced VBA developer that will do a job of good quality.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)