In Excel, the RAND function generates random numbers between 0
and 1
compute the expectation and Standard...
90.2K
Verified Solution
Link Copied!
Question
Statistics
In Excel, the RAND function generates random numbers between 0and 1
compute the expectation and Standard deviation.
Hints
a = 0 , b = 1
P(x1<= X <= x2) = F(x2) - F(x1)
Answer & Explanation
Solved by verified expert
4.1 Ratings (683 Votes)
I assume you are telling about generating multiple random numbers between 0 and 1 and calculating mean and standard deviation of them For thatin A1 cell write RAND so that
See Answer
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!