I have three Excel homework as follow,but I have no idea how
来源:学生作业帮 编辑:作业帮 分类:综合作业 时间:2024/10/06 19:47:57
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.
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
I have no idea as to how it is done.
I have no idea how to
I have no idea
I want to eat an apple but I have no idea how to
-----Has Sam finished his homework today?-----I have no idea
I have no idea.But I will never give up.
I have no idea as to know how it is done
I have no idea as to knowing how it is done.
I have no idea how old he is ,but he looks ( well) over four
1.I have no idea---
I have no idea ()