What Causes the Peculiar Patterns in My Random Sequence Plot?

Click For Summary
SUMMARY

The discussion centers on the peculiar patterns observed in a plot generated from 10,000 random numbers combined with varying wave heights. The user utilized the Excel function "=Rand()" to create random values between 0 and 1, which were then added to wave heights of 2, 1, 3, 4, and 5 feet in specific proportions. The resulting plot exhibited artistic characteristics, resembling diffraction patterns, prompting inquiries about the underlying causes. A suggestion was made to truncate the random numbers to enhance the visibility of the patterns, potentially linked to rounding errors in the data.

PREREQUISITES
  • Understanding of Excel functions, specifically "=Rand()"
  • Basic knowledge of data visualization techniques in Excel
  • Familiarity with wave height concepts and statistical distributions
  • Awareness of rounding errors and their impact on data representation
NEXT STEPS
  • Explore advanced Excel graphing techniques, including "100% stacked horizontal cone" charts
  • Research the effects of rounding and truncation on data visualization
  • Investigate the Moiré pattern phenomenon in graphical representations
  • Learn about generating and analyzing random sequences in statistical software
USEFUL FOR

Data analysts, Excel users, statisticians, and anyone interested in understanding the intricacies of data visualization and random number generation.

Nano-Passion
Messages
1,291
Reaction score
0
Absolutely Stunning Plot of a "Random" Sequence (Picture Included)--Need Explanation

So I created 10000 waves of varying heights, 50% of the waves were 2 feet, 30% 1 foot, 15% 3 feet, 4% 4 feet, and 1% 5 feet tall.

I generated 10000 "random" numbers with the statement "=Rand()" (this generates a random number in value [0,1], then I added each of the wave's height with each of its adjacent random number to randomize the data.

I plotted the noisy data and I got an interesting little smudge that looked very peculiar. So I tried a different type of graph "100% stacked horizontal cone" and I got the plot that is attached, that seems to have very artistic characteristics with some pseudo wave/diffraction patterns.See attached. Does anyone have an explanation for this?

Edit: Can't attach excel file for some reason, but its pretty straight forward to generate it yourself in excel.
 

Attachments

  • beautiful.jpg
    beautiful.jpg
    23.1 KB · Views: 489
Last edited:
Physics news on Phys.org


If it's the Moiré pattern to the right you're referring to, this is probably down to rounding in the data. Try truncating the numbers by one or two decimal places and see if it becomes more marked.
 

Similar threads

Undergrad Place pieces on a chessboard randomly until 2 are adjacent
  • · Replies 13 ·
Replies
13
Views
2K
Undergrad Central Limit Theorem and fitting data
  • · Replies 22 ·
Replies
22
Views
4K
Graduate Can random weights create a correlation between two sequences?
  • · Replies 2 ·
Replies
2
Views
2K
Undergrad A popular explanation of Bell's inequalities
  • · Replies 16 ·
Replies
16
Views
3K
High School Is Randomness in Quantum Mechanics Truly Non-Deterministic?
  • · Replies 88 ·
3
Replies
88
Views
10K
Statistics: Pattern present in dice data?
  • · Replies 8 ·
Replies
8
Views
2K
Undergrad What is the relationship between sample size and statistical relevance?
  • · Replies 4 ·
Replies
4
Views
3K
Undergrad What is the connection between classical uncertainty and quantum mechanics?
  • · Replies 3 ·
Replies
3
Views
2K
MATLAB MATLAB API For Wave Flume Data Analysis
  • · Replies 3 ·
Replies
3
Views
3K
High School Explanation of how spin art machine works
  • · Replies 4 ·
Replies
4
Views
6K