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))
9 freelance font une offre moyenne de $76 pour ce travail
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
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
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