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 triangulardistribution. In Excel, generate 1000 random numbers using this function and show

来源:学生作业帮助网 编辑:六六作业网 时间:2024/12/24 20:39:57
IhavethreeExcelhomeworkasfollow,butIhavenoideahowtodothem.Istheresomeonehelpme?1.CreateaVBAfunctiont

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 triangulardistribution. In Excel, generate 1000 random numbers using this function and show
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.

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 triangulardistribution. In Excel, generate 1000 random numbers using this function and show
.全英文.我至少看懂了标题.