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

½Ð°Ý¦³¿ìªk¨Ï¥Îvba¨Ó§@½u©Ê¦^Âk¶Ü¡H

½Ð°Ý¦³¿ìªk¨Ï¥Îvba¨Ó§@½u©Ê¦^Âk¶Ü¡H

¦pªG§Ú¦³A¡BBÄæ¸ê®Æ

·Q­n¥h§@¤@½u©Ê¦^Âk¡A¦³¿ìªk¨Ï¥Îvba¿ì¨ì¶Ü¡H¡H½Ð¦U¦ì°ª¤âÄÀºÃ

¦pªG§Ú¦³A¡BBÄæ¸ê®Æ

·Q­n¥h§@¤@½u©Ê¦^Âk¡A¦³¿ìªk¨Ï¥Îvba¿ì¨ì¶Ü¡H¡H½Ð¦U¦ì°ª¤âÄÀºÃ
gkld µoªí©ó 2013-1-27 21:57


EXCEL¦³¦Û±a½u©Ê¦^Âk¤½¦¡LINEST
¦p¤U¹Ï,¦Û°Ê§ä¥X
A7©MB7
A7 ªº2 µ¥©óY=1+2Xªº 2
B7 ªº1 µ¥©óY=1+2Xªº 1
   
¯d·NLINEST¬O°}¦C¤½¦¡, ­n¿ï¤W¨â­Ó®æ,µM«á¿é¤½¦¡, ³Ì«á¤£­n¥u«öENTER,­n«öCTRL+SHIFT+ENTER
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

·PÁ ¼Ó¤W¦^ÂСK

§Ú¾å±oexcel¦³¦Û«Ø¨ç¼Æ¥\¯à¦³¡A¦ý¬O§Ú¦pªG­n¦bvba¸Ì­±¨Ï¥Î¡A©Î¬O§ä¥X¦^Âkªº¤èµ{¦¡

¤£ª¾¹D¸Ó«ç»ò¼g¥X¨Ó

TOP

§Ú¥Îappliction.linest¡A¥u¯à¶]¥X¤W¨Ò¤¤ªº 2­È¥X¨Ó

©Ò¥H¤~·|¦³¦¹¤@°Ý¡A¦p¦ó¥Îvba¼g¥X¨Ó¡A·PÁÂ~

TOP

§Ú¥Îappliction.linest¡A¥u¯à¶]¥X¤W¨Ò¤¤ªº 2­È¥X¨Ó

©Ò¥H¤~·|¦³¦¹¤@°Ý¡A¦p¦ó¥Îvba¼g¥X¨Ó¡A·PÁÂ~
gkld µoªí©ó 2013-1-28 00:27

¤ñ¸û³æ¯Â¤@ÂI´N¬O·Ó Kimbal ª©¤jªº¥Îªk:
  1. Sub Test()
  2.     [A8].Formula = "=ROUND(LINEST(B2:B5,A2:A5),0)"
  3.     [B8].Formula = "=ROUND(LINEST(A2:A5,B2:B5),0)"
  4. End Sub
½Æ»s¥N½X

TOP

¦^´_ 5# c_c_lai
c_c_lai¤j¡G
¤£¦n·N«ä¡K§Ú¬Ý¤£¤ÓÀ´§Aªº¸Ñµª
±zªº¸Ñµª
[A8].Formula = "=ROUND(LINEST(B2:B5,A2:A5),0)"
¥i¥H¨D¥X¦^Âk«áªº±×²v
¥i¬O
[B8].Formula = "=ROUND(LINEST(A2:A5,B2:B5),0)"
³o¦æµ{¦¡½X¡K¦n¹³ºâ¤£¥XºI¶Z¨Ó

¯à¤£¯à½Ð§A¦A«üÂI°g¬z¡H¡H·PÁ°Ú

TOP

¥»©«³Ì«á¥Ñ kimbal ©ó 2013-1-28 23:41 ½s¿è
·PÁ ¼Ó¤W¦^ÂСK

§Ú¾å±oexcel¦³¦Û«Ø¨ç¼Æ¥\¯à¦³¡A¦ý¬O§Ú¦pªG­n¦bvba¸Ì­±¨Ï¥Î¡A©Î¬O§ä¥X¦^Âkªº¤èµ{¦¡

¤£ ...
gkld µoªí©ó 2013-1-28 00:19

¤£¤Ó²M·¡§A·Q­nªº¬O¤°»ò, ¤p§Ì¸Õ¸Õ¦V´X­Ó¤è¦Vµª (¤p§Ì¥uÀ´²Î­p¾Ç¥Ö¤ò,¦p¦³¿ù»~½Ð¦h¦h¥]²[)

I. ¦pªG¬O·Q§ä¥X¤H¬Ýªº¤èµ{¦¡,¥i¥H¥Î¹Ïªíªº"ÁͶսu"¥\¯à

¨BÆJ1.¥ý«Ø­Ó¹Ïªí,µM«á¥kÀ»¥[¤WÁͶսu

¨BÆJ2. ²Ä1­¶,§Ú¥uÀ´²Ä1­Ó©M³o­Ó :D

¨BÆJ3.¥´¤Ä"Åã¥Ü¤½¦¡"

§¹¦¨, VBAªº¸Ü¥i¥H¥Î³o¥y§ä¥X¤½¦¡
ActiveChart.SeriesCollection(1).Trendlines(1).DataLabel.text


¥Î¦P¼Ë¤èªk,¥i¥H±o¥X2¦¸¤èµ{¤½¦¡


II. ¦pªG¬O·QEXCEL¦Û¤v§ä¥X­ÓXªºY­È (ª½½u¤èµ{)
¦pX¬O10ªº¸ÜY¬O¤°»ò
=FORECAST(10,A2:A6,B2:B6)  

Excel VBA
application.Worksheetfunction.Forecast(10,RANGE("B2:B5"),RANGE("A2:A5"))

¦pªG¤£¬Oª½½uªº¸Ü¥i¥H°Ñ¦Ò¤@¤U³o¸Ì:
http://www.statr.cn/?p=82

vba ¥u¬O§@»²§U¥Î³~,¯u¥¿ªº¥\¯à¬O¦bexcel¥»¨­
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

¦^´_ 7# kimbal
·PÁÂkimbalª©¤j¼ö¤ß¸Ñµª¡A§A»¡§AÀ´¥Ö¤ò¡A¤Ó«È®ð¤F
¥»¨Ó§Ú·Q»¡¥Îvba¥i¥H§ä¥X½u©Ê¦^Âk¤èµ{¦¡y=ax+bªºa(±×²v)¤Îc(ºI¶Z)­È¡A³o¼Ë´N¥i¥H¨D±o§Ú·Q­nªºy­È
¸gª©¤j³o¼Ëªº¸Ñ»¡
­ì¨Óforecast´N¥i¥H¸Ñ¨M§Úªº°ÝÃD¤F~
·PÁÂÁÂ!!:D

TOP

        ÀR«ä¦Û¦b : ¹ï¤÷¥À­nª¾®¦¡A·P®¦¡B³ø®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD