Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

this should be done on Excel using VBA. The picture attached has all the details provided. Please take a screenshot of the codes then attach

this should be done on Excel using VBA. The picture attached has all the details provided. Please take a screenshot of the codes then attach it here. Thank you!image text in transcribed

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 Allx 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 . Writing comments to document programs Lines of comments should about equal or exceed lines of code (note, below is not a working program but an example of comments) This macro will write Hellow World in the first 10 diagonal cells of a spreadsheet Last revision 1-14-2019, P. Pfromm Option explicit Sub myhello() Set up variables: k is a loop counter, etc. etc.... This loop runs over the rows here the cell is filled with Hello World Dim.. For k 1 to n Cells (I,k) Hello World Next k This is output to the sheet End sub

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Mastering Influxdb Database A Comprehensive Guide To Learn Influxdb Database

Authors: Cybellium Ltd ,Kris Hermans

1st Edition

B0CNGGWL7B, 979-8867766450

More Books

Students also viewed these Databases questions