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

EXCEL¦b©T©wºI¶Z¤U­pºâ¦h¶µ¦¡­pºâµ²ªG

EXCEL¦b©T©wºI¶Z¤U­pºâ¦h¶µ¦¡­pºâµ²ªG

LINEST¤½¦¡¥i¥H­pºâ¦h¶µ¦¡y=ax3+bx2+cx+dªº  abcd¼Æ­È
·Q­n³]©w¬Y­Ó©T©wºI¶Z«á¤À§O­pºâabc¼Æ­È
¦ýlinest¤½¦¡¥u¯à³]­qºI¶Z¬O0©ÎªÌ¤£¬O0¤§¿ï¶µ¡A¤£ª¾¹D­n¥Î¤°»ò¤½¦¡¶i¦æºI¶Z³]©w¨Ã­pºâabc¼Æ­È¡C
m06o2~~~~

¦^´_ 1# m06o2
¦p¤U¹Ï1¥¼³]©wºI¶Z«ey = 0.3011x3 - 3.8781x2 + 13.912x - 7.5792
¹Ï2¬°³]©wºI¶Z100«á y = -0.9149x3 + 12.609x2 - 59.568x + 100
¬O§_¦³¿ìªk¦bexcel¬Y¤@®æ¥[¤JºI¶Z«á¦Û°Êºâ¥X -0.9149 ¸ò12.609


¹Ï1

¹Ï2

¹Ï3
m06o2~~~~

TOP

        ÀR«ä¦Û¦b : ¦³®É·í«äµL®É­W¡A¦n¤Ñ­n¿n«B¨Ó³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD