NatelEnergy / grafana-plotly-panel

Show plotly graph in grafana panel
MIT License
145 stars 58 forks source link

FeatureRequest: Grafana 7 - Transform / Reduce / Calculation -> Add statistic calculations like "Standard deviation" .... #105

Closed Bubbu17 closed 4 years ago

Bubbu17 commented 4 years ago

HEllo ,

I realy appreciate the new "Transform" feature section in Grafana 7 but i still miss Statistic functions in the section "Reduce" / " Calculate" like : Parameters

Population mean = μ = ( Σ Xi ) / N
Population standard deviation = σ = sqrt [ Σ ( Xi - μ )2 / N ]
Population variance = σ2 = Σ ( Xi - μ )2 / N
Variance of population proportion = σP2 = PQ / n
Standardized score = Z = (X - μ) / σ
Population correlation coefficient = ρ = [ 1 / N ] * Σ { [ (Xi - μX) / σx ] * [ (Yi - μY) / σy ] }

Statistics

Unless otherwise noted, these formulas assume simple random sampling.

Sample mean = x = ( Σ xi ) / n
Sample standard deviation = s = sqrt [ Σ ( xi - x )2 / ( n - 1 ) ]
Sample variance = s2 = Σ ( xi - x )2 / ( n - 1 )
Variance of sample proportion = sp2 = pq / (n - 1)
Pooled sample proportion = p = (p1 * n1 + p2 * n2) / (n1 + n2)
Pooled sample standard deviation = sp = sqrt [ (n1 - 1) * s12 + (n2 - 1) * s22 ] / (n1 + n2 - 2) ]
Sample correlation coefficient = r = [ 1 / (n - 1) ] * Σ { [ (xi - x) / sx ] * [ (yi - y) / sy ] }

image