ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
@nilfheimsan /wykop.pl
COPY THOSE 2 COLUMNS
Error range100
COPY HERE VALUES ONLY
2
Here random numbers are generated each time anything is changed
Here are copied values from pregenerated randoms
SORT VALUES by actual
DIVIDE into Q1,Q2,Q3,Q4
Q1,Q2,Q3,Q4
3
Value nrRandom actual outcomesScale to 1-100Random error in rangePreview of pred
actual test scores
predicted scores
Actual testsPredicted test scores
Predicted scores cut to 0-100
Q1 actualQ1 predictedactualpredicted
4
10.058205405645.82054056429.3314988635.1520394236.3554297-44.13138821-7.7759585142.048318606-23.94384895-21.89553035015.5151772322.851306061Q115.5151772322.85130606
5
20.706731786770.67317867-2.3191484768.354030270.85570486-11.1335697459.722135123.351077258-5.319475481-1.96839822302Q241.4349329141.15801725
6
30.012019212541.201921254-0.54787169650.654049557382.4334982824.59617514107.02967345.17863684148.5610616953.7396985353.739698533Q364.6185662963.31862932
7
40.449737356244.9737356216.8501033361.8238389452.2728859716.2122301268.485116095.2545119684.4109179159.6654298839.6654298834Q489.7391985879.81027285
8
50.301914505830.1914505818.6952949948.8867455795.0022169644.63869554139.64091255.654304181-0.80228125244.8520229284.8520229285
9
60.690249335269.0249335227.9412204996.9661540135.3285212642.1908616277.519382895.7217625-36.92883509-31.2070725906
10
70.899472371189.94723711-41.0968645548.8503725598.862411041.45884119100.32125226.72684252226.3852067433.1120492633.112049267
11
80.347038540934.703854090.462383817435.1662379125.711800248.7715237674.483323968.5070478821.51458188410.0216297710.021629778
12
90.449692184644.969218462.66914088347.6383593466.034800070.751653203466.786453279.563181394-5.6765630493.8866183463.8866183469
13
100.061967689726.19676897234.1174464640.3142154394.73507842-32.339929262.3951492212.05157441-3.2820388048.7695356098.76953560910
14
110.477113378247.71133782-6.10881705541.602520775.7217625-36.92883509-31.2070725913.7062101417.4739133631.1801234931.1801234911
15
120.309508998830.950899885.83201653836.7829164224.07671548-49.34255433-25.2658388616.9135991345.6958669862.6094661162.6094661112
16
130.717119158371.711915832.71328851574.4252043555.3795006724.1941591479.5736598118.8913844135.2766389854.1680233954.1680233913
17
140.334691802433.46918024-15.269786418.199393836.72684252226.3852067433.1120492619.27057363-10.824317718.4462559218.44625592114
18
150.181971800718.19718007-24.14471539-5.94753531224.35116779-24.37786506-0.0266972722719.33083422-1.08507247918.2457617418.2457617415
19
160.869592862986.95928629-22.4057823964.553503969.63079954-27.7992464441.831553119.5113284816.8321856936.3435141736.3435141716
20
170.511608569651.16085696-29.4562358321.7046211383.82891047.54801972591.3769301221.2716214739.2478741760.5194956460.5194956417
21
180.955759137895.57591378-6.20050863189.3754051459.87904019-48.4406810711.4383591221.7995526634.3790020756.1785547356.1785547318
22
190.603429866760.34298667-12.1162512148.2267354679.886034739.29678226119.18281723.266247521.7949005745.0611480745.0611480719
23
200.999410565699.94105656-8.50135167991.4397048859.6002880716.1325619575.7328500224.07671548-49.34255433-25.26583886020
24
210.069681766686.968176668-19.18297399-12.2147973262.6248222547.98943913110.614261424.35116779-24.37786506-0.02669727227021
25
220.584666141258.4666141219.227622977.6942370245.93440419-29.753134516.1812696924.60950559-48.90834009-24.29883449022
26
230.795145123279.51451232-40.6171188638.8973934624.60950559-48.90834009-24.2988344924.9377216-25.44230225-0.5045806462023
27
240.322252221332.2252221340.2420115872.4672337142.86184475-15.447354427.4144903525.711800248.7715237674.4833239674.4833239624
28
250.524386669652.4386669618.7240241771.1626911258.9982912111.516538870.5148300126.17391082-37.88126773-11.707356910Q2 actualQ2 predicted
29
260.70019780870.0197808-5.31492951964.7048512867.8300234613.4862475881.3162710428.05735027-27.010683091.0466671821.04666718241.4349329141.158017251
30
270.712626418371.26264183-14.6278373556.6348044923.266247521.7949005745.0611480729.77734951-5.40279931924.3745501924.374550192
31
280.190027355119.0027355148.8802720667.8830075824.9377216-25.44230225-0.504580646231.22518577-7.09446945524.1307163124.130716313
32
290.746272579174.62725791-2.67667288871.950585032.048318606-23.94384895-21.8955303532.1817011-10.9408322621.2408688421.240868844
33
300.736187332473.6187332416.1811141989.7998474450.1241272139.6229407189.7470679233.21059649-28.665806244.5447902494.5447902495
34
310.450443854345.04438543-18.8952288726.1491565734.16682312-47.45834604-13.2915229334.16682312-47.45834604-13.2915229306
35
320.785270750778.5270750732.26254425110.789619354.8784602742.2226056697.1010659334.1807580922.3027897556.4835478456.483547847
36
330.62653159362.6531593-37.4123882525.2407710518.8913844135.2766389854.1680233935.3285212642.1908616277.5193828977.519382898
37
340.590541087559.05410875-15.3225205343.7315882221.2716214739.2478741760.5194956436.3554297-44.13138821-7.77595851409
38
350.231373695423.13736954-8.83068042914.3066891167.27463742-10.656066756.6185707238.2380009744.997165983.2351668783.2351668710
39
360.12993717412.993717444.9169197757.9106371770.75737694-31.6027793639.1545975938.45579851-22.3927899616.0630085516.0630085511
40
370.952361047595.23610475-17.0927527978.1433519571.1898896940.73433713111.924226838.6944395424.5746575263.2690970563.2690970512
41
380.403921835840.3921835826.9037535967.295937175.654304181-0.80228125244.85202292842.86184475-15.447354427.4144903527.4144903513
42
390.034349667623.4349667626.3107330419.74569980338.45579851-22.3927899616.0630085543.1440496-13.020724130.1233254930.1233254914
43
400.513100349151.310034912.43184443353.7418793419.27057363-10.824317718.44625592143.78711784-19.9866041723.8005136823.8005136815
44
410.662297655766.22976557-25.8107041440.4190614382.96829758-3.59305908779.375238545.93440419-29.753134516.1812696916.1812696916
45
420.962490461496.24904614-22.0408324674.2082136897.35364692-22.2192210975.1344258246.2207933211.2655873557.4863806757.4863806717
46
430.338912354933.8912354940.9152025174.80643867.6854343832.88436285100.569797247.2312550645.7141783492.945433492.945433418
47
440.385804538738.58045387-27.3851176211.1953362519.33083422-1.08507247918.2457617448.9119965917.8898962566.8018928466.8018928419
48
450.063218535776.321853577-18.29021394-11.9683603612.05157441-3.2820388048.76953560949.96192206-11.4533020438.5086200238.5086200220
49
460.943364987994.3364987911.3361035105.672602387.3610808-16.2757796171.0853011949.96534879-11.3623873238.6029614838.6029614821
50
470.710918295171.09182951-10.5637973460.5280321788.2423443928.98086366117.223208150.1241272139.6229407189.7470679289.7470679222
51
480.213699905121.3699905144.5739993865.94398999.563181394-5.6765630493.88661834650.70716275-40.862664919.8444978439.84449784323
52
490.540900321654.0900321625.5215824779.6116146219.5113284816.8321856936.3435141752.2728859716.2122301268.4851160968.4851160924
53
500.491962985449.1962985444.6765186993.8728172381.25279964-42.7046164338.5481832154.8784602742.2226056697.1010659397.10106593Q3 actualQ3 predicted
54
510.857591513185.7591513110.9955731396.7547244343.78711784-19.9866041723.8005136855.3795006724.1941591479.5736598179.5736598164.6185662963.318629321
55
520.126725318812.67253188-15.64516139-2.972629515.2545119684.4109179159.66542988355.6720367225.5230090381.1950457581.195045752
56
530.402472281340.2472281317.4898019557.7370300834.1807580922.3027897556.4835478456.9967495448.45020163105.44695121003
57
540.297151539529.7151539532.8732013762.5883553275.3130639623.6319841698.9450481258.59187972-41.9656929816.6261867316.626186734
58
550.339569847633.95698476-12.0242874421.9326973250.70716275-40.862664919.84449784358.68234661-35.5852141923.0971324123.097132415
59
560.459985725845.99857258-23.1193807122.8791918891.5791861442.98408588134.56327258.9982912111.516538870.5148300170.514830016
60
570.751795027175.17950271-25.0788473550.1006553692.60039896-35.9233940456.6770049259.6002880716.1325619575.7328500275.732850027
61
580.413136490341.31364903-15.9464298925.3672191355.6720367225.5230090381.1950457559.87904019-48.4406810711.4383591211.438359128
62
590.343418918134.34189181-33.374053780.967838022794.22531544-46.6031595247.6221559162.6248222547.98943913110.61426141009
63
600.441103192344.1103192335.6797169379.7900361696.817007127.89325744124.710264563.05620952-26.6722004336.3840090936.3840090910
64
610.717741817971.77418179-11.7267801560.0474016458.68234661-35.5852141923.0971324163.36452659-0.573636796262.790889862.790889811
65
620.566280863556.62808635-1.46543584655.162650547.2312550645.7141783492.945433463.97060525-30.5951822133.3754230433.3754230412
66
630.790157139379.0157139315.5381777694.553891688.5070478821.51458188410.0216297764.11229126-27.7602167536.3520745136.3520745113
67
640.346704315834.6704315834.2491268568.9195584321.7995526634.3790020756.1785547366.034800070.751653203466.7864532766.7864532714
68
650.93055413193.055413148.57414172141.629554891.93148751-20.538117371.3933702166.98180051-2.73116399564.2506365264.2506365215
69
660.580549903558.0549903536.0128268294.0678171666.98180051-2.73116399564.2506365267.27463742-10.656066756.6185707256.6185707216
70
670.583655013158.3655013131.303963489.6694647163.36452659-0.573636796262.790889867.6854343832.88436285100.569797210017
71
680.424338992742.43389927-24.1095847718.324314549.96534879-11.3623873238.6029614867.8300234613.4862475881.3162710481.3162710418
72
690.872889360987.288936093.95270438691.2416404738.2380009744.997165983.2351668769.158816329.19003969778.3488560178.3488560119
73
700.857037887985.70378879-37.9446638947.759124929.77734951-5.40279931924.3745501969.63079954-27.7992464441.831553141.831553120
74
710.987342962298.73429622-20.2528475178.4814487143.1440496-13.020724130.1233254970.75737694-31.6027793639.1545975939.1545975921
75
720.756008633175.60086331-27.532054148.0688092126.17391082-37.88126773-11.7073569170.85570486-11.1335697459.7221351259.7221351222
76
730.619873265861.98732658-5.92654130456.0607852763.05620952-26.6722004336.3840090971.1898896940.73433713111.924226810023
77
740.551040191255.1040191211.3812639966.4852831213.7062101417.4739133631.1801234971.82322238-2.91207111768.9111512668.9111512624
78
750.958481407695.84814076-14.1666821681.681458656.9967495448.45020163105.446951275.3130639623.6319841698.9450481298.94504812Q4 actualQ4 predicted
79
760.02561440182.5614401846.7775131749.3389533571.82322238-2.91207111768.9111512679.886034739.29678226119.18281710089.7391985879.810272851
80
770.526414967552.641496756.29087055858.9323673133.21059649-28.665806244.54479024980.62066784-7.64624939272.9744184572.974418452
81
780.204391175220.4391175232.4766981952.9158157116.9135991345.6958669862.6094661181.25279964-42.7046164338.5481832138.548183213
82
790.766317815376.63178153-24.3108140352.320967563.97060525-30.5951822133.3754230482.4334982824.59617514107.02967341004
83
800.845019412284.501941228.07676176192.5787029898.83470796-20.3683654478.4663425282.96829758-3.59305908779.375238579.37523855
84
810.620238356162.023835617.98120116370.0050367780.62066784-7.64624939272.9744184583.82891047.54801972591.3769301291.376930126
85
820.111296865411.1296865445.7596797956.8893663328.05735027-27.010683091.04666718285.16806433-22.5117317362.6563326162.656332617
86
830.373775482737.3775482730.122322567.4998707631.22518577-7.09446945524.1307163185.19243019-47.5850245937.607405637.60740568
87
840.892051014189.20510141-24.1829138765.0221875495.71434676-22.4486944473.2656523287.3610808-16.2757796171.0853011971.085301199
88
850.815528085181.5528085135.78020067117.333009248.9119965917.8898962566.8018928487.5931888318.8967919106.489980710010
89
860.622649135162.26491351-44.1863276218.0785858888.537320775.35732294793.8946437288.0954404949.16057473137.256015210011
90
870.871889056587.1889056530.6133923117.80229869.158816329.19003969778.3488560188.2423443928.98086366117.223208110012
91
880.618652491861.8652491842.729931104.595180285.16806433-22.5117317362.6563326188.537320775.35732294793.8946437293.8946437213
92
890.574784528157.47845281-35.6506595121.827793332.1817011-10.9408322621.2408688491.5791861442.98408588134.56327210014
93
900.926815330192.681533017.1334951399.8150281446.2207933211.2655873557.4863806791.93148751-20.538117371.3933702171.3933702115
94
910.722022164772.20221647-34.0397361138.162480363.351077258-5.319475481-1.96839822392.60039896-35.9233940456.6770049256.6770049216
95
920.698526264869.85262648-24.8412343745.011392194.64408303-11.8598160482.7842669994.22531544-46.6031595247.6221559147.6221559117
96
930.315426680631.5426680634.8127739566.3554420164.11229126-27.7602167536.3520745194.64408303-11.8598160482.7842669982.7842669918
97
940.584156021358.41560213-37.6215584920.7940436487.5931888318.8967919106.489980794.73507842-32.339929262.3951492262.3951492219
98
950.682973062468.2973062420.5853707988.8826770349.96192206-11.4533020438.5086200295.0022169644.63869554139.640912510020
99
960.700993448670.0993448645.89121234115.990557238.6944395424.5746575263.2690970595.71434676-22.4486944473.2656523273.2656523221
100
970.682878062368.28780623-3.84822221164.439584025.17863684148.5610616953.7396985396.817007127.89325744124.710264510022