青箱-貢献度 アーカーシャ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.95%1,554,361
8
9
落ちていない最大貢献度11.58%1,389,497
10
11
12
13
14
y = a + b*x
15
a-0.08627383837
16
b8.386268838
17
18
19
どの行番号まで線形近似するか
20
行番号42
21
貢献度12.75%
22
23
24
25
26
27
28
29
30
データ数
線形近似に使わないデータ数
31
194210
32
33
貢献度割合母数青箱あり青箱なし確率回帰直線貢献度
34
0.75%4040.00%-2.34%90,000
35
2.25%3262618.75%10.24%270,000
36
3.75%1593112819.50%22.82%450,000
37
5.25%42012829230.48%35.40%630,000
38
6.75%50619131537.75%47.98%810,000
39
8.25%43025617459.53%60.56%990,000
40
9.75%2511925976.49%73.14%1,170,000
41
11.25%103921189.32%85.72%1,350,000
42
12.75%27270100.00%98.30%1,530,000
43
14.25%660100.00%110.88%1,710,000
44
15.75%110100.00%123.46%1,890,000
45
17.25%110100.00%136.04%2,070,000
46
18.75%000#DIV/0!148.62%2,250,000
47
20.25%000#DIV/0!161.19%2,430,000
48
21.75%000#DIV/0!173.77%2,610,000
49
23.25%000#DIV/0!186.35%2,790,000
50
24.75%000#DIV/0!198.93%2,970,000
51
26.25%000#DIV/0!211.51%3,150,000
52
27.75%000#DIV/0!224.09%3,330,000
53
29.25%000#DIV/0!236.67%3,510,000
54
30.75%000#DIV/0!249.25%3,690,000
55
32.25%000#DIV/0!261.83%3,870,000
56
33.75%000#DIV/0!274.41%4,050,000
57
35.25%000#DIV/0!286.99%4,230,000
58
36.75%000#DIV/0!299.57%4,410,000
59
38.25%000#DIV/0!312.15%4,590,000
60
39.75%000#DIV/0!324.73%4,770,000
61
41.25%000#DIV/0!337.31%4,950,000
62
42.75%000#DIV/0!349.89%5,130,000
63
44.25%000#DIV/0!362.47%5,310,000
64
45.75%000#DIV/0!375.04%5,490,000
65
47.25%000#DIV/0!387.62%5,670,000
66
48.75%000#DIV/0!400.20%5,850,000
67
50.25%000#DIV/0!412.78%6,030,000
68
51.75%000#DIV/0!425.36%6,210,000
69
53.25%000#DIV/0!437.94%6,390,000
70
54.75%000#DIV/0!450.52%6,570,000
71
56.25%000#DIV/0!463.10%6,750,000
72
57.75%000#DIV/0!475.68%6,930,000
73
59.25%000#DIV/0!488.26%7,110,000
74
60.75%000#DIV/0!500.84%7,290,000
75
62.25%000#DIV/0!513.42%7,470,000
76
63.75%000#DIV/0!526.00%7,650,000
77
65.25%000#DIV/0!538.58%7,830,000
78
66.75%000#DIV/0!551.16%8,010,000
79
68.25%000#DIV/0!563.74%8,190,000
80
69.75%000#DIV/0!576.31%8,370,000
81
71.25%000#DIV/0!588.89%8,550,000
82
72.75%000#DIV/0!601.47%8,730,000
83
74.25%000#DIV/0!614.05%8,910,000
84
75.75%000#DIV/0!626.63%9,090,000
85
77.25%000#DIV/0!639.21%9,270,000
86
78.75%000#DIV/0!651.79%9,450,000
87
80.25%000#DIV/0!664.37%9,630,000
88
81.75%000#DIV/0!676.95%9,810,000
89
83.25%000#DIV/0!689.53%9,990,000
90
84.75%000#DIV/0!702.11%10,170,000
91
86.25%000#DIV/0!714.69%10,350,000
92
87.75%000#DIV/0!727.27%10,530,000
93
89.25%000#DIV/0!739.85%10,710,000
94
90.75%000#DIV/0!752.43%10,890,000
95
92.25%000#DIV/0!765.01%11,070,000
96
93.75%000#DIV/0!777.59%11,250,000
97
95.25%000#DIV/0!790.16%11,430,000
98
96.75%000#DIV/0!802.74%11,610,000
99
98.25%000#DIV/0!815.32%11,790,000
100
99.75%000#DIV/0!827.90%11,970,000
Loading...