ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Enter 2 values for daily income. The spreadsheet calculates the value of the difference between the two.Max692.86
Data collection spreadsheet:
2
Min572.86https://docs.google.com/spreadsheets/d/1qrFs7kGdVdBlhiGqdFnIYrHydr-xJblRy4On7r2lNqk/edit?usp=sharing
3
Difference120.00
4
Source of sanity values:
5
Daily income 1Daily income 2https://docs.google.com/spreadsheets/d/12X0uBQaN7MuuMWWDTiUjIni_MOP015GnulggmBJgBaQ/edit?usp=sharing
6
573 FC693 FC
7
Explanation document:
8
To input your own values: File > Make a copyEdit yellow cells only.https://docs.google.com/document/d/1KNvLXeAWxPvbqqrU-F7oZvNNiS7IERY-Yf8sRcDL0mY/edit?usp=sharing
9
10
11
12
Credits120.00Total samples1740
The value of Recruitment Permits is difficult to determine.
13
Average total sanity value
6.696428Excluded samples1
Samples in which its value matters are automatically excluded.
14
Average sanity per credit0.055804Evaluated samples1739
15
16
17
Sanity/credit: variance
0.000335
18
Sanity/credit: standard deviation
0.018313
19
20
Confidence interval (added Sep 22, 2020)
21
Confidence level95.00%
22
Sanity per credit: min0.054942
23
Sanity per credit: max0.056665
24
Interval width0.001723
25
Total value: min6.593069
26
Total value: max6.799786
27
28
29
Purchase statistics query (added Oct 5, 2020)
30
Column number (see "sorted")94
31
Item nameT1 Device
32
Quantityx2
33
Discount0%
34
Price160.00 FC
35
36
Higher incomeLower income
37
Total credits spent on offer1504.571429471.1428571
38
Total purchases9.402.94
39
Avg credits spent per sample0.8646960.270772
40
Avg purchases per sample0.0054040.001692
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100