Excel 2016 Regression error #NUM!

C

cccbzg

Board Regular
Joined
Oct 5, 2014
Messages
68
Office Version
  1. 365
Platform
  1. Windows
Hi,

I am trying to find out which of seven scores (if any) are good predictors of another value (predicted?). When I run the regression analysis I get an error #NUM ! in the Grade 7 P value and I can't figure out why. Any help would be MUCH appreciated.

Multiple R
R Square
Adjusted R Square
Standard Error
ANOVA
Regression
Residual
Intercept
Grade1
Grade 2
Grade3
Grade4
Grade5
Grade6

<colgroup><col style="width:48pt" span="9" width="64"> </colgroup><tbody>
[TD="width: 128, colspan: 2"]SUMMARY OUTPUT[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]

[TD="class: xl65, colspan: 2, align: center"]Regression Statistics[/TD]

[TD="align: right"]0.799881[/TD]

[TD="align: right"]0.63981[/TD]

[TD="align: right"]0.621431[/TD]

[TD="align: right"]10.25229[/TD]

[TD="class: xl63"]Observations[/TD]
[TD="class: xl63, align: right"]179[/TD]

[TD="class: xl64"] [/TD]
[TD="class: xl64"]df[/TD]
[TD="class: xl64"]SS[/TD]
[TD="class: xl64"]MS[/TD]
[TD="class: xl64"]F[/TD]
[TD="class: xl64"]Significance F[/TD]

[TD="align: right"]7[/TD]
[TD="align: right"]32113.63[/TD]
[TD="align: right"]4587.662[/TD]
[TD="align: right"]50.9209[/TD]
[TD="align: right"]1.22E-38[/TD]

[TD="align: right"]172[/TD]
[TD="align: right"]18078.84[/TD]
[TD="align: right"]105.1095[/TD]

[TD="class: xl63"]Total[/TD]
[TD="class: xl63, align: right"]179[/TD]
[TD="class: xl63, align: right"]50192.47[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl64"] [/TD]
[TD="class: xl64"]Coefficients[/TD]
[TD="class: xl64"]Standard Error[/TD]
[TD="class: xl64"]t Stat[/TD]
[TD="class: xl64"]P-value[/TD]
[TD="class: xl64"]Lower 95%[/TD]
[TD="class: xl64"]Upper 95%[/TD]
[TD="class: xl64"]Lower 95.0%[/TD]
[TD="class: xl64"]Upper 95.0%[/TD]

[TD="align: right"]15.90824[/TD]
[TD="align: right"]13.79764[/TD]
[TD="align: right"]1.152968[/TD]
[TD="align: right"]0.250523[/TD]
[TD="align: right"]-11.3263[/TD]
[TD="align: right"]43.14273[/TD]
[TD="align: right"]-11.3263[/TD]
[TD="align: right"]43.14273[/TD]

[TD="align: right"]0.370032[/TD]
[TD="align: right"]0.133503[/TD]
[TD="align: right"]2.771711[/TD]
[TD="align: right"]0.00619[/TD]
[TD="align: right"]0.106517[/TD]
[TD="align: right"]0.633548[/TD]
[TD="align: right"]0.106517[/TD]
[TD="align: right"]0.633548[/TD]

[TD="align: right"]-0.00385[/TD]
[TD="align: right"]0.180954[/TD]
[TD="align: right"]-0.02127[/TD]
[TD="align: right"]0.983054[/TD]
[TD="align: right"]-0.36103[/TD]
[TD="align: right"]0.353328[/TD]
[TD="align: right"]-0.36103[/TD]
[TD="align: right"]0.353328[/TD]

[TD="align: right"]0.459855[/TD]
[TD="align: right"]0.199211[/TD]
[TD="align: right"]2.308383[/TD]
[TD="align: right"]0.022168[/TD]
[TD="align: right"]0.066642[/TD]
[TD="align: right"]0.853067[/TD]
[TD="align: right"]0.066642[/TD]
[TD="align: right"]0.853067[/TD]

[TD="align: right"]0.373594[/TD]
[TD="align: right"]0.154394[/TD]
[TD="align: right"]2.419742[/TD]
[TD="align: right"]0.016573[/TD]
[TD="align: right"]0.068843[/TD]
[TD="align: right"]0.678345[/TD]
[TD="align: right"]0.068843[/TD]
[TD="align: right"]0.678345[/TD]

[TD="align: right"]1.01336[/TD]
[TD="align: right"]0.182439[/TD]
[TD="align: right"]5.554504[/TD]
[TD="align: right"]1.04E-07[/TD]
[TD="align: right"]0.653251[/TD]
[TD="align: right"]1.373468[/TD]
[TD="align: right"]0.653251[/TD]
[TD="align: right"]1.373468[/TD]

[TD="align: right"]0.368392[/TD]
[TD="align: right"]0.206216[/TD]
[TD="align: right"]1.786433[/TD]
[TD="align: right"]0.075791[/TD]
[TD="align: right"]-0.03865[/TD]
[TD="align: right"]0.775432[/TD]
[TD="align: right"]-0.03865[/TD]
[TD="align: right"]0.775432[/TD]

[TD="class: xl63"]Grade7[/TD]
[TD="class: xl63, align: right"]0[/TD]
[TD="class: xl63, align: right"]0[/TD]
[TD="class: xl63, align: right"]65535[/TD]
[TD="class: xl63, align: center"] #NUM ![/TD]
[TD="class: xl63, align: right"]0[/TD]
[TD="class: xl63, align: right"]0[/TD]
[TD="class: xl63, align: right"]0[/TD]
[TD="class: xl63, align: right"]0[/TD]

</tbody>


INPUT DATA


<colgroup><col style="width:48pt" span="6" width="64"> <col style="width:48pt" width="64"> <col style="width:48pt" width="64"> </colgroup><tbody>
[TD="width: 64"]Grade1[/TD]
[TD="width: 64"]Grade 2[/TD]
[TD="width: 64"]Grade3[/TD]
[TD="width: 64"]Grade4[/TD]
[TD="width: 64"]Grade5[/TD]
[TD="width: 64"]Grade6[/TD]
[TD="class: xl65, width: 64"]Grade7[/TD]
[TD="width: 64"]predicted?[/TD]

[TD="align: right"]83[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]88[/TD]
[TD="class: xl65, align: right"]84.17[/TD]
[TD="align: right"]226[/TD]

[TD="align: right"]83[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]85[/TD]
[TD="class: xl65, align: right"]85.50[/TD]
[TD="align: right"]232[/TD]

[TD="align: right"]83[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]89[/TD]
[TD="class: xl65, align: right"]81.67[/TD]
[TD="align: right"]202[/TD]

[TD="align: right"]89[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]91[/TD]
[TD="class: xl65, align: right"]87.33[/TD]
[TD="align: right"]230[/TD]

[TD="align: right"]67[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]79[/TD]
[TD="class: xl65, align: right"]80.67[/TD]
[TD="align: right"]219[/TD]

[TD="align: right"]70[/TD]
[TD="align: right"]72[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]63[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]75[/TD]
[TD="class: xl65, align: right"]72.17[/TD]
[TD="align: right"]204[/TD]

[TD="align: right"]75[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]83[/TD]
[TD="class: xl65, align: right"]80.17[/TD]
[TD="align: right"]225[/TD]

[TD="align: right"]77[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]87[/TD]
[TD="class: xl65, align: right"]82.83[/TD]
[TD="align: right"]233[/TD]

[TD="align: right"]78[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]90[/TD]
[TD="class: xl65, align: right"]80.33[/TD]
[TD="align: right"]242[/TD]

[TD="align: right"]92[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]80[/TD]
[TD="class: xl65, align: right"]85.83[/TD]
[TD="align: right"]237[/TD]

[TD="align: right"]88[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]87[/TD]
[TD="class: xl65, align: right"]83.00[/TD]
[TD="align: right"]207[/TD]

[TD="align: right"]83[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]78[/TD]
[TD="class: xl65, align: right"]82.83[/TD]
[TD="align: right"]238[/TD]

[TD="align: right"]86[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]84[/TD]
[TD="class: xl65, align: right"]82.67[/TD]
[TD="align: right"]237[/TD]

[TD="align: right"]81[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]64[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]87[/TD]
[TD="class: xl65, align: right"]80.83[/TD]
[TD="align: right"]206[/TD]

[TD="align: right"]81[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]83[/TD]
[TD="class: xl65, align: right"]84.67[/TD]
[TD="align: right"]237[/TD]

[TD="align: right"]89[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]72[/TD]
[TD="align: right"]72[/TD]
[TD="align: right"]82[/TD]
[TD="class: xl65, align: right"]80.67[/TD]
[TD="align: right"]225[/TD]

[TD="align: right"]73[/TD]
[TD="align: right"]69[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]78[/TD]
[TD="class: xl65, align: right"]77.50[/TD]
[TD="align: right"]224[/TD]

[TD="align: right"]83[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]90[/TD]
[TD="class: xl65, align: right"]89.67[/TD]
[TD="align: right"]264[/TD]

[TD="align: right"]89[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]89[/TD]
[TD="class: xl65, align: right"]83.33[/TD]
[TD="align: right"]240[/TD]

[TD="align: right"]83[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]94[/TD]
[TD="align: right"]73[/TD]
[TD="align: right"]74[/TD]
[TD="align: right"]86[/TD]
[TD="class: xl65, align: right"]81.50[/TD]
[TD="align: right"]203[/TD]

[TD="align: right"]69[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]71[/TD]
[TD="align: right"]72[/TD]
[TD="align: right"]87[/TD]
[TD="class: xl65, align: right"]76.67[/TD]
[TD="align: right"]218[/TD]

[TD="align: right"]67[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]83[/TD]
[TD="class: xl65, align: right"]78.33[/TD]
[TD="align: right"]226[/TD]

[TD="align: right"]78[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]82[/TD]
[TD="class: xl65, align: right"]80.33[/TD]
[TD="align: right"]220[/TD]

[TD="align: right"]73[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]83[/TD]
[TD="class: xl65, align: right"]78.67[/TD]
[TD="align: right"]227[/TD]

[TD="align: right"]91[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]74[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]89[/TD]
[TD="class: xl65, align: right"]85.50[/TD]
[TD="align: right"]213[/TD]

[TD="align: right"]91[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]73[/TD]
[TD="align: right"]74[/TD]
[TD="align: right"]80[/TD]
[TD="class: xl65, align: right"]82.00[/TD]
[TD="align: right"]231[/TD]

[TD="align: right"]83[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]72[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]81[/TD]
[TD="class: xl65, align: right"]79.00[/TD]
[TD="align: right"]217[/TD]

[TD="align: right"]81[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]74[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]76[/TD]
[TD="class: xl65, align: right"]78.17[/TD]
[TD="align: right"]205[/TD]

[TD="align: right"]75[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]73[/TD]
[TD="align: right"]59[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]74[/TD]
[TD="class: xl65, align: right"]72.83[/TD]
[TD="align: right"]202[/TD]

[TD="align: right"]84[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]90[/TD]
[TD="class: xl65, align: right"]83.67[/TD]
[TD="align: right"]222[/TD]

[TD="align: right"]88[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]78[/TD]
[TD="class: xl65, align: right"]82.67[/TD]
[TD="align: right"]247[/TD]

[TD="align: right"]95[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]95[/TD]
[TD="class: xl65, align: right"]93.00[/TD]
[TD="align: right"]255[/TD]

[TD="align: right"]95[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]94[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]94[/TD]
[TD="align: right"]91[/TD]
[TD="class: xl65, align: right"]92.83[/TD]
[TD="align: right"]253[/TD]

[TD="align: right"]92[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]96[/TD]
[TD="align: right"]95[/TD]
[TD="align: right"]92[/TD]
[TD="class: xl65, align: right"]93.00[/TD]
[TD="align: right"]261[/TD]

[TD="align: right"]92[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]94[/TD]
[TD="align: right"]98[/TD]
[TD="align: right"]95[/TD]
[TD="align: right"]95[/TD]
[TD="class: xl65, align: right"]94.17[/TD]
[TD="align: right"]266[/TD]

[TD="align: right"]84[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]88[/TD]
[TD="class: xl65, align: right"]84.50[/TD]
[TD="align: right"]242[/TD]

[TD="align: right"]66[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]85[/TD]
[TD="class: xl65, align: right"]77.50[/TD]
[TD="align: right"]216[/TD]

[TD="align: right"]77[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]83[/TD]
[TD="class: xl65, align: right"]79.67[/TD]
[TD="align: right"]222[/TD]

[TD="align: right"]91[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]97[/TD]
[TD="class: xl65, align: right"]88.83[/TD]
[TD="align: right"]249[/TD]

[TD="align: right"]78[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]73[/TD]
[TD="align: right"]85[/TD]
[TD="class: xl65, align: right"]79.67[/TD]
[TD="align: right"]225[/TD]

[TD="align: right"]84[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]83[/TD]
[TD="class: xl65, align: right"]84.67[/TD]
[TD="align: right"]239[/TD]

[TD="align: right"]86[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]88[/TD]
[TD="class: xl65, align: right"]87.17[/TD]
[TD="align: right"]233[/TD]

[TD="align: right"]80[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]87[/TD]
[TD="class: xl65, align: right"]86.33[/TD]
[TD="align: right"]232[/TD]

[TD="align: right"]78[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]77[/TD]
[TD="class: xl65, align: right"]76.83[/TD]
[TD="align: right"]210[/TD]

[TD="align: right"]86[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]94[/TD]
[TD="align: right"]97[/TD]
[TD="class: xl65, align: right"]90.67[/TD]
[TD="align: right"]258[/TD]

[TD="align: right"]88[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]92[/TD]
[TD="class: xl65, align: right"]87.17[/TD]
[TD="align: right"]254[/TD]

[TD="align: right"]89[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]81[/TD]
[TD="class: xl65, align: right"]82.83[/TD]
[TD="align: right"]211[/TD]

[TD="align: right"]73[/TD]
[TD="align: right"]74[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]87[/TD]
[TD="class: xl65, align: right"]76.83[/TD]
[TD="align: right"]233[/TD]

[TD="align: right"]88[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]86[/TD]
[TD="class: xl65, align: right"]86.00[/TD]
[TD="align: right"]248[/TD]

[TD="align: right"]88[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]94[/TD]
[TD="class: xl65, align: right"]91.00[/TD]
[TD="align: right"]250[/TD]

[TD="align: right"]86[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]95[/TD]
[TD="class: xl65, align: right"]89.83[/TD]
[TD="align: right"]243[/TD]

[TD="align: right"]94[/TD]
[TD="align: right"]94[/TD]
[TD="align: right"]98[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]97[/TD]
[TD="class: xl65, align: right"]96.17[/TD]
[TD="align: right"]268[/TD]

[TD="align: right"]94[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]98[/TD]
[TD="align: right"]98[/TD]
[TD="class: xl65, align: right"]94.67[/TD]
[TD="align: right"]259[/TD]

[TD="align: right"]88[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]73[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]86[/TD]
[TD="class: xl65, align: right"]80.67[/TD]
[TD="align: right"]228[/TD]

[TD="align: right"]86[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]90[/TD]
[TD="class: xl65, align: right"]84.50[/TD]
[TD="align: right"]240[/TD]

[TD="align: right"]75[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]82[/TD]
[TD="class: xl65, align: right"]80.50[/TD]
[TD="align: right"]228[/TD]

[TD="align: right"]84[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]95[/TD]
[TD="align: right"]94[/TD]
[TD="align: right"]93[/TD]
[TD="class: xl65, align: right"]91.00[/TD]
[TD="align: right"]255[/TD]

[TD="align: right"]81[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]93[/TD]
[TD="class: xl65, align: right"]86.33[/TD]
[TD="align: right"]229[/TD]

[TD="align: right"]80[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]86[/TD]
[TD="class: xl65, align: right"]85.33[/TD]
[TD="align: right"]227[/TD]

[TD="align: right"]81[/TD]
[TD="align: right"]73[/TD]
[TD="align: right"]69[/TD]
[TD="align: right"]71[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]74[/TD]
[TD="class: xl65, align: right"]74.17[/TD]
[TD="align: right"]211[/TD]

[TD="align: right"]86[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]95[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]91[/TD]
[TD="class: xl65, align: right"]89.50[/TD]
[TD="align: right"]231[/TD]

[TD="align: right"]94[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]90[/TD]
[TD="class: xl65, align: right"]88.50[/TD]
[TD="align: right"]236[/TD]

[TD="align: right"]81[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]91[/TD]
[TD="class: xl65, align: right"]87.50[/TD]
[TD="align: right"]247[/TD]

[TD="align: right"]81[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]82[/TD]
[TD="class: xl65, align: right"]79.83[/TD]
[TD="align: right"]226[/TD]

[TD="align: right"]88[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]73[/TD]
[TD="align: right"]78[/TD]
[TD="class: xl65, align: right"]81.67[/TD]
[TD="align: right"]220[/TD]

[TD="align: right"]84[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]91[/TD]
[TD="class: xl65, align: right"]87.67[/TD]
[TD="align: right"]253[/TD]

[TD="align: right"]84[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]91[/TD]
[TD="class: xl65, align: right"]87.83[/TD]
[TD="align: right"]250[/TD]

[TD="align: right"]84[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]95[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]86[/TD]
[TD="class: xl65, align: right"]89.67[/TD]
[TD="align: right"]252[/TD]

[TD="align: right"]91[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]96[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]93[/TD]
[TD="class: xl65, align: right"]92.67[/TD]
[TD="align: right"]257[/TD]

[TD="align: right"]75[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]81[/TD]
[TD="class: xl65, align: right"]76.17[/TD]
[TD="align: right"]231[/TD]

[TD="align: right"]86[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]95[/TD]
[TD="class: xl65, align: right"]86.50[/TD]
[TD="align: right"]244[/TD]

[TD="align: right"]84[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]90[/TD]
[TD="class: xl65, align: right"]82.83[/TD]
[TD="align: right"]248[/TD]

[TD="align: right"]92[/TD]
[TD="align: right"]94[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]90[/TD]
[TD="class: xl65, align: right"]88.00[/TD]
[TD="align: right"]246[/TD]

[TD="align: right"]81[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]90[/TD]
[TD="class: xl65, align: right"]82.00[/TD]
[TD="align: right"]240[/TD]

[TD="align: right"]75[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]94[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]82[/TD]
[TD="class: xl65, align: right"]82.50[/TD]
[TD="align: right"]222[/TD]

[TD="align: right"]89[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]90[/TD]
[TD="class: xl65, align: right"]87.50[/TD]
[TD="align: right"]256[/TD]

[TD="align: right"]86[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]83[/TD]
[TD="class: xl65, align: right"]85.00[/TD]
[TD="align: right"]246[/TD]

[TD="align: right"]88[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]90[/TD]
[TD="class: xl65, align: right"]86.50[/TD]
[TD="align: right"]247[/TD]

[TD="align: right"]94[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]95[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]92[/TD]
[TD="class: xl65, align: right"]93.33[/TD]
[TD="align: right"]265[/TD]

[TD="align: right"]88[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]89[/TD]
[TD="class: xl65, align: right"]86.67[/TD]
[TD="align: right"]223[/TD]

[TD="align: right"]88[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]90[/TD]
[TD="class: xl65, align: right"]89.17[/TD]
[TD="align: right"]260[/TD]

[TD="align: right"]92[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]90[/TD]
[TD="class: xl65, align: right"]86.50[/TD]
[TD="align: right"]243[/TD]

[TD="align: right"]83[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]73[/TD]
[TD="align: right"]85[/TD]
[TD="class: xl65, align: right"]81.83[/TD]
[TD="align: right"]214[/TD]

[TD="align: right"]84[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]83[/TD]
[TD="class: xl65, align: right"]85.33[/TD]
[TD="align: right"]250[/TD]

[TD="align: right"]75[/TD]
[TD="align: right"]73[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]71[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]77[/TD]
[TD="class: xl65, align: right"]74.83[/TD]
[TD="align: right"]207[/TD]

[TD="align: right"]91[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]88[/TD]
[TD="class: xl65, align: right"]85.33[/TD]
[TD="align: right"]222[/TD]

[TD="align: right"]67[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]79[/TD]
[TD="class: xl65, align: right"]77.67[/TD]
[TD="align: right"]219[/TD]

[TD="align: right"]94[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]94[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]95[/TD]
[TD="align: right"]97[/TD]
[TD="class: xl65, align: right"]94.00[/TD]
[TD="align: right"]262[/TD]

[TD="align: right"]92[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]88[/TD]
[TD="class: xl65, align: right"]87.33[/TD]
[TD="align: right"]248[/TD]

[TD="align: right"]86[/TD]
[TD="align: right"]73[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]72[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]84[/TD]
[TD="class: xl65, align: right"]79.17[/TD]
[TD="align: right"]230[/TD]

[TD="align: right"]88[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]89[/TD]
[TD="class: xl65, align: right"]87.50[/TD]
[TD="align: right"]247[/TD]

[TD="align: right"]91[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]90[/TD]
[TD="class: xl65, align: right"]88.17[/TD]
[TD="align: right"]253[/TD]

[TD="align: right"]81[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]85[/TD]
[TD="class: xl65, align: right"]84.00[/TD]
[TD="align: right"]235[/TD]

[TD="align: right"]86[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]95[/TD]
[TD="align: right"]92[/TD]
[TD="class: xl65, align: right"]90.17[/TD]
[TD="align: right"]251[/TD]

[TD="align: right"]83[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]83[/TD]
[TD="class: xl65, align: right"]81.50[/TD]
[TD="align: right"]195[/TD]

[TD="align: right"]89[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]89[/TD]
[TD="class: xl65, align: right"]89.50[/TD]
[TD="align: right"]252[/TD]

[TD="align: right"]83[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]89[/TD]
[TD="class: xl65, align: right"]88.00[/TD]
[TD="align: right"]252[/TD]

[TD="align: right"]89[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]89[/TD]
[TD="class: xl65, align: right"]85.33[/TD]
[TD="align: right"]239[/TD]

[TD="align: right"]80[/TD]
[TD="align: right"]71[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]82[/TD]
[TD="class: xl65, align: right"]79.50[/TD]
[TD="align: right"]235[/TD]

[TD="align: right"]91[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]93[/TD]
[TD="class: xl65, align: right"]90.83[/TD]
[TD="align: right"]253[/TD]

[TD="align: right"]75[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]90[/TD]
[TD="class: xl65, align: right"]82.50[/TD]
[TD="align: right"]253[/TD]

[TD="align: right"]84[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]87[/TD]
[TD="class: xl65, align: right"]84.67[/TD]
[TD="align: right"]235[/TD]

[TD="align: right"]81[/TD]
[TD="align: right"]74[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]69[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]65[/TD]
[TD="class: xl65, align: right"]73.17[/TD]
[TD="align: right"]198[/TD]

[TD="align: right"]86[/TD]
[TD="align: right"]72[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]89[/TD]
[TD="class: xl65, align: right"]81.83[/TD]
[TD="align: right"]242[/TD]

[TD="align: right"]91[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]95[/TD]
[TD="class: xl65, align: right"]90.67[/TD]
[TD="align: right"]246[/TD]

[TD="align: right"]84[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]89[/TD]
[TD="class: xl65, align: right"]87.00[/TD]
[TD="align: right"]247[/TD]

[TD="align: right"]83[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]91[/TD]
[TD="class: xl65, align: right"]89.33[/TD]
[TD="align: right"]244[/TD]

[TD="align: right"]80[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]78[/TD]
[TD="class: xl65, align: right"]79.00[/TD]
[TD="align: right"]221[/TD]

[TD="align: right"]91[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]84[/TD]
[TD="class: xl65, align: right"]86.00[/TD]
[TD="align: right"]247[/TD]

[TD="align: right"]91[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]96[/TD]
[TD="align: right"]90[/TD]
[TD="class: xl65, align: right"]91.00[/TD]
[TD="align: right"]251[/TD]

[TD="align: right"]80[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]83[/TD]
[TD="class: xl65, align: right"]83.00[/TD]
[TD="align: right"]214[/TD]

[TD="align: right"]88[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]95[/TD]
[TD="align: right"]96[/TD]
[TD="class: xl65, align: right"]92.00[/TD]
[TD="align: right"]258[/TD]

[TD="align: right"]84[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]84[/TD]
[TD="class: xl65, align: right"]84.00[/TD]
[TD="align: right"]231[/TD]

[TD="align: right"]83[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]93[/TD]
[TD="class: xl65, align: right"]87.00[/TD]
[TD="align: right"]242[/TD]

[TD="align: right"]61[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]81[/TD]
[TD="class: xl65, align: right"]76.50[/TD]
[TD="align: right"]215[/TD]

[TD="align: right"]88[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]79[/TD]
[TD="class: xl65, align: right"]83.67[/TD]
[TD="align: right"]244[/TD]

[TD="align: right"]80[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]90[/TD]
[TD="class: xl65, align: right"]82.17[/TD]
[TD="align: right"]213[/TD]

[TD="align: right"]88[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]94[/TD]
[TD="class: xl65, align: right"]86.50[/TD]
[TD="align: right"]246[/TD]

[TD="align: right"]89[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]87[/TD]
[TD="class: xl65, align: right"]81.83[/TD]
[TD="align: right"]226[/TD]

[TD="align: right"]92[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]89[/TD]
[TD="class: xl65, align: right"]89.50[/TD]
[TD="align: right"]258[/TD]

[TD="align: right"]88[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]94[/TD]
[TD="align: right"]91[/TD]
[TD="class: xl65, align: right"]90.17[/TD]
[TD="align: right"]245[/TD]

[TD="align: right"]67[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]79[/TD]
[TD="class: xl65, align: right"]80.33[/TD]
[TD="align: right"]233[/TD]

[TD="align: right"]83[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]87[/TD]
[TD="class: xl65, align: right"]83.33[/TD]
[TD="align: right"]217[/TD]

[TD="align: right"]81[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]77[/TD]
[TD="class: xl65, align: right"]80.50[/TD]
[TD="align: right"]238[/TD]

[TD="align: right"]91[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]93[/TD]
[TD="class: xl65, align: right"]93.00[/TD]
[TD="align: right"]258[/TD]

[TD="align: right"]69[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]85[/TD]
[TD="class: xl65, align: right"]78.33[/TD]
[TD="align: right"]217[/TD]

[TD="align: right"]58[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]88[/TD]
[TD="class: xl65, align: right"]80.33[/TD]
[TD="align: right"]222[/TD]

[TD="align: right"]78[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]84[/TD]
[TD="class: xl65, align: right"]81.17[/TD]
[TD="align: right"]228[/TD]

[TD="align: right"]83[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]82[/TD]
[TD="class: xl65, align: right"]82.00[/TD]
[TD="align: right"]219[/TD]

[TD="align: right"]77[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]73[/TD]
[TD="align: right"]73[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]77[/TD]
[TD="class: xl65, align: right"]76.83[/TD]
[TD="align: right"]226[/TD]

[TD="align: right"]88[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]72[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]81[/TD]
[TD="class: xl65, align: right"]80.50[/TD]
[TD="align: right"]232[/TD]

[TD="align: right"]81[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]86[/TD]
[TD="class: xl65, align: right"]85.17[/TD]
[TD="align: right"]237[/TD]

[TD="align: right"]77[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]74[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]88[/TD]
[TD="class: xl65, align: right"]82.00[/TD]
[TD="align: right"]247[/TD]

[TD="align: right"]91[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]93[/TD]
[TD="class: xl65, align: right"]91.33[/TD]
[TD="align: right"]255[/TD]

[TD="align: right"]81[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]90[/TD]
[TD="class: xl65, align: right"]84.17[/TD]
[TD="align: right"]247[/TD]

[TD="align: right"]73[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]79[/TD]
[TD="class: xl65, align: right"]81.50[/TD]
[TD="align: right"]243[/TD]

[TD="align: right"]80[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]94[/TD]
[TD="align: right"]91[/TD]
[TD="class: xl65, align: right"]87.00[/TD]
[TD="align: right"]242[/TD]

[TD="align: right"]69[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]85[/TD]
[TD="class: xl65, align: right"]79.17[/TD]
[TD="align: right"]219[/TD]

[TD="align: right"]84[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]92[/TD]
[TD="class: xl65, align: right"]92.00[/TD]
[TD="align: right"]250[/TD]

[TD="align: right"]81[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]96[/TD]
[TD="align: right"]95[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]93[/TD]
[TD="class: xl65, align: right"]91.17[/TD]
[TD="align: right"]253[/TD]

[TD="align: right"]70[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]74[/TD]
[TD="align: right"]72[/TD]
[TD="class: xl65, align: right"]72.33[/TD]
[TD="align: right"]225[/TD]

[TD="align: right"]86[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]95[/TD]
[TD="align: right"]91[/TD]
[TD="class: xl65, align: right"]90.00[/TD]
[TD="align: right"]245[/TD]

[TD="align: right"]86[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]86[/TD]
[TD="class: xl65, align: right"]86.17[/TD]
[TD="align: right"]237[/TD]

[TD="align: right"]77[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]91[/TD]
[TD="class: xl65, align: right"]86.00[/TD]
[TD="align: right"]243[/TD]

[TD="align: right"]80[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]91[/TD]
[TD="class: xl65, align: right"]87.83[/TD]
[TD="align: right"]251[/TD]

[TD="align: right"]88[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]86[/TD]
[TD="class: xl65, align: right"]86.17[/TD]
[TD="align: right"]243[/TD]

[TD="align: right"]78[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]87[/TD]
[TD="class: xl65, align: right"]83.33[/TD]
[TD="align: right"]177[/TD]

[TD="align: right"]70[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]83[/TD]
[TD="class: xl65, align: right"]78.67[/TD]
[TD="align: right"]234[/TD]

[TD="align: right"]75[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]93[/TD]
[TD="class: xl65, align: right"]84.67[/TD]
[TD="align: right"]238[/TD]

[TD="align: right"]81[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]83[/TD]
[TD="class: xl65, align: right"]81.33[/TD]
[TD="align: right"]229[/TD]

[TD="align: right"]63[/TD]
[TD="align: right"]72[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]83[/TD]
[TD="class: xl65, align: right"]78.83[/TD]
[TD="align: right"]223[/TD]

[TD="align: right"]80[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]82[/TD]
[TD="class: xl65, align: right"]79.33[/TD]
[TD="align: right"]229[/TD]

[TD="align: right"]78[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]94[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]96[/TD]
[TD="class: xl65, align: right"]90.00[/TD]
[TD="align: right"]263[/TD]

[TD="align: right"]84[/TD]
[TD="align: right"]74[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]71[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]76[/TD]
[TD="class: xl65, align: right"]76.83[/TD]
[TD="align: right"]211[/TD]

[TD="align: right"]80[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]73[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]77[/TD]
[TD="class: xl65, align: right"]78.17[/TD]
[TD="align: right"]213[/TD]

[TD="align: right"]80[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]93[/TD]
[TD="class: xl65, align: right"]85.50[/TD]
[TD="align: right"]237[/TD]

[TD="align: right"]89[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]93[/TD]
[TD="class: xl65, align: right"]90.33[/TD]
[TD="align: right"]251[/TD]

[TD="align: right"]77[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]82[/TD]
[TD="class: xl65, align: right"]79.00[/TD]
[TD="align: right"]216[/TD]

[TD="align: right"]70[/TD]
[TD="align: right"]73[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]87[/TD]
[TD="class: xl65, align: right"]83.33[/TD]
[TD="align: right"]253[/TD]

[TD="align: right"]91[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]94[/TD]
[TD="align: right"]95[/TD]
[TD="align: right"]93[/TD]
[TD="class: xl65, align: right"]91.50[/TD]
[TD="align: right"]256[/TD]

[TD="align: right"]73[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]87[/TD]
[TD="class: xl65, align: right"]80.50[/TD]
[TD="align: right"]220[/TD]

[TD="align: right"]77[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]64[/TD]
[TD="align: right"]73[/TD]
[TD="align: right"]80[/TD]
[TD="class: xl65, align: right"]75.83[/TD]
[TD="align: right"]205[/TD]

[TD="align: right"]83[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]94[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]84[/TD]
[TD="class: xl65, align: right"]86.83[/TD]
[TD="align: right"]257[/TD]

[TD="align: right"]91[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]74[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]88[/TD]
[TD="class: xl65, align: right"]85.67[/TD]
[TD="align: right"]240[/TD]

[TD="align: right"]92[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]90[/TD]
[TD="class: xl65, align: right"]84.83[/TD]
[TD="align: right"]251[/TD]

[TD="align: right"]88[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]81[/TD]
[TD="class: xl65, align: right"]85.33[/TD]
[TD="align: right"]228[/TD]

[TD="align: right"]89[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]89[/TD]
[TD="class: xl65, align: right"]84.17[/TD]
[TD="align: right"]250[/TD]

[TD="align: right"]94[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]81[/TD]
[TD="class: xl65, align: right"]81.67[/TD]
[TD="align: right"]225[/TD]

[TD="align: right"]80[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]86[/TD]
[TD="class: xl65, align: right"]83.17[/TD]
[TD="align: right"]225[/TD]

[TD="align: right"]83[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]79[/TD]
[TD="class: xl65, align: right"]80.83[/TD]
[TD="align: right"]232[/TD]

[TD="align: right"]89[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]93[/TD]
[TD="class: xl65, align: right"]87.50[/TD]
[TD="align: right"]243[/TD]

[TD="align: right"]75[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]78[/TD]
[TD="class: xl65, align: right"]77.00[/TD]
[TD="align: right"]216[/TD]

[TD="align: right"]86[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]90[/TD]
[TD="class: xl65, align: right"]88.33[/TD]
[TD="align: right"]254[/TD]

[TD="align: right"]70[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]79[/TD]
[TD="class: xl65, align: right"]79.17[/TD]
[TD="align: right"]231[/TD]

[TD="align: right"]88[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]94[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]88[/TD]
[TD="class: xl65, align: right"]89.83[/TD]
[TD="align: right"]261[/TD]

[TD="align: right"]77[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]87[/TD]
[TD="class: xl65, align: right"]78.33[/TD]
[TD="align: right"]223[/TD]

[TD="align: right"]86[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]86[/TD]
[TD="class: xl65, align: right"]83.17[/TD]
[TD="align: right"]224[/TD]

[TD="align: right"]80[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]90[/TD]
[TD="class: xl65, align: right"]82.67[/TD]
[TD="align: right"]241[/TD]

[TD="align: right"]92[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]90[/TD]
[TD="class: xl65, align: right"]90.83[/TD]
[TD="align: right"]246[/TD]

</tbody>
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Sort by date Sort by votes
You could instead use LINEST to do the fit:

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]
A​
[/td][td="bgcolor:#C0C0C0"]
B​
[/td][td="bgcolor:#C0C0C0"]
C​
[/td][td="bgcolor:#C0C0C0"]
D​
[/td][td="bgcolor:#C0C0C0"]
E​
[/td][td="bgcolor:#C0C0C0"]
F​
[/td][td="bgcolor:#C0C0C0"]
G​
[/td][td="bgcolor:#C0C0C0"]
H​
[/td][td="bgcolor:#C0C0C0"]
I​
[/td][td="bgcolor:#C0C0C0"]
J​
[/td][td="bgcolor:#C0C0C0"]
K​
[/td][/tr][tr][td="bgcolor:#C0C0C0"]
1​
[/td][td="bgcolor:#E5E5E5"]
215.4606​
[/td][td="bgcolor:#E5E5E5"]
-35.4996​
[/td][td="bgcolor:#E5E5E5"]
-34.8353​
[/td][td="bgcolor:#E5E5E5"]
-35.5847​
[/td][td="bgcolor:#E5E5E5"]
-35.3733​
[/td][td="bgcolor:#E5E5E5"]
-35.8677​
[/td][td="bgcolor:#E5E5E5"]
-35.5322​
[/td][td][/td][td][/td][td][/td][td]A1:G5: {=LINEST(H9:H187, A9:G187, FALSE, TRUE)}[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
2​
[/td][td="bgcolor:#E5E5E5"]
290.4474​
[/td][td="bgcolor:#E5E5E5"]
48.41016​
[/td][td="bgcolor:#E5E5E5"]
48.38845​
[/td][td="bgcolor:#E5E5E5"]
48.43178​
[/td][td="bgcolor:#E5E5E5"]
48.39584​
[/td][td="bgcolor:#E5E5E5"]
48.40968​
[/td][td="bgcolor:#E5E5E5"]
48.41424​
[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
3​
[/td][td="bgcolor:#66FFFF"]
0.998177​
[/td][td="bgcolor:#E5E5E5"]
10.27541​
[/td][td="bgcolor:#E5E5E5"]
#N/A​
[/td][td="bgcolor:#E5E5E5"]
#N/A​
[/td][td="bgcolor:#E5E5E5"]
#N/A​
[/td][td="bgcolor:#E5E5E5"]
#N/A​
[/td][td="bgcolor:#E5E5E5"]
#N/A​
[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
4​
[/td][td="bgcolor:#E5E5E5"]
13450.74​
[/td][td="bgcolor:#E5E5E5"]
172​
[/td][td="bgcolor:#E5E5E5"]
#N/A​
[/td][td="bgcolor:#E5E5E5"]
#N/A​
[/td][td="bgcolor:#E5E5E5"]
#N/A​
[/td][td="bgcolor:#E5E5E5"]
#N/A​
[/td][td="bgcolor:#E5E5E5"]
#N/A​
[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
5​
[/td][td="bgcolor:#E5E5E5"]
9941292​
[/td][td="bgcolor:#E5E5E5"]
18160.46​
[/td][td="bgcolor:#E5E5E5"]
#N/A​
[/td][td="bgcolor:#E5E5E5"]
#N/A​
[/td][td="bgcolor:#E5E5E5"]
#N/A​
[/td][td="bgcolor:#E5E5E5"]
#N/A​
[/td][td="bgcolor:#E5E5E5"]
#N/A​
[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
6​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
7​
[/td][td="bgcolor:#E5E5E5"]
-35.5322​
[/td][td="bgcolor:#E5E5E5"]
-35.8677​
[/td][td="bgcolor:#E5E5E5"]
-35.3733​
[/td][td="bgcolor:#E5E5E5"]
-35.5847​
[/td][td="bgcolor:#E5E5E5"]
-34.8353​
[/td][td="bgcolor:#E5E5E5"]
-35.4996​
[/td][td="bgcolor:#E5E5E5"]
215.4606​
[/td][td][/td][td][/td][td][/td][td]A7: =INDEX($A$1:$G$1, 8 - COLUMNS($A7:A7))[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
8​
[/td][td="bgcolor:#F3F3F3"]
Grade1​
[/td][td="bgcolor:#F3F3F3"]
Grade 2​
[/td][td="bgcolor:#F3F3F3"]
Grade3​
[/td][td="bgcolor:#F3F3F3"]
Grade4​
[/td][td="bgcolor:#F3F3F3"]
Grade5​
[/td][td="bgcolor:#F3F3F3"]
Grade6​
[/td][td="bgcolor:#F3F3F3"]
Grade7​
[/td][td="bgcolor:#F3F3F3"]
predicted?​
[/td][td="bgcolor:#F3F3F3"]
Fit​
[/td][td="bgcolor:#F3F3F3"]
Error​
[/td][td="bgcolor:#F3F3F3"]
​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
9​
[/td][td]
83​
[/td][td]
80​
[/td][td]
86​
[/td][td]
84​
[/td][td]
84​
[/td][td]
88​
[/td][td]
84.17​
[/td][td]
226​
[/td][td="bgcolor:#E5E5E5"]
235.4​
[/td][td="bgcolor:#E5E5E5"]
9.4​
[/td][td]I9: =SUMPRODUCT($A$7:$G$7, A9:G9)[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
10​
[/td][td]
83​
[/td][td]
90​
[/td][td]
83​
[/td][td]
84​
[/td][td]
88​
[/td][td]
85​
[/td][td]
85.50​
[/td][td]
232​
[/td][td="bgcolor:#E5E5E5"]
236.5​
[/td][td="bgcolor:#E5E5E5"]
4.5​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
11​
[/td][td]
83​
[/td][td]
85​
[/td][td]
76​
[/td][td]
81​
[/td][td]
76​
[/td][td]
89​
[/td][td]
81.67​
[/td][td]
202​
[/td][td="bgcolor:#E5E5E5"]
221.1​
[/td][td="bgcolor:#E5E5E5"]
19.1​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
12​
[/td][td]
89​
[/td][td]
85​
[/td][td]
89​
[/td][td]
87​
[/td][td]
83​
[/td][td]
91​
[/td][td]
87.33​
[/td][td]
230​
[/td][td="bgcolor:#E5E5E5"]
239.2​
[/td][td="bgcolor:#E5E5E5"]
9.2​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
13​
[/td][td]
67​
[/td][td]
83​
[/td][td]
86​
[/td][td]
82​
[/td][td]
87​
[/td][td]
79​
[/td][td]
80.67​
[/td][td]
219​
[/td][td="bgcolor:#E5E5E5"]
228.3​
[/td][td="bgcolor:#E5E5E5"]
9.3​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
14​
[/td][td]
70​
[/td][td]
72​
[/td][td]
76​
[/td][td]
63​
[/td][td]
77​
[/td][td]
75​
[/td][td]
72.17​
[/td][td]
204​
[/td][td="bgcolor:#E5E5E5"]
205.1​
[/td][td="bgcolor:#E5E5E5"]
1.1​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
15​
[/td][td]
75​
[/td][td]
75​
[/td][td]
80​
[/td][td]
84​
[/td][td]
84​
[/td][td]
83​
[/td][td]
80.17​
[/td][td]
225​
[/td][td="bgcolor:#E5E5E5"]
226.9​
[/td][td="bgcolor:#E5E5E5"]
1.9​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
180​
[/td][td]
75​
[/td][td]
78​
[/td][td]
70​
[/td][td]
80​
[/td][td]
81​
[/td][td]
78​
[/td][td]
77.00​
[/td][td]
216​
[/td][td="bgcolor:#E5E5E5"]
214.3​
[/td][td="bgcolor:#E5E5E5"]
(1.7)​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
181​
[/td][td]
86​
[/td][td]
86​
[/td][td]
88​
[/td][td]
88​
[/td][td]
92​
[/td][td]
90​
[/td][td]
88.33​
[/td][td]
254​
[/td][td="bgcolor:#E5E5E5"]
247.1​
[/td][td="bgcolor:#E5E5E5"]
(6.9)​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
182​
[/td][td]
70​
[/td][td]
78​
[/td][td]
78​
[/td][td]
88​
[/td][td]
82​
[/td][td]
79​
[/td][td]
79.17​
[/td][td]
231​
[/td][td="bgcolor:#E5E5E5"]
221.5​
[/td][td="bgcolor:#E5E5E5"]
(9.5)​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
183​
[/td][td]
88​
[/td][td]
90​
[/td][td]
87​
[/td][td]
94​
[/td][td]
92​
[/td][td]
88​
[/td][td]
89.83​
[/td][td]
261​
[/td][td="bgcolor:#E5E5E5"]
248.6​
[/td][td="bgcolor:#E5E5E5"]
(12.4)​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
184​
[/td][td]
77​
[/td][td]
67​
[/td][td]
86​
[/td][td]
76​
[/td][td]
77​
[/td][td]
87​
[/td][td]
78.33​
[/td][td]
223​
[/td][td="bgcolor:#E5E5E5"]
220.6​
[/td][td="bgcolor:#E5E5E5"]
(2.4)​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
185​
[/td][td]
86​
[/td][td]
90​
[/td][td]
76​
[/td][td]
81​
[/td][td]
80​
[/td][td]
86​
[/td][td]
83.17​
[/td][td]
224​
[/td][td="bgcolor:#E5E5E5"]
225.5​
[/td][td="bgcolor:#E5E5E5"]
1.5​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
186​
[/td][td]
80​
[/td][td]
75​
[/td][td]
82​
[/td][td]
81​
[/td][td]
88​
[/td][td]
90​
[/td][td]
82.67​
[/td][td]
241​
[/td][td="bgcolor:#E5E5E5"]
236.0​
[/td][td="bgcolor:#E5E5E5"]
(5.0)​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
187​
[/td][td]
92​
[/td][td]
92​
[/td][td]
90​
[/td][td]
90​
[/td][td]
91​
[/td][td]
90​
[/td][td]
90.83​
[/td][td]
246​
[/td][td="bgcolor:#E5E5E5"]
250.3​
[/td][td="bgcolor:#E5E5E5"]
4.3​
[/td][td][/td][/tr]
[/table]
 
Upvote 0
Thanks so much for this. It's an interesting approach. How can I tell if any of the cols of grades (1-7) are good predictors? I was looking for statistical significance.
 
Upvote 0
Reckon you could use =CORREL(grade, predicted)
 
Upvote 0
You must log in or register to reply here.

Similar threads

K
  • Question Question
conditional formatting question
Replies
2
Views
585
kerm007
K
T
  • Solved
Add formula only if sheet exists?
Replies
3
Views
228
Peter_SSs
Peter_SSs
O
  • Question Question
Add numbers backwards cumulatively until certain threshold is found
Replies
3
Views
579
KRice
K
N
  • Solved
Total of marks with the specific conditions
2
Replies
11
Views
402
Eric W
Eric W
J
  • Solved
Excel Formula To Average all numbers in one month from list of dates
Replies
2
Views
778
Dave Patton
D

Forum statistics

Threads
1,223,903
Messages
6,175,289
Members
452,631
Latest member
a_potato

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