Dirac Delta Function in Excel Full Tutorial ( Nepali )

Follow our Facebook page
https://www.facebook.com/groups/nayasoch/?ref=bookmarks

Find the Tutorial on plotting Graph of Dirac Delta function with help of Excel on varied condition. Homework of Hari Sir from CDP, Kirtipur

Formula
!--Copy from Below Donot include This Line


Sub Sagar()
Worksheets("Graph3").Activate
' Macro2 Macro
'

'Dim i As Double, j As Long
j = 1
For i = 0.01 To 1 Step 0.01
Sheets("Graph3").Range("G3").FormulaR1C1 = i
Sheets("Graph3").Range("G1:H1").Select
Selection.Copy
Sheets("Graph3").Range("E" & j & ":F" & j).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
j = j + 1
Next i
ActiveWindow.ScrollRow = 1
End Sub
!--End HereDonot include This Line --



For value of x(one), if your roll no is for eg 89 , then multiply it with 0.01 and result no will be 0.89. Thus your x(one) will be 0.89....for x(two) you can assume any value.
1) For x = x' ,
It would be 0.89
2) For X ≠ x' ,
Take x(one) = 0.89 and x(two) = any value between 0.1 and 0.9
3) For C=14 and C =95,
Take x(one) = 0.01-0.09 , x(two) = 0.8 ( which would remain constant )
4) For Integration
As it involves only one x , so x = 0.8
5) For Innovative
1) Excluding
a = 0
b = 0.79
x = 0.80
and
II)
a = 0.81
b = 1.00
x = 0.8
2) Including
a = 0.79
b = 0.81
x = 0.80