noise curve in excel

[spanikakamuni]

Hello,
I am very new to excel.
I want to create a noise curve with a crest factor of 5 using excel. My frequency(1/T) range is 100khertz to 220Mhertz.
i normally used Norm.inv(RAND(),0,1) to make some random voltages for my curve.
but now i am asked to consider a crest factor of 5 for each voltage point i make on my curve. I am really confused. how can i make it work.
thanking you,
spanika kamuni

 

[spanikakamuni]

hello,
i made my voltages with crest factor 5 according to the logic you have suggested and just copied the random numbers when i could have 5 in my crest factor column.
now my problém is with the frequency ranges. my graph Looks good when i use 1-20,000 samples. but I have to replace These samples with freq range I want. I cannot use so many frequencies since it is too fast for my op amp to take in.
so i took freq in 100k to 220M hertz range with a step of 2000000 and applied the same logic for voltages. but when i look at my graph, i have nice curve initallz and later only a straight line.
can you suggest me a method so that i could have nice curves spread over my freq range.

this is what i did.

freq time1 noise1 time2 noise2
1.00E+05 4.54339E-09 -0.238997809 4.54339E-09 0.089260054
2.10E+06 4.58505E-09 -3.585014652 4.58505E-09 -0.96403984
4.10E+06 4.62749E-09 1.220918844 4.62749E-09 1.478445711
6.10E+06 4.67071E-09 0.265573015 4.67071E-09 1.428109513
8.10E+06 4.71476E-09 0.66814129 4.71476E-09 -0.60873887
1.01E+07 4.75964E-09 0.648012851 4.75964E-09 0.237798714
1.21E+07 4.80538E-09 -1.375196801 4.80538E-09 -1.999509276
1.41E+07 4.85201E-09 0.001185614 4.85201E-09 0.030271467
1.61E+07 4.89956E-09 -0.845067239 4.89956E-09 -3.889985642
1.81E+07 4.94805E-09 -3.748691069 4.94805E-09 0.103989676
2.01E+07 4.9975E-09 0.507804851 4.9975E-09 0.001007241
2.21E+07 5.04796E-09 -0.022260405 5.04796E-09 0.044125371
2.41E+07 5.09944E-09 -2.118665441 5.09944E-09 2.992534922
2.61E+07 5.15198E-09 0.425771399 5.15198E-09 -0.498406761
2.81E+07 5.20562E-09 -1.794638999 5.20562E-09 -0.318755706
3.01E+07 5.26039E-09 -4.403599938 5.26039E-09 1.993172069
3.21E+07 5.31632E-09 -0.039597838 5.31632E-09 0.208553668
3.41E+07 5.37346E-09 -0.567166999 5.37346E-09 -0.438536351
3.61E+07 5.43183E-09 1.060323158 5.43183E-09 0.893713033
3.81E+07 5.49149E-09 -0.160549696 5.49149E-09 0.04689058
4.01E+07 5.55247E-09 -1.765008934 5.55247E-09 -0.10268384
4.21E+07 5.61482E-09 -0.607528079 5.61482E-09 0.178301878
4.41E+07 5.67859E-09 -0.095268978 5.67859E-09 -0.255949457
4.61E+07 5.74383E-09 0.202329532 5.74383E-09 -0.04624944
4.81E+07 5.81058E-09 -0.017732079 5.81058E-09 -2.129126932
5.01E+07 5.87889E-09 3.49258074 5.87889E-09 -0.129484871
5.21E+07 5.94884E-09 -0.271257424 5.94884E-09 -2.185852006
5.41E+07 6.02047E-09 -6.167486992 6.02047E-09 0.388381157
5.61E+07 6.09385E-09 -0.271120797 6.09385E-09 -0.045352422
5.81E+07 6.16903E-09 -1.206446409 6.16903E-09 -1.571407066
6.01E+07 6.2461E-09 -0.053626488 6.2461E-09 -0.824272559
6.21E+07 6.32511E-09 0.012724209 6.32511E-09 0.124116136
6.41E+07 6.40615E-09 2.393866755 6.40615E-09 -0.080147588
6.61E+07 6.48929E-09 -2.818289016 6.48929E-09 -0.023871475

i made this table untill freq is 220 MEG herty.
i have one more doubt. if my samples are in large number then i see my crest factor appearing with great accuracy and large number of times when i Keep pressing F9 and my Peak and rms values are also in good range like 5... and 0.99 like that.
but when i reduce the number of samples and if i raise the power of my initial Signal to reach a crest factor of 5 i see Peak and rms values to be strange. so large numbers some times such as 60 -70. can you please explain on this.