Doğrusal olmayan regresyonda asimptotik yöntemle bootstrap örneklemesi
































































44
Application.Run “ATPVBAEN.XLA!Random”, ActiveSheet.Range(“B” & sim & “:” & “B” & sim + 13), 1 _
, 14, 7, , ActiveSheet.Range(“f22: g35”) sim = sim + 19 kalol = kalol + 19 Range(“K” & start).Select ActiveCell.FormulaR1C1 = “500” Range(“K” & start + 2).Select ActiveCell.FormulaR1C1 = “0.0001” SolverOk SetCell:=”E” & sol, MaxMinVal:=2, ValueOf:=”0″, ByChange:=”K” & start & “,” & “K” & start + 2 SolverSolve userFinish:=True start = start + 19 sol = sol + 19 Next i Sheets(“sum”).Rows(“2:65536”).Delete For j = 1 To i Sheets(“sum”).Range(“a” & j + 1).Value = j Sheets(“sum”).Range(“b” & j + 1).Value = Range(“I” & say).Value Sheets(“sum”).Range(“c” & j + 1).Value = Range(“j” & say).Value say = say + 19 Next j ‘Sheets(“SUM”).Select End Sub



54. SAYFAYA BENZER SAYFALAR

Kesikli zamanlı risk modelinde bağımlı risklerin dağılımları - Sayfa 61
Range("H12").Select Range(Selection, Selection.End(xlDown)).Select Application.Run "ATPVBAEN.XLA!Fourier", ActiveSheet.Range(Cells(12, 8), Cells(12 + n - 1, 8)), _ ActiveSheet.Range("J12"), False, False Sheets("Sheet2").Select Range("H12").Select Range(Selection, Selection.End(xlDown)).Select Application.Run "ATPVBAEN.XLA!Fourier", ActiveSheet.Range(Cells(12, 8), Cells(12 + n - 1, 8)), _ Active...
Kesikli zamanlı risk modelinde bağımlı risklerin dağılımları - Sayfa 65
Application.Run "ATPVBAEN.XLA!Fourier", ActiveSheet.Range(Cells(12, 8), Cells(12 + n - 1, 8)), _ ActiveSheet.Range("J12"), False, False Sheets("Sheet2").Select Range("H12").Select Range(Selection, Selection.End(xlDown)).Select Application.Run "ATPVBAEN.XLA!Fourier", ActiveSheet.Range(Cells(12, 8), Cells(12 + n - 1, 8)), _ ActiveSheet.Range("J12"), False, False Sheets("Sheet1").Select For i = 0...

54. SAYFADAKI ANAHTAR KELIMELER

applicationrun
value
select
next
rangej
kalol


54. SAYFA ICERIGI

44
Application.Run “ATPVBAEN.XLA!Random”, ActiveSheet.Range(“B” & sim & “:” & “B” & sim + 13), 1 _
, 14, 7, , ActiveSheet.Range(“f22: g35”) sim = sim + 19 kalol = kalol + 19 Range(“K” & start).Select ActiveCell.FormulaR1C1 = “500” Range(“K” & start + 2).Select ActiveCell.FormulaR1C1 = “0.0001” SolverOk SetCell:=”E” & sol, MaxMinVal:=2, ValueOf:=”0″, ByChange:=”K” & start & “,” & “K” & start + 2 SolverSolve userFinish:=True start = start + 19 sol = sol + 19 Next i Sheets(“sum”).Rows(“2:65536”).Delete For j = 1 To i Sheets(“sum”).Range(“a” & j + 1).Value = j Sheets(“sum”).Range(“b” & j + 1).Value = Range(“I” & say).Value Sheets(“sum”).Range(“c” & j + 1).Value = Range(“j” & say).Value say = say + 19 Next j ‘Sheets(“SUM”).Select End Sub

İlgili Kaynaklar







single.php