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 third cell for the difference between the two times. Then generate a data table and pivot table to answer the question: What is the probability that the two people will arrive within ten minutes of each other? (Hint: Group the data into ten minute intervals once you have the Pivot Table.) Using excel please

Solutions

Expert Solution

Hereby i am attaching the excelsheet snapshot with data set of the following question

T 1	T2	T1 - T2
51.46269	35.99522	15.46747
23.28585	41.70374	18.41789
19.31619	12.18999	7.126193
30.59051	13.21523	17.37528
51.55914	51.16681	0.392322
22.78649	11.80149	10.985
38.36868	44.3643	5.995613
44.6639	56.26554	11.60164
33.5819	34.07576	0.493861
12.54439	42.43062	29.88623
15.64586	39.94793	24.30207
46.53937	7.825168	38.7142
4.694335	24.71859	20.02425
40.93788	44.72501	3.787138
40.28396	37.87331	2.410655
41.13632	53.13396	11.99764
7.3757	37.48234	30.10664
44.66185	23.87141	20.79044
5.678209	45.30949	39.63128
50.41049	45.72867	4.681823
48.47892	45.83276	2.646161
47.30645	33.84479	13.46166
17.69676	41.18352	23.48676
57.58823	4.252433	53.3358
6.23457	22.70804	16.47347
21.3841	52.70801	31.32392
8.145896	55.90411	47.75821
58.31042	11.88568	46.42474
31.49214	31.30052	0.191626
40.38328	3.368676	37.0146
28.6603	54.79702	26.13673
52.28867	30.34152	21.94716
36.96089	25.13298	11.82792
57.5714	26.99977	30.57163
56.48474	35.50724	20.9775
8.26686	28.50036	20.2335
35.00333	28.03206	6.971266
6.009836	25.77811	19.76828
12.67952	59.23034	46.55082
23.28385	54.44632	31.16247
31.7479	14.04238	17.70552
24.21248	47.11771	22.90523
8.202018	4.766496	3.435522
58.77266	15.38829	43.38437
18.7771	19.91173	1.134631
14.22106	45.26348	31.04242
10.98824	3.05703	7.93121
39.9501	1.723891	38.22621
46.58512	54.80474	8.219622
19.50125	4.332232	15.16902
48.11477	50.35204	2.237264
39.21601	40.48901	1.273001
44.82265	22.7553	22.06735
56.89728	24.4813	32.41597
22.07486	55.73727	33.66241
55.36229	27.69227	27.67002
35.16919	44.30771	9.138517
58.09802	56.60177	1.496242
13.17939	3.265482	9.91391
45.84577	47.46095	1.615178

I have generated a data table and pivot table

Now calculating probability that the two people will arrive within two minutes of each other = 20/60 = 1/3.

orchestra answered 1 year ago

Next > < Previous

Related Solutions

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)

A computer random number generator was used to generate 950 random digits from 0 to 9....

A computer random number generator was used to generate 950 random digits from 0 to 9. The observed frequencies of the digits are given in the table below. 0 1 2 3 4 5 6 7 8 9 88 82 97 84 87 87 95 93 90 147 Using a 0.05significance level, test the claim that all of the digits are equally likely. (a) Find the rejection region. Reject H0 if χ2> (b) Find the test statistic. (Round your final...

Assume that total output is determined by this formula: TOTAL OUTPUT = NUMBER OF WORKERS X...

Assume that total output is determined by this formula: TOTAL OUTPUT = NUMBER OF WORKERS X PRODUCTIVITY assume there are 100 workers and each worker produces $100 of output. QUESTION: If the workforce is growing by 1% a year but productivity does not improve, how fast can output increase? Remember, the number of workers grows by 1%. Productivity does not change. Also remember the percentage change formula which is: [(new value - original value) / original value] x 100 a1%...

A random number generator returns random floats between 0 and 1, according to a uniform distribution....

A random number generator returns random floats between 0 and 1, according to a uniform distribution. say you let the random number generator draw 100 numbers, the sample mean will be... A.impossible to determine, because the data aren't drawn from a normal distribution. B.normally distributed, with mean 0.5 and standard deviation 0.2887. C.uniformely distributed, between 0 and 1. D.normally distributed, with mean 0.5 and standard deviation 0.02887.

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

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...

Write a Python program which generates a random number between 0 and 24 inclusive and that...

Write a Python program which generates a random number between 0 and 24 inclusive and that print out: • the double of the random number if the random number is greater than 12, • the triple of the random number if it is equal to 12 • and the quadruple of the random number if it is less than 12

Collect the Data: Use a random number generator to generate 50 values between 0 and 1...

Collect the Data: Use a random number generator to generate 50 values between 0 and 1 (inclusive). Theoretical Distribution In words, X = The theoretical distribution of X is X ~ U(0, 1). In theory, based upon the distribution X ~ U(0, 1), find μ = __________ σ = __________ 1st quartile = __________ 3rd quartile = __________ median = __________ Construct a box plot of the data. Be sure to use a ruler to scale accurately and draw straight...

1. A random number generator claims to randomly choose real numbers between 0 and 3000. (a)...

1. A random number generator claims to randomly choose real numbers between 0 and 3000. (a) If this is true, what kind of distribution would the randomly chosen numbers have? (b) What would be the mean of this distribution? (c) What would be the standard deviation of this distribution? (d) Say we take a sample of 65 generated numbers and obtain a sample mean of 1552. What do we know about the sampling distribution of the sample mean and how...

The number 206265 can be used to convert between arcseconds (") and radians (1 radian =...

The number 206265 can be used to convert between arcseconds (") and radians (1 radian = 2062652"). This number, however, is also the conversion between an Astronomical Unit (AU) and a parsec (pc); 1 pc = 206265 AU. Please explain in detail, with a diagram, why these numbers are the same

Subjects