Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Exercise 8: Random Numbers Part A: Construct the following simple spreadsheet. A B 1 0.52 =RAND() Each time the spreadsheet recalculates, a new random number

Exercise 8: Random Numbers

Part A:

Construct the following simple spreadsheet.

A B 1 0.52 =RAND()

Each time the spreadsheet recalculates, a new random number between 0 and 1 will appear in cell A2. (Hit F9, the recalculation key, to see for yourself.)

Modify the spreadsheet so that cell B2 says "higher" whenever the random number is greater than 0.5 and "lower" whenever the random number is less than 0.5.

Part B:

Construct the following simple spreadsheet.

A B 1 0.4 0.7 2 =RAND()

Modify this spreadsheet so that cell B2 says "higher" whenever the random number is greater than 0.7, "lower" whenever the random number is less than 0.4, and "in between" whenever the random number is between 0.4 and 0.7.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Ethical Obligations and Decision Making in Accounting Text and Cases

Authors: Steven M. Mintz, Roselyn E. Morris

5th edition

1259969460, 73403997, 1260480852, 978-1259969461

More Books

Students also viewed these Accounting questions

Question

1. To understand how to set goals in a communication process

Answered: 1 week ago