[TEMPLATE] SaaS Metric Normal Range Calculator
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
[TEMPLATE] SaaS Metric Normal Range Calculator
2
Created by Jason @ GrowthLook
3
4
HOW TO USE:1. Copy this template file to your own Google Drive account
2. Select the blue cell in the 'Data Import Sheet'
3. Click FILE > IMPORT, then select your data file, and choose "Replace data starting at selected cell"
4. Copy the data you wish to analyze, & paste in the VALUES ONLY (CTRL+SHIFT+V), starting at the orange cells below
5. Rejoice, as the template calculates your Normal Range, AND visualizes it for you in the attached chart!
5
6
7
8
Need help? Read the guide
9
10
Date[YOUR METRIC]
Normal Range Upper Bound
Median
Normal Range Lower Bound
Standard Deviation
105.69
11
Oct 2976228.69123.0017.31Median123.00
12
Oct 30112228.69123.0017.31
13
Oct 31115228.69123.0017.31GOOD228.69
14
Nov 1150228.69123.0017.31NORMAL123.00
15
Nov 2135228.69123.0017.31BAD17.31
16
Nov 3138228.69123.0017.31
17
Nov 4547228.69123.0017.31
18
Nov 5110228.69123.0017.31
19
Nov 6144228.69123.0017.31
20
Nov 7153228.69123.0017.31
21
Nov 8123228.69123.0017.31
22
Nov 990228.69123.0017.31
23
Nov 10106228.69123.0017.31
24
Nov 1192228.69123.0017.31
25
Nov 12117228.69123.0017.31
26
Nov 13129228.69123.0017.31
27
Nov 14138228.69123.0017.31
28
228.69123.0017.31
29
228.69123.0017.31
30
228.69123.0017.31
31
228.69123.0017.31
32
228.69123.0017.31
33
228.69123.0017.31
34
228.69123.0017.31
35
228.69123.0017.31
36
228.69123.0017.31
37
228.69123.0017.31
38
228.69123.0017.31
39
228.69123.0017.31
40
228.69123.0017.31
41
228.69123.0017.31
42
228.69123.0017.31
43
228.69123.0017.31
44
228.69123.0017.31
45
228.69123.0017.31
46
228.69123.0017.31
47
228.69123.0017.31
48
228.69123.0017.31
49
228.69123.0017.31
50
228.69123.0017.31
51
228.69123.0017.31
52
228.69123.0017.31
53
228.69123.0017.31
54
228.69123.0017.31
55
228.69123.0017.31
56
228.69123.0017.31
57
228.69123.0017.31
58
228.69123.0017.31
59
228.69123.0017.31
60
228.69123.0017.31
61
228.69123.0017.31
62
228.69123.0017.31
63
228.69123.0017.31
64
228.69123.0017.31
65
228.69123.0017.31
66
228.69123.0017.31
67
228.69123.0017.31
68
228.69123.0017.31
69
228.69123.0017.31
70
228.69123.0017.31
71
228.69123.0017.31
72
228.69123.0017.31
73
228.69123.0017.31
74
228.69123.0017.31
75
228.69123.0017.31
76
228.69123.0017.31
77
228.69123.0017.31
78
228.69123.0017.31
79
228.69123.0017.31
80
228.69123.0017.31
81
228.69123.0017.31
82
228.69123.0017.31
83
228.69123.0017.31
84
228.69123.0017.31
85
228.69123.0017.31
86
228.69123.0017.31
87
228.69123.0017.31
88
228.69123.0017.31
89
228.69123.0017.31
90
228.69123.0017.31
91
228.69123.0017.31
92
228.69123.0017.31
93
228.69123.0017.31
94
228.69123.0017.31
95
228.69123.0017.31
96
228.69123.0017.31
97
228.69123.0017.31
98
228.69123.0017.31
99
228.69123.0017.31
100
228.69123.0017.31
Loading...
 
 
 
Normal Range Calculator
[CHART] Normal Range
Data Import Sheet