Sign In
Create Account
distributia gausiana in basic
Last Updated: Oct 25 2013 20:50, Started by
fasola_ionut
, Oct 25 2013 17:47
·
0
0
#1
Posted 25 October 2013 - 17:47
|
Salut tuturor.
Am nevoie de codul care implementeaza functia de distributie a lui Gauss care ia ca argumente media valorilor; o valoare si deviatia standard si returneaza valoarea functiei de dsitributie( aia cu 1 pe( deviatia ori radical din 2 pi) ori e la minus ( (x minus media) la patrat ) supra( doi ori deviatia la patrat) Pentru ca vreau sa o fac ca o functie speciala in Excel( excel are formula doar pentru deviatie ) am pus asta intr-un modul la un worksheet : Function gauss(value, mean, deviation) return ( 1/( deviation*math.Sqr( 2*3.141592) ))* 2.71828^((-(value- mean)^2)/(2*(deviation^2))); End Function Dar are erori. Edited by fasolaMembruAnonimut, 25 October 2013 - 17:47. |
Back to top
#2
Posted 25 October 2013 - 20:50
|
Function gauss(value, mean, deviation)
gauss = (1 / (deviation * Math.Sqr(2 * 3.141592))) * 2.71828 ^ ((-(value - mean) ^ 2) / (2 * (deviation ^ 2))) End Function |
Anunturi
Bun venit pe Forumul Softpedia!
▶ 0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users
-
- Change Theme
- English
- Mark Community Read
- Termene & conditii
- Confidentialitate
- Consimtamant
- Cookies
- Help
© 2001-2024 Softpedia. All rights reserved. Softpedia® and the Softpedia logo are registered trademarks of SoftNews Net SRL.
Ora implicita a Forumului Softpedia este ora standard a Romaniei (GMT+2). Mai multe informatii →
⚠ Postarile afisate pe Forumul Softpedia reprezinta o opinie subiectiva a membrilor care le-au publicat si nu a SoftNews Net SRL.