ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¦p¦ó§PÂ_¶g´Á°T¸¹?

¦^´_ 1# acdx
¨Ò¤l©Ç©Çªº ­Y©T©w©P´Á16.1¡A«h fm(1) À³¬° 46.9¡Ffm(0) À³¬° 30.8
³o¼Ë¨â­Ó³£¦³°¾®t³£­n±Æ°£?

TOP

¦^´_ 5# acdx
¥Î¦^Âkª½½uªº¤èªk±Æ°£®t²§¹L¤jªº­È¡A¬Ý¬Ý¬O§_¦³À°§U¡A
¶·ª`·N³o¸Ì¥Îªº¦^Âkª½½u¬O¥]§t°¾®t­Èªº¸ê®Æ©Ò±À¥Xªºª½½u¡A
©Ò¥HdeltaY­È½Ð¦Û¦æ·r°u
  1. Sub Test()
  2.     Dim d, fm
  3.     Dim a, b, it
  4.     Dim deltaY
  5.    
  6.     fm = Array(32.2, 44.3, 63, 79.1, 95.2, 111.3)
  7.     Set d = CreateObject("scripting.dictionary")
  8.     For i = 0 To UBound(fm)
  9.         d(i) = fm(i)
  10.     Next
  11.    
  12.     '¦^Âkª½½u  fm=ax+b
  13.     a = WorksheetFunction.Index(WorksheetFunction.LinEst(d.items, d.keys), 1)
  14.     b = WorksheetFunction.Index(WorksheetFunction.LinEst(d.items, d.keys), 2)
  15.    
  16.     deltaY = 1.5  '»P¦^Âk½uY¶b¤Wªº®e³\»~®t
  17.     For Each it In d.keys
  18.         '±Æ°£»~®t¹L¤jªº­È
  19.         If Abs((it * a + b) - d(it)) > deltaY Then d.Remove it
  20.     Next
  21.    
  22.     MsgBox Join(d.items, ",")
  23.     Set d = Nothing
  24. End Sub
½Æ»s¥N½X

TOP

        ÀR«ä¦Û¦b : ¥Í®ð¡A´N¬O®³§O¤Hªº¹L¿ù¨ÓÃg»@¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD