I need piecewise regression

M

misterno

Board Regular
Joined
Mar 16, 2009
Messages
79
I can do a regression but it seems like there are 2 slopes here and I do not know how to create 2 equations

I found some VBA codes in the forum for 3 slopes in a regression but I need 2 pieces here.

Thanks


[TABLE="width: 500, align: center"]
<tbody>[TR]
[TD][TABLE="width: 73"]
<tbody>[TR]
[TD]4.11[/TD]
[/TR]
[TR]
[TD]3.93[/TD]
[/TR]
[TR]
[TD]3.87[/TD]
[/TR]
[TR]
[TD]3.63[/TD]
[/TR]
[TR]
[TD]3.44[/TD]
[/TR]
[TR]
[TD]3.73[/TD]
[/TR]
[TR]
[TD]3.90[/TD]
[/TR]
[TR]
[TD]3.94[/TD]
[/TR]
[TR]
[TD]3.81[/TD]
[/TR]
[TR]
[TD]3.66[/TD]
[/TR]
[TR]
[TD]3.88[/TD]
[/TR]
[TR]
[TD]3.88[/TD]
[/TR]
[TR]
[TD]3.46[/TD]
[/TR]
[TR]
[TD]3.45[/TD]
[/TR]
[TR]
[TD]3.36[/TD]
[/TR]
[TR]
[TD]3.38[/TD]
[/TR]
[TR]
[TD]3.48[/TD]
[/TR]
[TR]
[TD]3.72[/TD]
[/TR]
[TR]
[TD]3.48[/TD]
[/TR]
[TR]
[TD]3.46[/TD]
[/TR]
[TR]
[TD]3.38[/TD]
[/TR]
[TR]
[TD]3.34[/TD]
[/TR]
[TR]
[TD]3.41[/TD]
[/TR]
[TR]
[TD]3.74[/TD]
[/TR]
[TR]
[TD]3.53[/TD]
[/TR]
[TR]
[TD]3.40[/TD]
[/TR]
[TR]
[TD]3.19[/TD]
[/TR]
[TR]
[TD]4.20[/TD]
[/TR]
[TR]
[TD]5.87[/TD]
[/TR]
[TR]
[TD]3.67[/TD]
[/TR]
[TR]
[TD]3.67[/TD]
[/TR]
[TR]
[TD]10.69[/TD]
[/TR]
[TR]
[TD]11.52[/TD]
[/TR]
[TR]
[TD]13.47[/TD]
[/TR]
[TR]
[TD]10.57[/TD]
[/TR]
[TR]
[TD]4.57[/TD]
[/TR]
[TR]
[TD]3.36[/TD]
[/TR]
[TR]
[TD]2.89[/TD]
[/TR]
[TR]
[TD]3.29[/TD]
[/TR]
[TR]
[TD]3.53[/TD]
[/TR]
[TR]
[TD]3.29[/TD]
[/TR]
[TR]
[TD]3.47[/TD]
[/TR]
[TR]
[TD]3.17[/TD]
[/TR]
[TR]
[TD]3.80[/TD]
[/TR]
[TR]
[TD]6.80[/TD]
[/TR]
[TR]
[TD]7.40[/TD]
[/TR]
[TR]
[TD]7.10[/TD]
[/TR]
[TR]
[TD]5.60[/TD]
[/TR]
[TR]
[TD]4.03[/TD]
[/TR]
[TR]
[TD]5.19[/TD]
[/TR]
[TR]
[TD]5.20[/TD]
[/TR]
[TR]
[TD]4.32[/TD]
[/TR]
[TR]
[TD]4.41[/TD]
[/TR]
[TR]
[TD]3.55[/TD]
[/TR]
[TR]
[TD]2.92[/TD]
[/TR]
[TR]
[TD]3.37[/TD]
[/TR]
[TR]
[TD]3.20[/TD]
[/TR]
[TR]
[TD]3.01[/TD]
[/TR]
[TR]
[TD]3.46[/TD]
[/TR]
[TR]
[TD]3.55[/TD]
[/TR]
[TR]
[TD]3.63[/TD]
[/TR]
[TR]
[TD]3.13[/TD]
[/TR]
[TR]
[TD]2.92[/TD]
[/TR]
[TR]
[TD]2.70[/TD]
[/TR]
[TR]
[TD]2.70[/TD]
[/TR]
[TR]
[TD]2.83[/TD]
[/TR]
[TR]
[TD]2.79[/TD]
[/TR]
[TR]
[TD]2.66[/TD]
[/TR]
[TR]
[TD]2.89[/TD]
[/TR]
[TR]
[TD]3.23[/TD]
[/TR]
[TR]
[TD]2.91[/TD]
[/TR]
[TR]
[TD]2.92[/TD]
[/TR]
[TR]
[TD]5.41[/TD]
[/TR]
[TR]
[TD]5.90[/TD]
[/TR]
[TR]
[TD]5.29[/TD]
[/TR]
[TR]
[TD]2.88[/TD]
[/TR]
[TR]
[TD]2.80[/TD]
[/TR]
[TR]
[TD]2.84[/TD]
[/TR]
[TR]
[TD]2.78[/TD]
[/TR]
[TR]
[TD]2.90[/TD]
[/TR]
[TR]
[TD]3.05[/TD]
[/TR]
[TR]
[TD]3.05[/TD]
[/TR]
[TR]
[TD]3.05[/TD]
[/TR]
[TR]
[TD]2.94[/TD]
[/TR]
[TR]
[TD]2.88[/TD]
[/TR]
[TR]
[TD]2.91[/TD]
[/TR]
[TR]
[TD]2.93[/TD]
[/TR]
[TR]
[TD]2.93[/TD]
[/TR]
[TR]
[TD]2.71[/TD]
[/TR]
[TR]
[TD]2.83[/TD]
[/TR]
[TR]
[TD]2.70[/TD]
[/TR]
[TR]
[TD]4.12[/TD]
[/TR]
[TR]
[TD]3.91[/TD]
[/TR]
[TR]
[TD]3.60[/TD]
[/TR]
[TR]
[TD]3.70[/TD]
[/TR]
[TR]
[TD]3.65[/TD]
[/TR]
[TR]
[TD]4.34[/TD]
[/TR]
[TR]
[TD]3.93[/TD]
[/TR]
[TR]
[TD]3.63[/TD]
[/TR]
[TR]
[TD]3.67[/TD]
[/TR]
[TR]
[TD]3.33[/TD]
[/TR]
[TR]
[TD]3.87[/TD]
[/TR]
[TR]
[TD]4.15[/TD]
[/TR]
[TR]
[TD]4.13[/TD]
[/TR]
[TR]
[TD]3.68[/TD]
[/TR]
[TR]
[TD]3.59[/TD]
[/TR]
[TR]
[TD]3.25[/TD]
[/TR]
[TR]
[TD]3.33[/TD]
[/TR]
[TR]
[TD]3.42[/TD]
[/TR]
[TR]
[TD]3.56[/TD]
[/TR]
[TR]
[TD]3.51[/TD]
[/TR]
[TR]
[TD]3.62[/TD]
[/TR]
[TR]
[TD]3.97[/TD]
[/TR]
[TR]
[TD]3.97[/TD]
[/TR]
[TR]
[TD]4.26[/TD]
[/TR]
[TR]
[TD]4.00[/TD]
[/TR]
[TR]
[TD]4.00[/TD]
[/TR]
[TR]
[TD]4.31[/TD]
[/TR]
[TR]
[TD]6.14[/TD]
[/TR]
[TR]
[TD]11.02[/TD]
[/TR]
[TR]
[TD]10.54[/TD]
[/TR]
[TR]
[TD]10.54[/TD]
[/TR]
[TR]
[TD]16.61[/TD]
[/TR]
[TR]
[TD]16.61[/TD]
[/TR]
[TR]
[TD]9.85[/TD]
[/TR]
[TR]
[TD]6.01[/TD]
[/TR]
[TR]
[TD]5.00[/TD]
[/TR]
[TR]
[TD]4.65[/TD]
[/TR]
[TR]
[TD]4.82[/TD]
[/TR]
[TR]
[TD]4.36[/TD]
[/TR]
[TR]
[TD]3.42[/TD]
[/TR]
[TR]
[TD]3.33[/TD]
[/TR]
[TR]
[TD]3.26[/TD]
[/TR]
[TR]
[TD]3.36[/TD]
[/TR]
[TR]
[TD]3.36[/TD]
[/TR]
[TR]
[TD]3.27[/TD]
[/TR]
[TR]
[TD]3.90[/TD]
[/TR]
[TR]
[TD]4.68[/TD]
[/TR]
[TR]
[TD]5.80[/TD]
[/TR]
[TR]
[TD]9.47[/TD]
[/TR]
[TR]
[TD]14.52[/TD]
[/TR]
[TR]
[TD]13.81[/TD]
[/TR]
[TR]
[TD]16.12[/TD]
[/TR]
[TR]
[TD]17.90[/TD]
[/TR]
[TR]
[TD]21.88[/TD]
[/TR]
[TR]
[TD]35.05[/TD]
[/TR]
[TR]
[TD]36.47[/TD]
[/TR]
[TR]
[TD]11.09[/TD]
[/TR]
[TR]
[TD]10.23[/TD]
[/TR]
[TR]
[TD]9.80[/TD]
[/TR]
[TR]
[TD]3.92[/TD]
[/TR]
[TR]
[TD]3.47[/TD]
[/TR]
[TR]
[TD]3.97[/TD]
[/TR]
[TR]
[TD]13.66[/TD]
[/TR]
[TR]
[TD]13.35[/TD]
[/TR]
[TR]
[TD]12.94[/TD]
[/TR]
[TR]
[TD]13.35[/TD]
[/TR]
[TR]
[TD]13.05[/TD]
[/TR]
[TR]
[TD]10.47[/TD]
[/TR]
[TR]
[TD]11.53[/TD]
[/TR]
[TR]
[TD]7.88[/TD]
[/TR]
[TR]
[TD]21.31[/TD]
[/TR]
[TR]
[TD]21.31[/TD]
[/TR]
[TR]
[TD]18.55[/TD]
[/TR]
[TR]
[TD]5.54[/TD]
[/TR]
[TR]
[TD]6.39[/TD]
[/TR]
[TR]
[TD]6.11[/TD]
[/TR]
[TR]
[TD]5.27[/TD]
[/TR]
[TR]
[TD]14.11[/TD]
[/TR]
[TR]
[TD]15.41[/TD]
[/TR]
[TR]
[TD]15.08[/TD]
[/TR]
[TR]
[TD]13.78[/TD]
[/TR]
[TR]
[TD]13.61[/TD]
[/TR]
[TR]
[TD]17.11[/TD]
[/TR]
[TR]
[TD]5.92[/TD]
[/TR]
[TR]
[TD]3.99[/TD]
[/TR]
[TR]
[TD]4.04[/TD]
[/TR]
[TR]
[TD]4.14[/TD]
[/TR]
[TR]
[TD]3.90[/TD]
[/TR]
[TR]
[TD]3.79[/TD]
[/TR]
[TR]
[TD]3.85[/TD]
[/TR]
[TR]
[TD]4.03[/TD]
[/TR]
[TR]
[TD]3.78[/TD]
[/TR]
[TR]
[TD]3.83[/TD]
[/TR]
[TR]
[TD]3.82[/TD]
[/TR]
[TR]
[TD]3.85[/TD]
[/TR]
[TR]
[TD]3.96[/TD]
[/TR]
[TR]
[TD]4.09[/TD]
[/TR]
[TR]
[TD]4.28[/TD]
[/TR]
[TR]
[TD]4.09[/TD]
[/TR]
[TR]
[TD]5.04[/TD]
[/TR]
[TR]
[TD]8.11[/TD]
[/TR]
[TR]
[TD]16.75[/TD]
[/TR]
[TR]
[TD]6.53[/TD]
[/TR]
[TR]
[TD]7.29[/TD]
[/TR]
[TR]
[TD]6.81[/TD]
[/TR]
[TR]
[TD]7.45[/TD]
[/TR]
[TR]
[TD]6.91[/TD]
[/TR]
[TR]
[TD]5.01[/TD]
[/TR]
[TR]
[TD]4.39[/TD]
[/TR]
[TR]
[TD]4.05[/TD]
[/TR]
[TR]
[TD]3.65[/TD]
[/TR]
[TR]
[TD]3.08[/TD]
[/TR]
[TR]
[TD]3.76[/TD]
[/TR]
[TR]
[TD]4.64[/TD]
[/TR]
[TR]
[TD]4.66[/TD]
[/TR]
[TR]
[TD]4.66[/TD]
[/TR]
[TR]
[TD]4.55[/TD]
[/TR]
[TR]
[TD]4.47[/TD]
[/TR]
[TR]
[TD]4.30[/TD]
[/TR]
[TR]
[TD]4.75[/TD]
[/TR]
[TR]
[TD]6.05[/TD]
[/TR]
[TR]
[TD]14.02[/TD]
[/TR]
[TR]
[TD]14.65[/TD]
[/TR]
[TR]
[TD]30.86[/TD]
[/TR]
[TR]
[TD]15.57[/TD]
[/TR]
[TR]
[TD]13.78[/TD]
[/TR]
[TR]
[TD]12.00[/TD]
[/TR]
[TR]
[TD]56.40[/TD]
[/TR]
[TR]
[TD]28.64[/TD]
[/TR]
[TR]
[TD]9.46[/TD]
[/TR]
[TR]
[TD]4.26[/TD]
[/TR]
[TR]
[TD]3.71[/TD]
[/TR]
[TR]
[TD]4.07[/TD]
[/TR]
[TR]
[TD]4.07[/TD]
[/TR]
[TR]
[TD]4.36[/TD]
[/TR]
[TR]
[TD]4.64[/TD]
[/TR]
[TR]
[TD]4.93[/TD]
[/TR]
[TR]
[TD]4.87[/TD]
[/TR]
[TR]
[TD]15.66[/TD]
[/TR]
[TR]
[TD]15.66[/TD]
[/TR]
[TR]
[TD]13.54[/TD]
[/TR]
[TR]
[TD]17.07[/TD]
[/TR]
[TR]
[TD]123.81[/TD]
[/TR]
[TR]
[TD]80.76[/TD]
[/TR]
[TR]
[TD]48.51[/TD]
[/TR]
[TR]
[TD]58.50[/TD]
[/TR]
[TR]
[TD]59.10[/TD]
[/TR]
[TR]
[TD]53.12[/TD]
[/TR]
[TR]
[TD]91.93[/TD]
[/TR]
[TR]
[TD]29.18[/TD]
[/TR]
[TR]
[TD]14.22[/TD]
[/TR]
[TR]
[TD]6.36[/TD]
[/TR]
[TR]
[TD]5.73[/TD]
[/TR]
[TR]
[TD]5.38[/TD]
[/TR]
[TR]
[TD]5.94[/TD]
[/TR]
[TR]
[TD]5.95[/TD]
[/TR]
[TR]
[TD]9.67[/TD]
[/TR]
[TR]
[TD]20.99[/TD]
[/TR]
[TR]
[TD]18.09[/TD]
[/TR]
[TR]
[TD]12.29[/TD]
[/TR]
[TR]
[TD]12.42[/TD]
[/TR]
[TR]
[TD]12.42[/TD]
[/TR]
[TR]
[TD]20.20[/TD]
[/TR]
[TR]
[TD]20.47[/TD]
[/TR]
[TR]
[TD]7.78[/TD]
[/TR]
[TR]
[TD]6.23[/TD]
[/TR]
[TR]
[TD]8.56[/TD]
[/TR]
[TR]
[TD]9.54[/TD]
[/TR]
[TR]
[TD]9.34[/TD]
[/TR]
[TR]
[TD]8.46[/TD]
[/TR]
[TR]
[TD]6.04[/TD]
[/TR]
[TR]
[TD]6.11[/TD]
[/TR]
[TR]
[TD]6.32[/TD]
[/TR]
[TR]
[TD]7.44[/TD]
[/TR]
[TR]
[TD]7.07[/TD]
[/TR]
[TR]
[TD]8.20[/TD]
[/TR]
[TR]
[TD]10.24[/TD]
[/TR]
[TR]
[TD]19.36[/TD]
[/TR]
[TR]
[TD]24.31[/TD]
[/TR]
[TR]
[TD]20.94[/TD]
[/TR]
[TR]
[TD]4.01[/TD]
[/TR]
[TR]
[TD]3.75[/TD]
[/TR]
[TR]
[TD]3.55[/TD]
[/TR]
[TR]
[TD]3.74[/TD]
[/TR]
[TR]
[TD]3.53[/TD]
[/TR]
[TR]
[TD]3.23[/TD]
[/TR]
[TR]
[TD]3.49[/TD]
[/TR]
[TR]
[TD]3.92[/TD]
[/TR]
[TR]
[TD]3.73[/TD]
[/TR]
[TR]
[TD]4.09[/TD]
[/TR]
[TR]
[TD]4.51[/TD]
[/TR]
[TR]
[TD]3.73[/TD]
[/TR]
[TR]
[TD]3.80[/TD]
[/TR]
[TR]
[TD]3.61[/TD]
[/TR]
[TR]
[TD]3.61[/TD]
[/TR]
[TR]
[TD]3.71[/TD]
[/TR]
[TR]
[TD]3.61[/TD]
[/TR]
[TR]
[TD]3.72[/TD]
[/TR]
[TR]
[TD]3.74[/TD]
[/TR]
[TR]
[TD]3.60[/TD]
[/TR]
[TR]
[TD]3.60[/TD]
[/TR]
[TR]
[TD]3.43[/TD]
[/TR]
[TR]
[TD]2.99[/TD]
[/TR]
[TR]
[TD]1.63[/TD]
[/TR]
[TR]
[TD]1.33[/TD]
[/TR]
[TR]
[TD]1.57[/TD]
[/TR]
[TR]
[TD]1.51[/TD]
[/TR]
[TR]
[TD]1.47[/TD]
[/TR]
[TR]
[TD]1.61[/TD]
[/TR]
[TR]
[TD]3.47[/TD]
[/TR]
[TR]
[TD]3.44[/TD]
[/TR]
[TR]
[TD]3.14[/TD]
[/TR]
[TR]
[TD]3.14[/TD]
[/TR]
[TR]
[TD]3.31[/TD]
[/TR]
[TR]
[TD]2.66[/TD]
[/TR]
[TR]
[TD]3.24[/TD]
[/TR]
[TR]
[TD]10.04[/TD]
[/TR]
[TR]
[TD]18.92[/TD]
[/TR]
[TR]
[TD]14.30[/TD]
[/TR]
[TR]
[TD]8.98[/TD]
[/TR]
[TR]
[TD]11.74[/TD]
[/TR]
[TR]
[TD]10.80[/TD]
[/TR]
[TR]
[TD]9.76[/TD]
[/TR]
[TR]
[TD]3.57[/TD]
[/TR]
[TR]
[TD]5.00[/TD]
[/TR]
[TR]
[TD]4.66[/TD]
[/TR]
[TR]
[TD]6.55[/TD]
[/TR]
[TR]
[TD]5.74[/TD]
[/TR]
[TR]
[TD]5.15[/TD]
[/TR]
[TR]
[TD]4.79[/TD]
[/TR]
[TR]
[TD]4.85[/TD]
[/TR]
[TR]
[TD]3.35[/TD]
[/TR]
[TR]
[TD]3.27[/TD]
[/TR]
[TR]
[TD]3.26[/TD]
[/TR]
[TR]
[TD]8.63[/TD]
[/TR]
[TR]
[TD]8.22[/TD]
[/TR]
[TR]
[TD]9.44[/TD]
[/TR]
[TR]
[TD]12.34[/TD]
[/TR]
[TR]
[TD]9.98[/TD]
[/TR]
[TR]
[TD]3.64[/TD]
[/TR]
[TR]
[TD]7.71[/TD]
[/TR]
[TR]
[TD]8.57[/TD]
[/TR]
[TR]
[TD]15.14[/TD]
[/TR]
[TR]
[TD]15.14[/TD]
[/TR]
[TR]
[TD]8.91[/TD]
[/TR]
[TR]
[TD]3.78[/TD]
[/TR]
[TR]
[TD]13.21[/TD]
[/TR]
[TR]
[TD]6.00[/TD]
[/TR]
[TR]
[TD]3.51[/TD]
[/TR]
[TR]
[TD]3.27[/TD]
[/TR]
[TR]
[TD]3.59[/TD]
[/TR]
[TR]
[TD]7.34[/TD]
[/TR]
[TR]
[TD]11.39[/TD]
[/TR]
[TR]
[TD]15.24[/TD]
[/TR]
[TR]
[TD]20.00[/TD]
[/TR]
[TR]
[TD]16.83[/TD]
[/TR]
[TR]
[TD]18.39[/TD]
[/TR]
[TR]
[TD]19.26[/TD]
[/TR]
[TR]
[TD]17.35[/TD]
[/TR]
[TR]
[TD]37.08[/TD]
[/TR]
[TR]
[TD]36.35[/TD]
[/TR]
[TR]
[TD]24.06[/TD]
[/TR]
[TR]
[TD]21.78[/TD]
[/TR]
[TR]
[TD]17.46[/TD]
[/TR]
[TR]
[TD]20.91[/TD]
[/TR]
[TR]
[TD]22.93[/TD]
[/TR]
[TR]
[TD]13.72[/TD]
[/TR]
[TR]
[TD]22.97[/TD]
[/TR]
[TR]
[TD]16.01[/TD]
[/TR]
[TR]
[TD]16.68[/TD]
[/TR]
[TR]
[TD]2.11[/TD]
[/TR]
[TR]
[TD]2.03[/TD]
[/TR]
[TR]
[TD]2.19[/TD]
[/TR]
[TR]
[TD]2.10[/TD]
[/TR]
[TR]
[TD]1.88[/TD]
[/TR]
[TR]
[TD]1.91[/TD]
[/TR]
[TR]
[TD]1.91[/TD]
[/TR]
[TR]
[TD]2.06[/TD]
[/TR]
[TR]
[TD]2.01[/TD]
[/TR]
[TR]
[TD]1.74[/TD]
[/TR]
[TR]
[TD]1.35[/TD]
[/TR]
[TR]
[TD]0.95[/TD]
[/TR]
[TR]
[TD]0.88[/TD]
[/TR]
[TR]
[TD]0.88[/TD]
[/TR]
[TR]
[TD]1.39[/TD]
[/TR]
[TR]
[TD]1.71[/TD]
[/TR]
[TR]
[TD]1.48[/TD]
[/TR]
[TR]
[TD]1.09[/TD]
[/TR]
[TR]
[TD]2.12[/TD]
[/TR]
[TR]
[TD]2.15[/TD]
[/TR]
[TR]
[TD]1.94[/TD]
[/TR]
[TR]
[TD]1.54[/TD]
[/TR]
[TR]
[TD]0.96[/TD]
[/TR]
[TR]
[TD]0.98[/TD]
[/TR]
[TR]
[TD]0.77[/TD]
[/TR]
[TR]
[TD]0.88[/TD]
[/TR]
[TR]
[TD]0.89[/TD]
[/TR]
[TR]
[TD]1.07[/TD]
[/TR]
[TR]
[TD]1.99[/TD]
[/TR]
[TR]
[TD]1.97[/TD]
[/TR]
[TR]
[TD]2.09[/TD]
[/TR]
[TR]
[TD]2.83[/TD]
[/TR]
[TR]
[TD]2.90[/TD]
[/TR]
[TR]
[TD]2.86[/TD]
[/TR]
[TR]
[TD]3.24[/TD]
[/TR]
[TR]
[TD]7.05[/TD]
[/TR]
[TR]
[TD]3.86[/TD]
[/TR]
[TR]
[TD]3.03[/TD]
[/TR]
[TR]
[TD]2.61[/TD]
[/TR]
[TR]
[TD]3.13[/TD]
[/TR]
[TR]
[TD]2.80[/TD]
[/TR]
[TR]
[TD]3.80[/TD]
[/TR]
[TR]
[TD]4.44[/TD]
[/TR]
[TR]
[TD]7.17[/TD]
[/TR]
[TR]
[TD]2.85[/TD]
[/TR]
[TR]
[TD]2.17[/TD]
[/TR]
[TR]
[TD]5.47[/TD]
[/TR]
[TR]
[TD]6.43[/TD]
[/TR]
[TR]
[TD]7.17[/TD]
[/TR]
[TR]
[TD]7.32[/TD]
[/TR]
[TR]
[TD]3.99[/TD]
[/TR]
[TR]
[TD]3.58[/TD]
[/TR]
[TR]
[TD]3.45[/TD]
[/TR]
[TR]
[TD]3.94[/TD]
[/TR]
[TR]
[TD]3.94[/TD]
[/TR]
[TR]
[TD]3.90[/TD]
[/TR]
[TR]
[TD]2.67[/TD]
[/TR]
[TR]
[TD]2.54[/TD]
[/TR]
[TR]
[TD]2.43[/TD]
[/TR]
[TR]
[TD]2.31[/TD]
[/TR]
[TR]
[TD]2.34[/TD]
[/TR]
[TR]
[TD]2.10[/TD]
[/TR]
[TR]
[TD]2.29[/TD]
[/TR]
[TR]
[TD]2.08[/TD]
[/TR]
[TR]
[TD]1.60[/TD]
[/TR]
[TR]
[TD]1.79[/TD]
[/TR]
[TR]
[TD]2.07[/TD]
[/TR]
[TR]
[TD]2.20[/TD]
[/TR]
[TR]
[TD]2.13[/TD]
[/TR]
[TR]
[TD]2.10[/TD]
[/TR]
[TR]
[TD]2.83[/TD]
[/TR]
[TR]
[TD]3.46[/TD]
[/TR]
[TR]
[TD]5.76[/TD]
[/TR]
[TR]
[TD]5.41[/TD]
[/TR]
[TR]
[TD]9.14[/TD]
[/TR]
[TR]
[TD]9.68[/TD]
[/TR]
[TR]
[TD]8.52[/TD]
[/TR]
[TR]
[TD]6.56[/TD]
[/TR]
[TR]
[TD]1.96[/TD]
[/TR]
[TR]
[TD]2.12[/TD]
[/TR]
[TR]
[TD]1.98[/TD]
[/TR]
[TR]
[TD]1.66[/TD]
[/TR]
[TR]
[TD]1.73[/TD]
[/TR]
[TR]
[TD]1.83[/TD]
[/TR]
[TR]
[TD]3.11[/TD]
[/TR]
[TR]
[TD]1.71[/TD]
[/TR]
[TR]
[TD]1.78[/TD]
[/TR]
[TR]
[TD]1.90[/TD]
[/TR]
[TR]
[TD]1.32[/TD]
[/TR]
[TR]
[TD]1.07[/TD]
[/TR]
[TR]
[TD]1.01[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD]43[/TD]
[/TR]
[TR]
[TD]42[/TD]
[/TR]
[TR]
[TD]39[/TD]
[/TR]
[TR]
[TD]44[/TD]
[/TR]
[TR]
[TD]48[/TD]
[/TR]
[TR]
[TD]58[/TD]
[/TR]
[TR]
[TD]52[/TD]
[/TR]
[TR]
[TD]40[/TD]
[/TR]
[TR]
[TD]40[/TD]
[/TR]
[TR]
[TD]37[/TD]
[/TR]
[TR]
[TD]32[/TD]
[/TR]
[TR]
[TD]32[/TD]
[/TR]
[TR]
[TD]36[/TD]
[/TR]
[TR]
[TD]42[/TD]
[/TR]
[TR]
[TD]52[/TD]
[/TR]
[TR]
[TD]49[/TD]
[/TR]
[TR]
[TD]36[/TD]
[/TR]
[TR]
[TD]30[/TD]
[/TR]
[TR]
[TD]36[/TD]
[/TR]
[TR]
[TD]44[/TD]
[/TR]
[TR]
[TD]37[/TD]
[/TR]
[TR]
[TD]37[/TD]
[/TR]
[TR]
[TD]37[/TD]
[/TR]
[TR]
[TD]31[/TD]
[/TR]
[TR]
[TD]36[/TD]
[/TR]
[TR]
[TD]39[/TD]
[/TR]
[TR]
[TD]44[/TD]
[/TR]
[TR]
[TD]38[/TD]
[/TR]
[TR]
[TD]30[/TD]
[/TR]
[TR]
[TD]40[/TD]
[/TR]
[TR]
[TD]47[/TD]
[/TR]
[TR]
[TD]44[/TD]
[/TR]
[TR]
[TD]38[/TD]
[/TR]
[TR]
[TD]24[/TD]
[/TR]
[TR]
[TD]20[/TD]
[/TR]
[TR]
[TD]32[/TD]
[/TR]
[TR]
[TD]40[/TD]
[/TR]
[TR]
[TD]48[/TD]
[/TR]
[TR]
[TD]38[/TD]
[/TR]
[TR]
[TD]32[/TD]
[/TR]
[TR]
[TD]40[/TD]
[/TR]
[TR]
[TD]38[/TD]
[/TR]
[TR]
[TD]48[/TD]
[/TR]
[TR]
[TD]39[/TD]
[/TR]
[TR]
[TD]30[/TD]
[/TR]
[TR]
[TD]22[/TD]
[/TR]
[TR]
[TD]26[/TD]
[/TR]
[TR]
[TD]46[/TD]
[/TR]
[TR]
[TD]40[/TD]
[/TR]
[TR]
[TD]26[/TD]
[/TR]
[TR]
[TD]32[/TD]
[/TR]
[TR]
[TD]26[/TD]
[/TR]
[TR]
[TD]24[/TD]
[/TR]
[TR]
[TD]43[/TD]
[/TR]
[TR]
[TD]48[/TD]
[/TR]
[TR]
[TD]42[/TD]
[/TR]
[TR]
[TD]38[/TD]
[/TR]
[TR]
[TD]51[/TD]
[/TR]
[TR]
[TD]40[/TD]
[/TR]
[TR]
[TD]38[/TD]
[/TR]
[TR]
[TD]36[/TD]
[/TR]
[TR]
[TD]47[/TD]
[/TR]
[TR]
[TD]57[/TD]
[/TR]
[TR]
[TD]42[/TD]
[/TR]
[TR]
[TD]38[/TD]
[/TR]
[TR]
[TD]35[/TD]
[/TR]
[TR]
[TD]36[/TD]
[/TR]
[TR]
[TD]40[/TD]
[/TR]
[TR]
[TD]43[/TD]
[/TR]
[TR]
[TD]34[/TD]
[/TR]
[TR]
[TD]36[/TD]
[/TR]
[TR]
[TD]36[/TD]
[/TR]
[TR]
[TD]32[/TD]
[/TR]
[TR]
[TD]24[/TD]
[/TR]
[TR]
[TD]34[/TD]
[/TR]
[TR]
[TD]42[/TD]
[/TR]
[TR]
[TD]40[/TD]
[/TR]
[TR]
[TD]36[/TD]
[/TR]
[TR]
[TD]44[/TD]
[/TR]
[TR]
[TD]42[/TD]
[/TR]
[TR]
[TD]38[/TD]
[/TR]
[TR]
[TD]38[/TD]
[/TR]
[TR]
[TD]38[/TD]
[/TR]
[TR]
[TD]48[/TD]
[/TR]
[TR]
[TD]54[/TD]
[/TR]
[TR]
[TD]44[/TD]
[/TR]
[TR]
[TD]38[/TD]
[/TR]
[TR]
[TD]38[/TD]
[/TR]
[TR]
[TD]44[/TD]
[/TR]
[TR]
[TD]44[/TD]
[/TR]
[TR]
[TD]40[/TD]
[/TR]
[TR]
[TD]42[/TD]
[/TR]
[TR]
[TD]46[/TD]
[/TR]
[TR]
[TD]52[/TD]
[/TR]
[TR]
[TD]57[/TD]
[/TR]
[TR]
[TD]48[/TD]
[/TR]
[TR]
[TD]34[/TD]
[/TR]
[TR]
[TD]36[/TD]
[/TR]
[TR]
[TD]46[/TD]
[/TR]
[TR]
[TD]45[/TD]
[/TR]
[TR]
[TD]52[/TD]
[/TR]
[TR]
[TD]47[/TD]
[/TR]
[TR]
[TD]39[/TD]
[/TR]
[TR]
[TD]37[/TD]
[/TR]
[TR]
[TD]38[/TD]
[/TR]
[TR]
[TD]38[/TD]
[/TR]
[TR]
[TD]46[/TD]
[/TR]
[TR]
[TD]44[/TD]
[/TR]
[TR]
[TD]50[/TD]
[/TR]
[TR]
[TD]42[/TD]
[/TR]
[TR]
[TD]37[/TD]
[/TR]
[TR]
[TD]46[/TD]
[/TR]
[TR]
[TD]38[/TD]
[/TR]
[TR]
[TD]38[/TD]
[/TR]
[TR]
[TD]32[/TD]
[/TR]
[TR]
[TD]36[/TD]
[/TR]
[TR]
[TD]35[/TD]
[/TR]
[TR]
[TD]38[/TD]
[/TR]
[TR]
[TD]34[/TD]
[/TR]
[TR]
[TD]30[/TD]
[/TR]
[TR]
[TD]34[/TD]
[/TR]
[TR]
[TD]34[/TD]
[/TR]
[TR]
[TD]36[/TD]
[/TR]
[TR]
[TD]29[/TD]
[/TR]
[TR]
[TD]28[/TD]
[/TR]
[TR]
[TD]32[/TD]
[/TR]
[TR]
[TD]34[/TD]
[/TR]
[TR]
[TD]40[/TD]
[/TR]
[TR]
[TD]37[/TD]
[/TR]
[TR]
[TD]36[/TD]
[/TR]
[TR]
[TD]39[/TD]
[/TR]
[TR]
[TD]42[/TD]
[/TR]
[TR]
[TD]40[/TD]
[/TR]
[TR]
[TD]46[/TD]
[/TR]
[TR]
[TD]46[/TD]
[/TR]
[TR]
[TD]48[/TD]
[/TR]
[TR]
[TD]38[/TD]
[/TR]
[TR]
[TD]35[/TD]
[/TR]
[TR]
[TD]40[/TD]
[/TR]
[TR]
[TD]32[/TD]
[/TR]
[TR]
[TD]39[/TD]
[/TR]
[TR]
[TD]43[/TD]
[/TR]
[TR]
[TD]30[/TD]
[/TR]
[TR]
[TD]20[/TD]
[/TR]
[TR]
[TD]14[/TD]
[/TR]
[TR]
[TD]20[/TD]
[/TR]
[TR]
[TD]16[/TD]
[/TR]
[TR]
[TD]18[/TD]
[/TR]
[TR]
[TD]26[/TD]
[/TR]
[TR]
[TD]30[/TD]
[/TR]
[TR]
[TD]42[/TD]
[/TR]
[TR]
[TD]52[/TD]
[/TR]
[TR]
[TD]46[/TD]
[/TR]
[TR]
[TD]26[/TD]
[/TR]
[TR]
[TD]24[/TD]
[/TR]
[TR]
[TD]27[/TD]
[/TR]
[TR]
[TD]24[/TD]
[/TR]
[TR]
[TD]30[/TD]
[/TR]
[TR]
[TD]32[/TD]
[/TR]
[TR]
[TD]29[/TD]
[/TR]
[TR]
[TD]36[/TD]
[/TR]
[TR]
[TD]28[/TD]
[/TR]
[TR]
[TD]28[/TD]
[/TR]
[TR]
[TD]40[/TD]
[/TR]
[TR]
[TD]39[/TD]
[/TR]
[TR]
[TD]35[/TD]
[/TR]
[TR]
[TD]38[/TD]
[/TR]
[TR]
[TD]42[/TD]
[/TR]
[TR]
[TD]34[/TD]
[/TR]
[TR]
[TD]26[/TD]
[/TR]
[TR]
[TD]28[/TD]
[/TR]
[TR]
[TD]36[/TD]
[/TR]
[TR]
[TD]31[/TD]
[/TR]
[TR]
[TD]30[/TD]
[/TR]
[TR]
[TD]30[/TD]
[/TR]
[TR]
[TD]40[/TD]
[/TR]
[TR]
[TD]39[/TD]
[/TR]
[TR]
[TD]37[/TD]
[/TR]
[TR]
[TD]36[/TD]
[/TR]
[TR]
[TD]45[/TD]
[/TR]
[TR]
[TD]42[/TD]
[/TR]
[TR]
[TD]39[/TD]
[/TR]
[TR]
[TD]44[/TD]
[/TR]
[TR]
[TD]45[/TD]
[/TR]
[TR]
[TD]45[/TD]
[/TR]
[TR]
[TD]54[/TD]
[/TR]
[TR]
[TD]51[/TD]
[/TR]
[TR]
[TD]34[/TD]
[/TR]
[TR]
[TD]30[/TD]
[/TR]
[TR]
[TD]34[/TD]
[/TR]
[TR]
[TD]32[/TD]
[/TR]
[TR]
[TD]26[/TD]
[/TR]
[TR]
[TD]26[/TD]
[/TR]
[TR]
[TD]31[/TD]
[/TR]
[TR]
[TD]30[/TD]
[/TR]
[TR]
[TD]36[/TD]
[/TR]
[TR]
[TD]28[/TD]
[/TR]
[TR]
[TD]28[/TD]
[/TR]
[TR]
[TD]29[/TD]
[/TR]
[TR]
[TD]34[/TD]
[/TR]
[TR]
[TD]44[/TD]
[/TR]
[TR]
[TD]56[/TD]
[/TR]
[TR]
[TD]66[/TD]
[/TR]
[TR]
[TD]54[/TD]
[/TR]
[TR]
[TD]35[/TD]
[/TR]
[TR]
[TD]26[/TD]
[/TR]
[TR]
[TD]32[/TD]
[/TR]
[TR]
[TD]36[/TD]
[/TR]
[TR]
[TD]41[/TD]
[/TR]
[TR]
[TD]44[/TD]
[/TR]
[TR]
[TD]36[/TD]
[/TR]
[TR]
[TD]30[/TD]
[/TR]
[TR]
[TD]32[/TD]
[/TR]
[TR]
[TD]28[/TD]
[/TR]
[TR]
[TD]14[/TD]
[/TR]
[TR]
[TD]16[/TD]
[/TR]
[TR]
[TD]28[/TD]
[/TR]
[TR]
[TD]40[/TD]
[/TR]
[TR]
[TD]8[/TD]
[/TR]
[TR]
[TD]18[/TD]
[/TR]
[TR]
[TD]29[/TD]
[/TR]
[TR]
[TD]32[/TD]
[/TR]
[TR]
[TD]50[/TD]
[/TR]
[TR]
[TD]43[/TD]
[/TR]
[TR]
[TD]43[/TD]
[/TR]
[TR]
[TD]47[/TD]
[/TR]
[TR]
[TD]44[/TD]
[/TR]
[TR]
[TD]34[/TD]
[/TR]
[TR]
[TD]34[/TD]
[/TR]
[TR]
[TD]32[/TD]
[/TR]
[TR]
[TD]32[/TD]
[/TR]
[TR]
[TD]44[/TD]
[/TR]
[TR]
[TD]24[/TD]
[/TR]
[TR]
[TD]10[/TD]
[/TR]
[TR]
[TD]14[/TD]
[/TR]
[TR]
[TD]14[/TD]
[/TR]
[TR]
[TD]23[/TD]
[/TR]
[TR]
[TD]22[/TD]
[/TR]
[TR]
[TD]32[/TD]
[/TR]
[TR]
[TD]16[/TD]
[/TR]
[TR]
[TD]16[/TD]
[/TR]
[TR]
[TD]18[/TD]
[/TR]
[TR]
[TD]34[/TD]
[/TR]
[TR]
[TD]39[/TD]
[/TR]
[TR]
[TD]44[/TD]
[/TR]
[TR]
[TD]36[/TD]
[/TR]
[TR]
[TD]28[/TD]
[/TR]
[TR]
[TD]34[/TD]
[/TR]
[TR]
[TD]26[/TD]
[/TR]
[TR]
[TD]29[/TD]
[/TR]
[TR]
[TD]27[/TD]
[/TR]
[TR]
[TD]26[/TD]
[/TR]
[TR]
[TD]26[/TD]
[/TR]
[TR]
[TD]21[/TD]
[/TR]
[TR]
[TD]17[/TD]
[/TR]
[TR]
[TD]30[/TD]
[/TR]
[TR]
[TD]37[/TD]
[/TR]
[TR]
[TD]34[/TD]
[/TR]
[TR]
[TD]24[/TD]
[/TR]
[TR]
[TD]26[/TD]
[/TR]
[TR]
[TD]35[/TD]
[/TR]
[TR]
[TD]36[/TD]
[/TR]
[TR]
[TD]42[/TD]
[/TR]
[TR]
[TD]48[/TD]
[/TR]
[TR]
[TD]42[/TD]
[/TR]
[TR]
[TD]46[/TD]
[/TR]
[TR]
[TD]34[/TD]
[/TR]
[TR]
[TD]30[/TD]
[/TR]
[TR]
[TD]27[/TD]
[/TR]
[TR]
[TD]25[/TD]
[/TR]
[TR]
[TD]18[/TD]
[/TR]
[TR]
[TD]54[/TD]
[/TR]
[TR]
[TD]40[/TD]
[/TR]
[TR]
[TD]44[/TD]
[/TR]
[TR]
[TD]40[/TD]
[/TR]
[TR]
[TD]39[/TD]
[/TR]
[TR]
[TD]46[/TD]
[/TR]
[TR]
[TD]40[/TD]
[/TR]
[TR]
[TD]30[/TD]
[/TR]
[TR]
[TD]41[/TD]
[/TR]
[TR]
[TD]38[/TD]
[/TR]
[TR]
[TD]35[/TD]
[/TR]
[TR]
[TD]38[/TD]
[/TR]
[TR]
[TD]38[/TD]
[/TR]
[TR]
[TD]42[/TD]
[/TR]
[TR]
[TD]42[/TD]
[/TR]
[TR]
[TD]42[/TD]
[/TR]
[TR]
[TD]46[/TD]
[/TR]
[TR]
[TD]38[/TD]
[/TR]
[TR]
[TD]36[/TD]
[/TR]
[TR]
[TD]34[/TD]
[/TR]
[TR]
[TD]34[/TD]
[/TR]
[TR]
[TD]38[/TD]
[/TR]
[TR]
[TD]48[/TD]
[/TR]
[TR]
[TD]56[/TD]
[/TR]
[TR]
[TD]54[/TD]
[/TR]
[TR]
[TD]42[/TD]
[/TR]
[TR]
[TD]45[/TD]
[/TR]
[TR]
[TD]47[/TD]
[/TR]
[TR]
[TD]40[/TD]
[/TR]
[TR]
[TD]32[/TD]
[/TR]
[TR]
[TD]28[/TD]
[/TR]
[TR]
[TD]34[/TD]
[/TR]
[TR]
[TD]36[/TD]
[/TR]
[TR]
[TD]34[/TD]
[/TR]
[TR]
[TD]51[/TD]
[/TR]
[TR]
[TD]36[/TD]
[/TR]
[TR]
[TD]21[/TD]
[/TR]
[TR]
[TD]18[/TD]
[/TR]
[TR]
[TD]14[/TD]
[/TR]
[TR]
[TD]28[/TD]
[/TR]
[TR]
[TD]20[/TD]
[/TR]
[TR]
[TD]28[/TD]
[/TR]
[TR]
[TD]37[/TD]
[/TR]
[TR]
[TD]28[/TD]
[/TR]
[TR]
[TD]26[/TD]
[/TR]
[TR]
[TD]32[/TD]
[/TR]
[TR]
[TD]34[/TD]
[/TR]
[TR]
[TD]24[/TD]
[/TR]
[TR]
[TD]34[/TD]
[/TR]
[TR]
[TD]40[/TD]
[/TR]
[TR]
[TD]39[/TD]
[/TR]
[TR]
[TD]30[/TD]
[/TR]
[TR]
[TD]36[/TD]
[/TR]
[TR]
[TD]29[/TD]
[/TR]
[TR]
[TD]36[/TD]
[/TR]
[TR]
[TD]40[/TD]
[/TR]
[TR]
[TD]28[/TD]
[/TR]
[TR]
[TD]27[/TD]
[/TR]
[TR]
[TD]26[/TD]
[/TR]
[TR]
[TD]26[/TD]
[/TR]
[TR]
[TD]31[/TD]
[/TR]
[TR]
[TD]21[/TD]
[/TR]
[TR]
[TD]31[/TD]
[/TR]
[TR]
[TD]29[/TD]
[/TR]
[TR]
[TD]24[/TD]
[/TR]
[TR]
[TD]35[/TD]
[/TR]
[TR]
[TD]30[/TD]
[/TR]
[TR]
[TD]24[/TD]
[/TR]
[TR]
[TD]34[/TD]
[/TR]
[TR]
[TD]40[/TD]
[/TR]
[TR]
[TD]32[/TD]
[/TR]
[TR]
[TD]36[/TD]
[/TR]
[TR]
[TD]32[/TD]
[/TR]
[TR]
[TD]32[/TD]
[/TR]
[TR]
[TD]16[/TD]
[/TR]
[TR]
[TD]24[/TD]
[/TR]
[TR]
[TD]15[/TD]
[/TR]
[TR]
[TD]10[/TD]
[/TR]
[TR]
[TD]21[/TD]
[/TR]
[TR]
[TD]22[/TD]
[/TR]
[TR]
[TD]16[/TD]
[/TR]
[TR]
[TD]10[/TD]
[/TR]
[TR]
[TD]20[/TD]
[/TR]
[TR]
[TD]40[/TD]
[/TR]
[TR]
[TD]24[/TD]
[/TR]
[TR]
[TD]16[/TD]
[/TR]
[TR]
[TD]26[/TD]
[/TR]
[TR]
[TD]28[/TD]
[/TR]
[TR]
[TD]26[/TD]
[/TR]
[TR]
[TD]22[/TD]
[/TR]
[TR]
[TD]50[/TD]
[/TR]
[TR]
[TD]56[/TD]
[/TR]
[TR]
[TD]48[/TD]
[/TR]
[TR]
[TD]44[/TD]
[/TR]
[TR]
[TD]43[/TD]
[/TR]
[TR]
[TD]42[/TD]
[/TR]
[TR]
[TD]42[/TD]
[/TR]
[TR]
[TD]44[/TD]
[/TR]
[TR]
[TD]45[/TD]
[/TR]
[TR]
[TD]52[/TD]
[/TR]
[TR]
[TD]48[/TD]
[/TR]
[TR]
[TD]58[/TD]
[/TR]
[TR]
[TD]62[/TD]
[/TR]
[TR]
[TD]62[/TD]
[/TR]
[TR]
[TD]60[/TD]
[/TR]
[TR]
[TD]50[/TD]
[/TR]
[TR]
[TD]52[/TD]
[/TR]
[TR]
[TD]46[/TD]
[/TR]
[TR]
[TD]37[/TD]
[/TR]
[TR]
[TD]36[/TD]
[/TR]
[TR]
[TD]44[/TD]
[/TR]
[TR]
[TD]58[/TD]
[/TR]
[TR]
[TD]62[/TD]
[/TR]
[TR]
[TD]67[/TD]
[/TR]
[TR]
[TD]64[/TD]
[/TR]
[TR]
[TD]56[/TD]
[/TR]
[TR]
[TD]55[/TD]
[/TR]
[TR]
[TD]42[/TD]
[/TR]
[TR]
[TD]44[/TD]
[/TR]
[TR]
[TD]48[/TD]
[/TR]
[TR]
[TD]46[/TD]
[/TR]
[TR]
[TD]38[/TD]
[/TR]
[TR]
[TD]36[/TD]
[/TR]
[TR]
[TD]37[/TD]
[/TR]
[TR]
[TD]26[/TD]
[/TR]
[TR]
[TD]21[/TD]
[/TR]
[TR]
[TD]28[/TD]
[/TR]
[TR]
[TD]34[/TD]
[/TR]
[TR]
[TD]39[/TD]
[/TR]
[TR]
[TD]46[/TD]
[/TR]
[TR]
[TD]54[/TD]
[/TR]
[TR]
[TD]30[/TD]
[/TR]
[TR]
[TD]32[/TD]
[/TR]
[TR]
[TD]24[/TD]
[/TR]
[TR]
[TD]34[/TD]
[/TR]
[TR]
[TD]40[/TD]
[/TR]
[TR]
[TD]47[/TD]
[/TR]
[TR]
[TD]34[/TD]
[/TR]
[TR]
[TD]24[/TD]
[/TR]
[TR]
[TD]22[/TD]
[/TR]
[TR]
[TD]29[/TD]
[/TR]
[TR]
[TD]32[/TD]
[/TR]
[TR]
[TD]24[/TD]
[/TR]
[TR]
[TD]27[/TD]
[/TR]
[TR]
[TD]27[/TD]
[/TR]
[TR]
[TD]28[/TD]
[/TR]
[TR]
[TD]34[/TD]
[/TR]
[TR]
[TD]37[/TD]
[/TR]
[TR]
[TD]32[/TD]
[/TR]
[TR]
[TD]34[/TD]
[/TR]
[TR]
[TD]33[/TD]
[/TR]
[TR]
[TD]42[/TD]
[/TR]
[TR]
[TD]52[/TD]
[/TR]
[TR]
[TD]42[/TD]
[/TR]
[TR]
[TD]50[/TD]
[/TR]
[TR]
[TD]52[/TD]
[/TR]
[TR]
[TD]36[/TD]
[/TR]
[TR]
[TD]33[/TD]
[/TR]
[TR]
[TD]36[/TD]
[/TR]
[TR]
[TD]37[/TD]
[/TR]
[TR]
[TD]34[/TD]
[/TR]
[TR]
[TD]32[/TD]
[/TR]
[TR]
[TD]22[/TD]
[/TR]
[TR]
[TD]20[/TD]
[/TR]
[TR]
[TD]18[/TD]
[/TR]
[TR]
[TD]12[/TD]
[/TR]
[TR]
[TD]25[/TD]
[/TR]
[TR]
[TD]47[/TD]
[/TR]
[TR]
[TD]38[/TD]
[/TR]
[TR]
[TD]32[/TD]
[/TR]
[TR]
[TD]30[/TD]
[/TR]
[TR]
[TD]51[/TD]
[/TR]
[TR]
[TD]48[/TD]
[/TR]
[TR]
[TD]44[/TD]
[/TR]
[TR]
[TD]40[/TD]
[/TR]
[TR]
[TD]54[/TD]
[/TR]
[TR]
[TD]51[/TD]
[/TR]
[TR]
[TD]36[/TD]
[/TR]
[TR]
[TD]34[/TD]
[/TR]
[TR]
[TD]50[/TD]
[/TR]
[TR]
[TD]54[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Last edited:
Sort by date Sort by votes
misterno said:
I can do a regression but it seems like there are 2 slopes here and I do not know how to create 2 equations

I found some VBA codes in the forum for 3 slopes in a regression but I need 2 pieces here.
...
...
Thanks
Click to expand...
Putting your data into a chart it looks like a nonlinear relationship.
Like instead of
Y = a + b*X
it's more like
Y = a + b/X

The latter implies a continuously varying slope.

Why do you want just two slopes?

This isn't an idle question, because with regressions the more information you put into them at the start the better the result is likely to be.

If you insist on two slopes, are you looking at two totally independent (linear?) regressions, or something like a spline regression joined at one (or more) spline knots, or maybe something else?

If you want two regressions, are you thinking of (say) the first third of your data list being used for one and the remaining two-thirds being used for the other? You can estimate the split point using a best fit or other criterion if needed. Or why not just use an arbitrary split point, if you've got a reason not to do so then what is that reason?

Or is it that you're looking for some kind of discrimination or classification function picking out which of your dataset best fits one line and which of it best fits the other?

You should really provide more information to get a reasonable response.
 
Upvote 0
kalak said:
Putting your data into a chart it looks like a nonlinear relationship.
Like instead of
Y = a + b*X
it's more like
Y = a + b/X

The latter implies a continuously varying slope.

Why do you want just two slopes?

This isn't an idle question, because with regressions the more information you put into them at the start the better the result is likely to be.

If you insist on two slopes, are you looking at two totally independent (linear?) regressions, or something like a spline regression joined at one (or more) spline knots, or maybe something else?

If you want two regressions, are you thinking of (say) the first third of your data list being used for one and the remaining two-thirds being used for the other? You can estimate the split point using a best fit or other criterion if needed. Or why not just use an arbitrary split point, if you've got a reason not to do so then what is that reason?

Or is it that you're looking for some kind of discrimination or classification function picking out which of your dataset best fits one line and which of it best fits the other?

You should really provide more information to get a reasonable response.
Click to expand...

well I want 2 linear equations because that is the requirement by the management

The data is designed such a way that you will have 2 distinct equations anyway
 
Upvote 0
misterno said:
well I want 2 linear equations because that is the requirement by the management.

The data is designed such a way that you will have 2 distinct equations anyway
Click to expand...
OK. So just split the data according to the design and run a separate regression on each split.

There's a couple of handy regressions in Excel, LINEST and the one in the analysis pac, or you can use a made up one of which there's a few around.
 
Upvote 0
kalak said:
OK. So just split the data according to the design and run a separate regression on each split.

There's a couple of handy regressions in Excel, LINEST and the one in the analysis pac, or you can use a made up one of which there's a few around.
Click to expand...

That is the problem

I want the algorith or VBA code to determine where the cut off is where the other equation/slope starts

Otherwise mine would be a guess work
 
Upvote 0
misterno said:
That is the problem

I want the algorith or VBA code to determine where the cut off is where the other equation/slope starts

Otherwise mine would be a guess work
Click to expand...
So you want to divide the data up into say the top third and the bottom 2/3 with the split point determined by the data?

You can do a "brute force" approach in that case by doing one regression on say the first three sample point, and another on the remainder.

Then on the first four, and on the remainder and so on. All that wouldn't take long with modern computers. And then use some criterion such as combined correlations to choose the regression pair giving best overall fit.

But this seems rather pointless without some clearer knowledge of how your data are generated. For example the result might change if the data were sorted differently.
Or maybe you want to pick out every second sample value for the first regression and the in between ones for the second. Who knows?

And do you want totally independent regressions or ones that are splined or joined in some way. Who knows?

You opening post indicates you know how to do what you want with 3 regressions. So why don't you just change the 3 to 2 in that procedure, whatever it is?
 
Upvote 0
kalak said:
So you want to divide the data up into say the top third and the bottom 2/3 with the split point determined by the data?

You can do a "brute force" approach in that case by doing one regression on say the first three sample point, and another on the remainder.

Then on the first four, and on the remainder and so on. All that wouldn't take long with modern computers. And then use some criterion such as combined correlations to choose the regression pair giving best overall fit.

But this seems rather pointless without some clearer knowledge of how your data are generated. For example the result might change if the data were sorted differently.
Or maybe you want to pick out every second sample value for the first regression and the in between ones for the second. Who knows?

And do you want totally independent regressions or ones that are splined or joined in some way. Who knows?

You opening post indicates you know how to do what you want with 3 regressions. So why don't you just change the 3 to 2 in that procedure, whatever it is?
Click to expand...

The regression should not change no matter how you sort

There are some VBA codes out there for 3 equations but nothing for 2, and I was not able to adjust it for 2 equations

Maybe you can help me with the VBA code below?

http://www.mrexcel.com/forum/excel-...ear-regression-visual-basic-applications.html
 
Upvote 0
misterno said:
The regression should not change no matter how you sort

There are some VBA codes out there for 3 equations but nothing for 2, and I was not able to adjust it for 2 equations

Maybe you can help me with the VBA code below?

http://www.mrexcel.com/forum/excel-...ear-regression-visual-basic-applications.html
Click to expand...
That link is about multiple regression, where you have:
Y = a + bx + cz
sort of thing rather than the
Y= a + bx
setup that you suggested in your opening post.

Multiple regression is easy enough to do, but if you could be more specific about just what you want done ...

Which particular post in that link do you consider relevant to your problem? And how do your posted data relate to it?
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

V
  • Solved
Dynamic arrays, circular arguments and all I want to due is increment a previous number
Replies
3
Views
166
djclements
djclements
D
  • Question Question
Formula help
Replies
1
Views
129
6StringJazzer
6StringJazzer
E
  • Question Question
counting duplicates error
Replies
1
Views
179
jasonb75
J
J
  • Question Question
Removing blank rows based on cell value
Replies
2
Views
412
Peter_SSs
Peter_SSs
S
  • Solved
Data manipulation with dynamic arrays
Replies
5
Views
135
Fluff
Fluff

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top