(Solved) : Hi Need Help Writing Program S Easy Beginner Someone Help Thank Much Write Macro Integrate Q44034377 . . .
HI, I need help writing this program. It’s not easy to me as abeginner. Can someone help? thank you so much.
Write a macro to integrate a series of 10 (x.y) data pointsrepresenting an unknown function y=f(x).
Show a button to run your macro
Write comments (see below for examples)
Assume there are ten x/y pairs in the spreadsheet, starting withthe first x value in cell A1, and
the first y value in cell B1, and the remaining data pointsorganized vertically downward, with all
x-values in column A and y values in column B.
The x-values are equidistant
All x and y values are equal or larger than zero. There are noempty spreadsheet cells or
irregular entries (letters and such) among the data set.
To approximate the integral, calculate and sum the areas ofrectangles of area A=yi * deltaX
where yi is the right hand boundary of each interval bounded by twox-values (see posted
pictures of algorithm). deltaX is the distance between two adjacentx-values.
Output the value of the integral via a message box after theintegration
for excel VBA
Unknown function start Step =1 gold-z xold so Slope – (x and step (Grow-goldt slufe Inow to spread shee (Yuld = y new xolda xoidt stop int_range In rue Each plece enel Show transcribed image text Unknown function start Step =1 gold-z xold so Slope – (x and step (Grow-goldt slufe Inow to spread shee (Yuld = y new xolda xoidt stop int_range In rue Each plece enel
Expert Answer
Answer to HI, I need help writing this program. It’s not easy to me as a beginner. Can someone help? thank you so much. Write a ma…
OR