contestada

A random- number generator can be used to simulate the probability of a given atom decaying over a given time. For example, the formula "=RAND()" in an Excel spreadsheet returns a random number between 0 and 1; thus, for one radioactive atom and a time of one half-life, a number less than 0.5 means the atom decays and a number greater than 0.5 means it doesn’t.(b) Increase the number of atoms to 100 by placing suitable formulas in cells A1 to A100, B1 to B100, and B102. Perform 10 simulations, and record the number of atoms remaining each time. Are these results more realistic for radioactive decay? Explain.

Respuesta :

This formula returns 0 if A1 is < 0.5 (the atom decays) and 1 if A1 is > . First, place the formula “=RAND ()” in boxes A1 to A10 of an excel spread sheet.

What is spread sheet?

A spreadsheet is a computer program for organizing, calculating, and storing data in tabular form. Spreadsheets were created as digital counterparts to traditional paper accounting spreadsheets. The data entered into a table's cells is what the program uses to run. Each cell may include text, numeric data, or formula results that automatically calculate and display values based on the contents of neighboring cells. One such electronic document may also be referred to as a spreadsheet.

Users of spreadsheets can change any stored value and watch the changes in calculated values. This enables quick investigation of numerous scenarios without the need for manual recalculation, making the spreadsheet helpful for "what-if" study.

To learn more about spread sheet from the given link:

brainly.com/question/26919847

#SPJ4

Otras preguntas