En cours

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

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é à :

koolsidz

Excel Whiz here. Easy Job. Please see pMB

80 $ USD en 0 jours
(41 Commentaires)
5.0

9 freelance ont fait une offre moyenne de 76 $ pour ce travail

djain01

Hi, Lets do it. Thanks djain

150 $ USD en 10 jours
(76 Commentaires)
5.8
Krusche

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

70 $ USD en 2 jours
(24 Commentaires)
5.7
Kryptora

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

70 $ USD en 2 jours
(39 Commentaires)
5.5
winnet21

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

70 $ USD en 7 jours
(12 Commentaires)
5.0
INSTANTCODER

Can be done perfectly and quickly.

50 $ USD en 2 jours
(51 Commentaires)
4.6
Nhcuong

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

70 $ USD en 12 jours
(16 Commentaires)
4.4
monotoshroybd

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

50 $ USD en 3 jours
(2 Commentaires)
2.0
wrenda

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

75 $ USD en 2 jours
(0 Commentaires)
0.0