ÌâÄ¿ÄÚÈÝ
ΪÑо¿Ä³ÊмÒͥƽ¾ùÊÕÈëÓëÔÂÆ½¾ùÉú»îÖ§³öµÄ¹ØÏµ£¬¸ÃÊÐͳ¼Æµ÷²é¶ÓËæ»úµ÷²é10¸ö¼ÒÍ¥£¬µÃÊý¾ÝÈçÏ£º
¼ÒÍ¥±àºÅ | 1 | 2 | 3 | 4 | 5 |
xi£¨ÊÕÈ룩ǧԪ | 0.8 | 1.1 | 1.3 | 1.5 | 1.5 |
yi£¨Ö§³ö£©Ç§Ôª | 0.7 | 1.0 | 1.2 | 1.0 | 1.3 |
¼ÒÍ¥±àºÅ | 6 | 7 | 8 | 9 | 10 |
xi£¨ÊÕÈ룩ǧԪ | 1.8 | 2.0 | 2.2 | 2.4 | 2.8 |
yi£¨Ö§³ö£©Ç§Ôª | 1.5 | 1.3 | 1.7 | 2.0 | 2.5 |
£¨1£©ÅжϼÒͥƽ¾ùÊÕÈëÓëÔÂÆ½¾ùÉú»îÖ§³öÊÇ·ñÏà¹Ø£¿
£¨2£©Èô¶þÕßÏßÐÔÏà¹Ø£¬Ç󻨹éÖ±Ïß·½³Ì.
½âÎö£º¿ÉÓüÆËã»úExcelÈí¼þ×÷³öÉ¢µãͼ£¬¹Û²ì¶þÕßÊÇ·ñ³ÊÏßÐÔÕýÏà¹Ø.Èôy¶Ôx³ÊÏßÐÔÏà¹Ø¹ØÏµ£¬¿ÉÒÔÓÃÏßÐÔÏà¹ØµÄ·½·¨½â¾öÎÊÌ⣬¼´ÀûÓù«Ê½À´¼ÆËã»Ø¹éϵÊý.ÓÐʱΪÁË·½±ã³£ÖƱí¶ÔÓ¦Áгöxiyi£¬xi2£¬ÒÔÀûÓÚÇóºÍ.´Ó¶ø»ñµÃÏßÐԻع鷽³Ì.
£¨1£©ÓüÆËã»úExcelÈí¼þ×÷³öÉ¢µãͼ£¨ÈçÏÂͼ£©£¬¹Û²ì·¢ÏÖ¸÷¸öÊý¾Ý¶ÔÓ¦µÄµã¶¼ÔÚÒ»ÌõÖ±Ï߸½½ü£¬ËùÒÔ¶þÕß³ÊÏßÐÔÕýÏà¹Ø¹ØÏµ.
![]()
£¨2£©ÀûÓù«Ê½¿ÉÇóµÃ»Ø¹é·½³ÌΪy=0.813 6x-0.004 4.
ΪÑо¿Ä³ÊмÒͥƽ¾ùÊÕÈëÓëÔÂÆ½¾ùÉú»îÖ§³öµÄ¹ØÏµ£¬¸ÃÊÐͳ¼Æµ÷²é¶ÓËæ»úµ÷²é10¸ö¼ÒÍ¥£¬µÃÊý¾ÝÈçÏ£º
¼ÒÍ¥±àºÅ | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
xi£¨ÊÕÈ룩ǧԪ | 0.8 | 1.1 | 1.3 | 1.5 | 1.5 | 1.8 | 2.0 | 2.2 | 2.4 | 2.8 |
yi£¨Ö§³ö£©Ç§Ôª | 0.7 | 1.0 | 1.2 | 1.0 | 1.3 | 1.5 | 1.3 | 1.7 | 2.0 | 2.5 |
Ç󻨹éÖ±Ïß·½³Ì.
Ëæ×ÅÎÒ¹ú¾¼ÃµÄ¿ìËÙ·¢Õ¹£¬³ÇÏç¾ÓÃñµÄÉú»îˮƽ²»¶ÏÌá¸ß£¬ÎªÑо¿Ä³ÊмÒͥƽ¾ùÊÕÈëÓëÔÂÆ½¾ùÉú»îÖ§³ö
µÄ¹ØÏµ£¬¸ÃÊÐͳ¼Æ²¿ÃÅËæ»úµ÷²éÁË10¸ö¼ÒÍ¥£¬µÃÊý¾ÝÈçÏ£º
| ¼ÒÍ¥±àºÅ | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| xi£¨ÊÕÈ룩ǧԪ | 0.8 | 1.1 | 1.3 | 1.5 | 1.5 | 1.8 | 2.0 | 2.2 | 2.4 | 2.8 |
| yi£¨Ö§³ö£©Ç§Ôª | 0.7 | 1.0 | 1.2 | 1.0 | 1.3 | 1.5 | 1.3 | 1.7 | 2.0 | 2.5 |
£¨1£©ÅжϼÒͥƽ¾ùÊÕÈëÓëÔÂÆ½¾ùÉú»îÖ§³öÊÇ·ñÏà¹Ø£¿
£¨2£©Èô¶þÕßÏßÐÔÏà¹Ø£¬Ç󻨹éÖ±Ïß·½³Ì.
¼ÒÍ¥±àºÅ | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
xi(ÊÕÈë)ǧԪ | 0.8 | 1.1 | 1.3 | 1.5 | 1.5 | 1.8 | 2.0 | 2.2 | 2.4 | 2.8 |
yi(Ö§³ö)ǧԪ | 0.7 | 1.0 | 1.2 | 1.0 | 1.3 | 1.5 | 1.3 | 1.7 | 2.0 | 2.5 |
(1)ÅжϼÒÍ¥ÔÂÆ½¾ùÊÕÈëÓëÔÂÆ½¾ùÉú»îÖ§³öÊÇ·ñÏà¹Ø£¿
(2)Èô¶þÕßÏßÐÔÏà¹Ø£¬Ç󻨹éÖ±Ïß·½³Ì.