This thread has been locked.

If you have a related question, please click the "Ask a related question" button in the top right corner. The newly created question will be automatically linked to this question.

BQ76952: how to get the coefficient of temperature polynomial

Part Number: BQ76952

Hi,I use the excel get the two 4th order polynomial,first one is T°C = A4*(R4) + A3*(R3) + A2*(R2) + A1*R + A0 and another is R(Ω) = A4*(T4) + A3*(T3) + A2*(T2) + A1*T + A0 

1. As you can see,the first one is not so good,is something wrong

2.How can I get the Coeff a1~a5 and Coeff b1~b4.The excel is the thermistor data I use, can you help me caculate the  Coeff a1~a5 and Coeff b1~b4

T_R_table.xlsx