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.692571Excluded samples1
Samples in which its value matters are automatically excluded.
14
Average sanity per credit0.055771Evaluated samples1739
15
16
17
Sanity/credit: variance
0.000336
18
Sanity/credit: standard deviation
0.018317
19
20
Confidence interval (added Sep 22, 2020)
21
Confidence level95.00%
22
Sanity per credit: min0.054910
23
Sanity per credit: max0.056633
24
Interval width0.001723
25
Total value: min6.589189
26
Total value: max6.795953
27
28
29
Purchase statistics query (added Oct 5, 2020)
30
Column number (see "sorted")94
31
Item nameT1 Sugar
32
Quantityx2
33
Discount0%
34
Price100.00 FC
35
36
Higher incomeLower income
37
Total credits spent on offer2008.142857658.1428571
38
Total purchases20.086.58
39
Avg credits spent per sample1.1541050.378243
40
Avg purchases per sample0.0115410.003782
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