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

·Q½Ð°Ý¤£ª¾¹Dexcel¯à¤£¯à­pºâ¼Æ¦C¥æ¤eÂI»P¨¤«×°ÝÃD

·Q½Ð°Ý¤£ª¾¹Dexcel¯à¤£¯à­pºâ¼Æ¦C¥æ¤eÂI»P¨¤«×°ÝÃD

·Q½Ð°Ýexcel ¬O¤£¬O¯à­pºâ¥æ¤eÂI»P¨¤«×°ÝÃD ÁÂÁÂ

¨¤«×.PNG (46.51 KB)

¨¤«×.PNG

¦^´_ 1# gery


    «Øij¥ýÀÀ©w¼Æ¾Ç­pºâ¨BÆJ
¦p¥H¼Æ­È¤ÀªRªk¡A¥H¤U°Ñ¦Ò¡G
1. Excel ªº LINEST() ¨ç¼Æ§â¼Æ¦C°µ³Ì¤p¥­¤è¦^Âk¤èµ{¦¡
2. ¥H¦^Âk¤èµ{¦¡­pºâ¥æ¤eÂI (x,y)
3. ­pºâ¤Á½u±×²v¤èµ{¦¡,¥Ñ·L¤À¦^Âk¤èµ{¦¡
4. ¥æ¤eÂI (x,y) ¥N¤J¤Á½u±×²v¤èµ{¦¡­pºâ±×²v TAN(£c)

¥H°ÝÃD¤¤ªº¼Æ­È¨Ó¬Ý¡A¼Æ¦C®t­È 0.0xx ¬Û¹ï©ó x ªº ®t­È = 1¡A±×²v«Ü¤p

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¤£¤@©w²y²y¬O¦n²y¡A¦ý¬O¦³¾ú½mªº±j¥´ªÌ¡AÀH®É³£¥i¥H´§´Î¡C
ªð¦^¦Cªí ¤W¤@¥DÃD