this question is rather general but I am sure a specific answerer or at-least a theoretical answerer can be provided on it. The rand function is a random number generator that runs on a seemingly random algorithm, seemingly because given a sufficient number of iterations one can see a pattern develop, or at-least so I am told. Now my question is how large would the number of iterations have to be so this would become realized and perhaps in which cases in science would this become a problem? The context in which I am normally using this function in, is Excel. Thank you for any explanation, in depth explanations would also be appreciated.
2026-03-25 23:58:49.1774483129
The rand function/algorithm - when does it begin to develop a pattern?
52 Views Asked by Bumbble Comm https://math.techqa.club/user/bumbble-comm/detail At
1
There are 1 best solutions below
Related Questions in RANDOM
- Prove that central limit theorem Is applicable to a new sequence
- Generating random versions of cubic and quadratic curve
- Is product of random numbers still random?
- Can I generate a random number with the probability distribution of the area under any arbitrary function?
- Average distance from a line to a point
- When does two random measures coincide in distribution?
- Determine the maximum period of this potential random number generator, if possible
- Does a random variable come from a probability distribution or is it vice-versa?
- Expected number of operations until matrix contains no zeros.
- Mean and Variance of Random Sum of Random Variables
Related Questions in RANDOM-FUNCTIONS
- Given a uniformly sampled $x$ and $y$, are the distributions of $x \cdot x$ and $x \cdot y$ equivalent?
- Does MCMC method can be used to calculate the mean and variance of the distribution of random variable functions?
- $X,Y \sim Exp(1), X \perp Y$, joint density of $V = X, U = X/Y$
- Order Statistics and Functions of Random Variables
- Projections of uniformly distributed $\mathbb{R}^3$ unit vector have uniform distribution
- Sequence of Random Variables: Approximation to the probability of an event
- Linear combination of non-identically distributed, independent exponential random variables
- Will operations on a purely random function also be random?
- Integral with respect to random measure is measurable
- what are the characteristics of this random variable?
Trending Questions
- Induction on the number of equations
- How to convince a math teacher of this simple and obvious fact?
- Find $E[XY|Y+Z=1 ]$
- Refuting the Anti-Cantor Cranks
- What are imaginary numbers?
- Determine the adjoint of $\tilde Q(x)$ for $\tilde Q(x)u:=(Qu)(x)$ where $Q:U→L^2(Ω,ℝ^d$ is a Hilbert-Schmidt operator and $U$ is a Hilbert space
- Why does this innovative method of subtraction from a third grader always work?
- How do we know that the number $1$ is not equal to the number $-1$?
- What are the Implications of having VΩ as a model for a theory?
- Defining a Galois Field based on primitive element versus polynomial?
- Can't find the relationship between two columns of numbers. Please Help
- Is computer science a branch of mathematics?
- Is there a bijection of $\mathbb{R}^n$ with itself such that the forward map is connected but the inverse is not?
- Identification of a quadrilateral as a trapezoid, rectangle, or square
- Generator of inertia group in function field extension
Popular # Hahtags
second-order-logic
numerical-methods
puzzle
logic
probability
number-theory
winding-number
real-analysis
integration
calculus
complex-analysis
sequences-and-series
proof-writing
set-theory
functions
homotopy-theory
elementary-number-theory
ordinary-differential-equations
circles
derivatives
game-theory
definite-integrals
elementary-set-theory
limits
multivariable-calculus
geometry
algebraic-number-theory
proof-verification
partial-derivative
algebra-precalculus
Popular Questions
- What is the integral of 1/x?
- How many squares actually ARE in this picture? Is this a trick question with no right answer?
- Is a matrix multiplied with its transpose something special?
- What is the difference between independent and mutually exclusive events?
- Visually stunning math concepts which are easy to explain
- taylor series of $\ln(1+x)$?
- How to tell if a set of vectors spans a space?
- Calculus question taking derivative to find horizontal tangent line
- How to determine if a function is one-to-one?
- Determine if vectors are linearly independent
- What does it mean to have a determinant equal to zero?
- Is this Batman equation for real?
- How to find perpendicular vector to another vector?
- How to find mean and median from histogram
- How many sides does a circle have?
In Excel 2003 Microsoft attempted to use the Wichmann-Hill generator. Their implementation was incorrect. They tried to fix it in Excel 2007 and again they did not get it right.
The period of the generator, which is what you are asking about, has an unknown length.
I hope the newer versions are better, but I wouldn't bet on it.
You can read more detail in the paper "On the accuracy of statistical procedures In Microsoft Excel 2007," in Computational Statistics and Data Analysis, by McCullough (2008).