Batch Spreadsheet for C Programmers -
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
a0:d0 = { "grade", "score", "avg", "stdev"};
mean=avg(b1:b5); c1=mean; d1=stdev(b1:b5);
a1=80+15*(b1-mean)/$d$1; copy a2:a5 a1:a4;
b1:b5 = { 57, 67, 92, 87, 76 }; eval;
print symbols values formulas pointers;
Output:
mean = avg(B1:B5) = 75.8 (symbols)
A B C D
0 grade score avg stdev
1 60.29 57.00 75.80 14.31
2 70.77 67.00
3 96.98 92.00 (values)
4 91.74 87.00
5 80.21 76.00