Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 macro

image text in transcribed

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 macro to integrate a series of 10 (x.y) data points representing 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 with the first x value in cell A1, and the first y value in cell B1, and the remaining data points organized 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 no empty spreadsheet cells or irregular entries (letters and such) among the data set. To approximate the integral, calculate and sum the areas of rectangles of area A=yi * deltaX where yi is the right hand boundary of each interval bounded by two x-values (see posted pictures of algorithm). deltaX is the distance between two adjacent x-values. Output the value of the integral via a message box after the integration

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 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions