چهارشنبه, ۲۶ اسفند ۱۳۹۴، ۰۶:۴۲ ب.ظ
[x,t] = simplefit_dataset;
net = feedforwardnet(10);
net = train(net,x,t);
y = net(x);
errors = abs(y-t);
reg = regression(t,y)
MSE = mean(errors.^2)
mad = mad(errors)
RMSE = sqrt(MSE)
p =(errors *100./x);
p(~isfinite(p))=0;
MAPE = sum(p)/size(x,2)
http://www.aparat.com/v/oeKEg
>> x1 = [11 21 44 100 19 17 30]
x1 =
11 21 44 100 19 17 30
%---------------------------------------
[y1,PS] = mapminmax(x1,0,1)% Normalize [0,1]
y1 =
0 0.1124 0.3708 1.0000 0.0899 0.0674 0.2135
%---------------------------------------
>> x1_again = mapminmax('reverse',y1,PS)
x1_again =
11 21 44 100 19 17 30
Sub compute()
Dim cont As Integer
Dim start As Integer
start = 9
For j = 2 To 8400
cont = 0
For i = start To start + 7
If Sheets("A").Cells(i, j) > 0 Then
cont = cont + 1
End If
Next i
Sheets("B").Cells(2, j) = cont
Next j
End Sub