👤
Answered

The RAND() function in excel models which of the following probability distributions?
a. Normal distribution with mean 0 and standard deviation 1
b. Uniform distribution with lower limit 0 and upper limit 1
c. Normal distribution with mean -1 and standard deviation 1
d. Uniform distribution with lower limit -1 and upper limit 1

Answer :

The RAND() function in excel models Uniform distribution with lower limit 0 and upper limit 1. Hence, the right option is the option B.

What is excel?

Microsoft's spreadsheet program Excel is a part of the Office family of products used for business purposes. Users can format, arrange, and compute data in a spreadsheet using Microsoft Excel.

Data analysts and other users can organize data using programs like Excel to make information easier to view as data is added or changed. In Excel, there are many boxes known as cells that are arranged in rows and columns. These cells contain data.

It is possible to use Excel with other Office applications because it is a component of the Microsoft Office and Office 365 suites. The spreadsheet application is accessible on the Windows, macOS, Android, and iOS operating systems.

Learn more about Excel

https://brainly.com/question/25863198

#SPJ4

Go Teaching: Other Questions