青箱-貢献度 アーカーシャHL
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
元の集計 →
https://docs.google.com/spreadsheets/d/1mJiGHYPecw26MK6otrXz86lnY79ZBAZxGwzIQ-u8lZ0/edit?usp=sharing
2
3
ヒストグラムとして青箱の数を積算
4
bin幅1.50%HP:1,200,000,000
5
6
7
100%になる貢献度割合12.97%1,556,768
8
9
落ちていない最大貢献度11.58%1,389,497
10
11
12
13
14
y = a + b*x
15
a-0.08635935091
16
b8.37396143
17
18
19
どの行番号まで線形近似するか
20
行番号42
21
貢献度12.75%
22
23
24
25
26
27
28
29
30
データ数
線形近似に使わないデータ数
31
19188
32
33
貢献度割合母数青箱あり青箱なし確率回帰直線貢献度
34
0.75%4040.00%-2.36%90,000
35
2.25%3262618.75%10.21%270,000
36
3.75%1593112819.50%22.77%450,000
37
5.25%42012829230.48%35.33%630,000
38
6.75%50218931337.65%47.89%810,000
39
8.25%41924817159.19%60.45%990,000
40
9.75%2471885976.11%73.01%1,170,000
41
11.25%103921189.32%85.57%1,350,000
42
12.75%24240100.00%98.13%1,530,000
43
14.25%550100.00%110.69%1,710,000
44
15.75%110100.00%123.25%1,890,000
45
17.25%000#DIV/0!135.81%2,070,000
46
18.75%000#DIV/0!148.38%2,250,000
47
20.25%000#DIV/0!160.94%2,430,000
48
21.75%000#DIV/0!173.50%2,610,000
49
23.25%000#DIV/0!186.06%2,790,000
50
24.75%000#DIV/0!198.62%2,970,000
51
26.25%000#DIV/0!211.18%3,150,000
52
27.75%000#DIV/0!223.74%3,330,000
53
29.25%000#DIV/0!236.30%3,510,000
54
30.75%000#DIV/0!248.86%3,690,000
55
32.25%000#DIV/0!261.42%3,870,000
56
33.75%000#DIV/0!273.99%4,050,000
57
35.25%000#DIV/0!286.55%4,230,000
58
36.75%000#DIV/0!299.11%4,410,000
59
38.25%000#DIV/0!311.67%4,590,000
60
39.75%000#DIV/0!324.23%4,770,000
61
41.25%000#DIV/0!336.79%4,950,000
62
42.75%000#DIV/0!349.35%5,130,000
63
44.25%000#DIV/0!361.91%5,310,000
64
45.75%000#DIV/0!374.47%5,490,000
65
47.25%000#DIV/0!387.03%5,670,000
66
48.75%000#DIV/0!399.59%5,850,000
67
50.25%000#DIV/0!412.16%6,030,000
68
51.75%000#DIV/0!424.72%6,210,000
69
53.25%000#DIV/0!437.28%6,390,000
70
54.75%000#DIV/0!449.84%6,570,000
71
56.25%000#DIV/0!462.40%6,750,000
72
57.75%000#DIV/0!474.96%6,930,000
73
59.25%000#DIV/0!487.52%7,110,000
74
60.75%000#DIV/0!500.08%7,290,000
75
62.25%000#DIV/0!512.64%7,470,000
76
63.75%000#DIV/0!525.20%7,650,000
77
65.25%000#DIV/0!537.77%7,830,000
78
66.75%000#DIV/0!550.33%8,010,000
79
68.25%000#DIV/0!562.89%8,190,000
80
69.75%000#DIV/0!575.45%8,370,000
81
71.25%000#DIV/0!588.01%8,550,000
82
72.75%000#DIV/0!600.57%8,730,000
83
74.25%000#DIV/0!613.13%8,910,000
84
75.75%000#DIV/0!625.69%9,090,000
85
77.25%000#DIV/0!638.25%9,270,000
86
78.75%000#DIV/0!650.81%9,450,000
87
80.25%000#DIV/0!663.37%9,630,000
88
81.75%000#DIV/0!675.94%9,810,000
89
83.25%000#DIV/0!688.50%9,990,000
90
84.75%000#DIV/0!701.06%10,170,000
91
86.25%000#DIV/0!713.62%10,350,000
92
87.75%000#DIV/0!726.18%10,530,000
93
89.25%000#DIV/0!738.74%10,710,000
94
90.75%000#DIV/0!751.30%10,890,000
95
92.25%000#DIV/0!763.86%11,070,000
96
93.75%000#DIV/0!776.42%11,250,000
97
95.25%000#DIV/0!788.98%11,430,000
98
96.75%000#DIV/0!801.54%11,610,000
99
98.25%000#DIV/0!814.11%11,790,000
100
99.75%000#DIV/0!826.67%11,970,000
Loading...