可变单元格x =
x =
x =
y = x4-3x2+8x y = x2+1 y = 0.5x5-6x4+24.5x3-39x2+19.5x-1目标单元格y =1235.99999y =1y =-1
绘制XY散点图所需数据
x y
0-1
0.2 1.52656
0.4 1.97952
0.6 1.21328
0.8-0.10976
1-1.5
1.2-
2.62144
1.4-3.27248
1.6-3.36672
1.8-
2.91376
2-2
2.2-0.76944
2.40.59552
2.6 1.89328
2.8 2.92224
3 3.5
3.2 3.48256
3.4 2.78352
3.6 1.39328
3.8-0.60176
4-3
4.2-
5.46544
4.4-7.50848
4.6-8.46672
4.8-7.48576
5-3.5
求解一元方程没有根有多个根
5-6x4+24.5x3-39x2+19.5x-1所需数据