Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. statistics
  3. in excel, the rand function generates random numbe

In Excel, the RAND function generates random numbers between 0 and 1 compute the expectation and Standard...

90.2K

Verified Solution

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: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Geometry
1.2K views

Side 2 is adjacent to angle X 3 1 X

Basic Math
1.2K views

Find a set of parametric equations for the tangent line to the curve of intersection of...

Statistics
1.2K views

The time between arrivals of parts in a single machine queuing system is uniformly distributed from...

Physics
1.2K views

(This has to do with Physics) 6.1.1 How does a capacitor charge?    6.1.2 How does a capacitor...

Physics
1.2K views

What the physics behind a Ballista?

Physics
1.2K views

eat capacity at constant pressure of a certain system is a function of temperature only...

Geometry
1.2K views

Write a function based on the given parent function and transformations in the given order...

Basic Math
1.2K views

Find the center of mass of the given system of point masses lying on the...

Basic Math
1.2K views

Determine the total area under the standard normal curve in parts (a) through (c) below.(a)...

Statistics
1.2K views

A sample of n 25 scores is selected from a normal population with a mean...

Calculus
1.2K views

Find the quotient and remainder using synthetic division 4x3 16x2 12x 3 X 5 quotient...

Accounting
1.2K views

On January 1. 2023. Pronghorn Company purchased $416,000 worth of 8% bonds of Aguirre Co....