共17名,最后一名得1分,第一名得25分,中间用等差,用excle函数公式怎么设?

x=1, y=25
x=17, y=1
Step 1: Calculate the common difference (d)
d = (y(17) - y(1)) / (17 - 1) = (1 - 25) / 16 = -24 / 16 = -1.5
Step 2: Write the equation of the arithmetic sequence
y(x) = y(1) + (x - 1) * d
Step 3: Substitute the values for y(1) and d into the equation
y(x) = 25 + (x - 1) * (-1.5)
Step 4: Use the Excel formula to calculate the sequence values
=25+(B2-1)*(-1.5)