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

In Excel, the RAND function generates random numbers between 0 and 1

compute the expectation and Standard deviation.

Hints

a = 0 , b = 1

P(x1<= X <= x2) = F(x2) - F(x1)

Solutions

Expert Solution

I assume you are telling about generating multiple random numbers between 0 and 1 and calculating mean and standard deviation of them.

For that,in A1 cell, write '=RAND()' so that it generates a random number between 0 and 1. Now, you have to go to the right lower corner of the cell where the cursor will change itself to a '+' sign. Now, drag the cursor downwards to get as many number of random numbers you want. Suppose, you want 10000 random numbers. So, drag the cursor till A10000.

Now to get mean and standard deviation, go to some other cell and there you write =AVERAGE(A1:A10000) to get the expectation.

To get the standard deviation, go to another cell and write =STDEV.S(A1:A10000) to get the standard deviation. Note that, as it is a sample from Uniform(0,1) random variable of size 10000, we consider the standard deviation to be calculated from this sample and hence we have written STDEV.S

orchestra answered 11 months ago

Next > < Previous

Related Solutions

In Assembly Language Write a program that generates 10 random numbers (0~99). Save the numbers into...

In Assembly Language Write a program that generates 10 random numbers (0~99). Save the numbers into arrayInt and calculate the sum. .data arrayInt Byte 10 DUP(?) Displays the array and the sum as follows: The random numbers are: xx xx xx xx xx xx …. The sum is xxxx

Create a C++ program that generates a random number from 1 to 100 using the rand()...

Create a C++ program that generates a random number from 1 to 100 using the rand() function. Give the user a total 5 chances to guess the number. Stop the program and indicate the user guessed the correct number and should be applauded. Also, please find out which guess was the closest to the actual number. For example, if the rand() produces 57 and the user guessed 10, 80, 52, 33 and 44 in their respective turns then print out...

In Assembly Language MASM Write a program that generates 10 random numbers (0~99). Save the numbers...

In Assembly Language MASM Write a program that generates 10 random numbers (0~99). Save the numbers into arrayInt and calculate the sum. .data arrayInt Byte 10 DUP(?) Displays the array and the sum as follows: The random numbers are: xx xx xx xx xx xx …. The sum is xxxx

**java* Create an application that generates 20 random numbers between 1 and 100 and writes them...

****java*** Create an application that generates 20 random numbers between 1 and 100 and writes them to a text file on separate lines. Then the program should read the numbers from the file, calculate the average of the numbers, and display this to the screen.

Part 1: Using Excel’s Randbetween(0,9) function, generate 200 samples of five random numbers between 0 and...

Part 1: Using Excel’s Randbetween(0,9) function, generate 200 samples of five random numbers between 0 and 9, calculate the mean of each sample. Show me the list of the 200 means. Typically, they should look like: 4.8, 3.6, 4.4, 6.0, etc. Part 2: Using Excel, calculate the overall mean of the 200 sample means (the average of the averages). This should be around 4.5. Part 3: Using Excel, calculate the standard error of the mean (SEM) (i.e. the standard deviation of...

The formula =60*RAND() will output a random number between 0 and 60. This can be used...

The formula =60*RAND() will output a random number between 0 and 60. This can be used to simulate the time someone arrives at an airport between 1 and 2 p.m. If =60*RAND() returns the value 23.456 that would indicate a person arrived at about 1:23 p.m. (1:23:27 p.m. if you want to be fussy.) Set up two cells, each with =60*RAND() to model a situation where two people arrive at an airport between 1 and 2 p.m. Set up a...

Expectation 1 Compute ?(?) for the following random variable ? : ?=Number of tosses until getting...

Expectation 1 Compute ?(?) for the following random variable ? : ?=Number of tosses until getting 4 (including the last toss) by tossing a fair 10-sided die. ?(?)= ? ------------------------------------------------------------------------------------------- Expectation 2 Compute ?(?) for the following random variable ? : ?=Number of tosses until all 10 numbers are seen (including the last toss) by tossing a fair 10-sided die. To answer this, we will use induction and follow the steps below: Let ?(?)...

Create a program that generates random number between 0 and 50 and puts them into a...

Create a program that generates random number between 0 and 50 and puts them into a linked list. When it generates 49, instead of adding it to the list, it prints the list, freeing each node and then exits. Submit your .c file

1- Write a function f(n,a,b) that generates n random numbers # from Uniform(a,b) distribution and returns...

1- Write a function f(n,a,b) that generates n random numbers # from Uniform(a,b) distribution and returns their minimum. # Execute the function with n=100, a=1, b=9. 2- Replicate the function call f(100,1,9) 100 thousand times # and plot the empirical density of the minimum of 100 indep. Unif(1,9)'s 3-Use the sampling distribution from (b) to find 95% confidence # interval for the minimum of 100 independent Unif(1,9)'s. Please solve in R

create a python function (only) that generates 10 random numbers within a specific range. Every time...

create a python function (only) that generates 10 random numbers within a specific range. Every time a number is generated, it is appended to a list (you need to initialize a list). Then the function counts how many times a number is repeated in the created list (you can choose any number to count). The function returns the list, the number you have chosen and its count. --define the function here ---

Subjects