作业帮 > 综合 > 作业

I have three Excel homework as follow,but I have no idea how

来源:学生作业帮 编辑:拍题作业网作业帮 分类:综合作业 时间:2024/04/29 22:51:55
I have three Excel homework as follow,but I have no idea how to do them. Is there someone help me?
1.Create a VBA function that generates random numbers from a triangular
distribution. In Excel, generate 1000 random numbers using this function and show the
distribution of outcomes in a histogram.
2. Create a VBA function that generates random integers greater than 0 using an
exponential distribution.
3. Here is a probability density:
f (x) = .0064x3 0 ≤ x ≤ 5
Create a VBA function that generates random numbers from this distribution using the
inverse transform method. Also, create a VBA function that generates random numbers
from a to b, a truncation (or sub-range) of the density.
.全英文.我至少看懂了标题.