Question 3 (2 points) The furction RANDO senerates a Random Vamber from 0 to 999

Question

Question 3 (2 points) The furction RANDO senerates a Random Vamber from 0 to 99999 in Excel IeI want to gemerate a Random Number from 0 to 99999 I would use the formula 10 t RAND Here is an Example from Excel Random Namber RANDO Random Namber 10 B2 10 Generated the Following Dats Random Number Random Number+10 0.728450245 0.399706458 0.813857423 0.173057994 0206797855 728450246 3.997064579 8.13887422S 1.730579941 2.057978547 The INT fusction in Excel Returas the Integer Portion of any Calculation in Excel For Example, INT (733)-7 and INT 2999999 2 IfI wanted my Randora Numbers to be between 1 and 10, I would use the FornulaINTO RANDO) 1 Here is an Example from Excel: Random Number RANDO INT(10 Random Number) 1 INT 10 B2) +1 Generated the Following Random Number INT0 Random Number) + 1 0 SS5359966 0.442589811 0.127301829 0,194434954 0.429890343 0.281663635 IfI was trying to Simulat betreen 0 and 100, this nould be the fornmula to use te the number of cars arriving at a Drive-In Restaurant and I said that it could be any whole number INT (0.RANDO)-0Nte RANDO will necer generate the Number 1, so 100 RANDO would naver be 100 to Simulate the sueber of cars aurin ing at a Drive-In Restaurast and I said that it could be any whole sumber IfI was trying between 1 and 100, I would use thia Sormula INT (100 *RANDO-1 IEI was tying to Simulate th sr of cars arriving at Drela Restaurast and I said that it could be any wbole number betwees 20 and 70, what would the formula need to be? INT . RANDO)- lflwas trying to Simalatethe O sade Ter peraturua Drn-In Restaurant ca a darm Jam ary, and I said that-t could be any hole wumber batueen 25 and +35, what would the formula need to be IEI was tryieg to Simulate the total cost of my ceder at a Drive-In Restaurant and it could be ay umber (to the nearest Cent) from 235 to 1035, what would the formula need to be? INT .RANDO . 100)/100)- Save

Explanation / Answer

(1)

Int((rand()*101/100*(50-20)) + 20

(2)

Int((rand()*101/100*(35-(-25)) -25

(3)

(round(rand()*100*(10.35-2.35),2) + 2.35

Example generation

lower limit upper limit formula 20 50 42 -25 35 33 2.35 10.35 7.21

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.