1. Use the RAND function and the Copy command to generate 100 random numbers. a. What fraction of the random numbers are smaller than 0.5? b. What fraction of the time is a random number less than 0.5 followed by a random number greater than 0.5? c. What fraction of the random numbers are larger than 0.8? d. Freeze these random numbers. However, insteadof pasting them over the original random numbers, paste them onto a new range. Then press the F9 recalculate key. The original random numbers should change, but the pasted copy should remainthe same

EBK JAVA PROGRAMMING
9th Edition
ISBN:9781337671385
Author:FARRELL
Publisher:FARRELL
Chapter13: File Input And Output
Section: Chapter Questions
Problem 6PE
icon
Related questions
Question

1. Use the RAND function and the Copy command to generate 100 random numbers. a. What fraction of the random numbers are smaller than 0.5? b. What fraction of the time is a random number less than 0.5 followed by a random number greater than 0.5? c. What fraction of the random numbers are larger than 0.8? d. Freeze these random numbers. However, instead
of pasting them over the original random numbers, paste them onto a new range. Then press the F9 recalculate key. The original random numbers should change, but the pasted copy should remain
the same

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Linux
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
EBK JAVA PROGRAMMING
EBK JAVA PROGRAMMING
Computer Science
ISBN:
9781337671385
Author:
FARRELL
Publisher:
CENGAGE LEARNING - CONSIGNMENT
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L