如题
下面是超级电容器的交流阻抗数据,怎么求等效串联电阻(ESR)

Init E (V) = 0
High Frequency (Hz) = 1e+5
Low Frequency (Hz) = 0.01
Amplitude (V) = 0.005
Quiet Time (sec) = 2
Cycles (.1-1Hz) = 1
Cycles (.01-.1Hz) = 1
Cycles (.001-.01Hz) = 1

Freq/Hz,   Z'/ohm,   Z"/ohm,   Z/ohm,   Phase/deg

9.668e+4, 1.590e+0, 4.173e-1, 1.643e+0, 14.7
8.105e+4, 1.588e+0, 3.309e-1, 1.622e+0, 11.8
6.641e+4, 1.623e+0, 2.218e-1, 1.638e+0, 7.8
5.469e+4, 1.634e+0, 1.438e-1, 1.640e+0, 5.0
4.590e+4, 1.673e+0, 1.197e-1, 1.677e+0, 4.1
3.711e+4, 1.686e+0, 6.806e-2, 1.687e+0, 2.3
3.125e+4, 1.714e+0, 2.152e-2, 1.714e+0, 0.7
2.539e+4, 1.714e+0, 5.355e-4, 1.714e+0, 0.0
2.148e+4, 1.740e+0, -9.084e-3, 1.740e+0, -0.3
1.758e+4, 1.772e+0, -3.588e-2, 1.773e+0, -1.2
1.465e+4, 1.777e+0, -4.461e-2, 1.777e+0, -1.4
1.172e+4, 1.798e+0, -4.809e-2, 1.798e+0, -1.5
9.668e+3, 1.809e+0, -6.275e-2, 1.810e+0, -2.0
8.105e+3, 1.823e+0, -6.430e-2, 1.824e+0, -2.0
6.641e+3, 1.840e+0, -8.078e-2, 1.842e+0, -2.5
5.469e+3, 1.853e+0, -7.912e-2, 1.855e+0, -2.4
4.590e+3, 1.872e+0, -8.497e-2, 1.874e+0, -2.6
3.711e+3, 1.875e+0, -9.121e-2, 1.877e+0, -2.8
3.125e+3, 1.897e+0, -9.135e-2, 1.900e+0, -2.8
2.539e+3, 1.908e+0, -8.861e-2, 1.910e+0, -2.7
2.148e+3, 1.920e+0, -9.215e-2, 1.922e+0, -2.7
1.758e+3, 1.929e+0, -9.555e-2, 1.932e+0, -2.8
1.465e+3, 1.948e+0, -9.504e-2, 1.951e+0, -2.8
1.172e+3, 1.962e+0, -9.093e-2, 1.964e+0, -2.7
9.668e+2, 1.971e+0, -8.171e-2, 1.973e+0, -2.4
8.105e+2, 1.981e+0, -7.601e-2, 1.982e+0, -2.2
6.641e+2, 1.993e+0, -8.511e-2, 1.995e+0, -2.4
5.469e+2, 2.002e+0, -7.894e-2, 2.003e+0, -2.3
4.590e+2, 2.016e+0, -8.247e-2, 2.018e+0, -2.3
3.711e+2, 2.015e+0, -8.602e-2, 2.017e+0, -2.4
3.125e+2, 2.035e+0, -8.649e-2, 2.037e+0, -2.4
2.539e+2, 2.041e+0, -8.206e-2, 2.043e+0, -2.3
2.148e+2, 2.050e+0, -8.511e-2, 2.052e+0, -2.4
1.758e+2, 2.057e+0, -9.070e-2, 2.059e+0, -2.5
1.465e+2, 2.073e+0, -9.111e-2, 2.075e+0, -2.5
1.172e+2, 2.084e+0, -9.026e-2, 2.086e+0, -2.5
9.766e+1, 2.083e+0, -7.732e-2, 2.084e+0, -2.1
8.138e+1, 2.091e+0, -9.425e-2, 2.093e+0, -2.6
6.975e+1, 2.101e+0, -9.887e-2, 2.104e+0, -2.7
5.744e+1, 2.111e+0, -1.034e-1, 2.114e+0, -2.8
4.650e+1, 2.124e+0, -9.770e-2, 2.126e+0, -2.6
3.756e+1, 2.135e+0, -1.054e-1, 2.138e+0, -2.8
3.150e+1, 2.147e+0, -1.130e-1, 2.150e+0, -3.0
2.570e+1, 2.159e+0, -1.213e-1, 2.163e+0, -3.2
2.123e+1, 2.172e+0, -1.298e-1, 2.176e+0, -3.4
1.744e+1, 2.187e+0, -1.389e-1, 2.191e+0, -3.6
1.436e+1, 2.203e+0, -1.487e-1, 2.208e+0, -3.9
1.191e+1, 2.219e+0, -1.595e-1, 2.225e+0, -4.1
9.766e+0, 2.237e+0, -1.643e-1, 2.243e+0, -4.2
8.071e+0, 2.255e+0, -1.768e-1, 2.262e+0, -4.5
6.643e+0, 2.278e+0, -1.899e-1, 2.285e+0, -4.8
5.486e+0, 2.300e+0, -2.043e-1, 2.309e+0, -5.1
4.542e+0, 2.325e+0, -2.077e-1, 2.335e+0, -5.1
3.742e+0, 2.354e+0, -2.262e-1, 2.365e+0, -5.5
3.090e+0, 2.381e+0, -2.465e-1, 2.394e+0, -5.9
2.550e+0, 2.417e+0, -2.674e-1, 2.432e+0, -6.3
2.105e+0, 2.448e+0, -2.906e-1, 2.465e+0, -6.8
1.738e+0, 2.507e+0, -3.107e-1, 2.526e+0, -7.1
1.434e+0, 2.542e+0, -3.394e-1, 2.565e+0, -7.6
1.184e+0, 2.582e+0, -3.683e-1, 2.608e+0, -8.1
9.766e-1, 2.621e+0, -4.023e-1, 2.652e+0, -8.7
8.071e-1, 2.661e+0, -4.417e-1, 2.697e+0, -9.4
6.643e-1, 2.704e+0, -4.865e-1, 2.747e+0, -10.2
5.486e-1, 2.749e+0, -5.374e-1, 2.801e+0, -11.1
4.542e-1, 2.803e+0, -5.903e-1, 2.865e+0, -11.9
3.742e-1, 2.889e+0, -6.655e-1, 2.964e+0, -13.0
3.090e-1, 2.944e+0, -7.442e-1, 3.036e+0, -14.2
2.550e-1, 3.001e+0, -8.359e-1, 3.115e+0, -15.6
2.105e-1, 3.060e+0, -9.418e-1, 3.202e+0, -17.1
1.738e-1, 3.130e+0, -1.066e+0, 3.306e+0, -18.8
1.434e-1, 3.203e+0, -1.209e+0, 3.424e+0, -20.7
1.184e-1, 3.284e+0, -1.376e+0, 3.561e+0, -22.7
9.766e-2, 3.375e+0, -1.567e+0, 3.721e+0, -24.9
8.071e-2, 3.474e+0, -1.788e+0, 3.907e+0, -27.2
6.643e-2, 3.585e+0, -2.048e+0, 4.129e+0, -29.7
5.486e-2, 3.713e+0, -2.341e+0, 4.389e+0, -32.2
4.542e-2, 3.858e+0, -2.665e+0, 4.689e+0, -34.6
3.742e-2, 4.017e+0, -3.061e+0, 5.051e+0, -37.3
3.090e-2, 4.199e+0, -3.512e+0, 5.474e+0, -39.9
2.550e-2, 4.405e+0, -4.034e+0, 5.973e+0, -42.5
2.105e-2, 4.639e+0, -4.636e+0, 6.558e+0, -45.0
1.738e-2, 4.913e+0, -5.344e+0, 7.259e+0, -47.4
1.434e-2, 5.221e+0, -6.176e+0, 8.087e+0, -49.8
1.184e-2, 5.577e+0, -7.151e+0, 9.069e+0, -52.0 返回小木虫查看更多