Question

Please use excel and VBA

The natural logarithm can be expressed as a Taylor series of the following form 1. Write a VBA program to calculate the first

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Sub seriesformula()
' write x value in A2 cell of excel sheet
Range("A2").Select
x = ActiveCell.Value
Sum = 0
For k = 1 To 50
Sum = Sum + (1 / k) * (((x - 1) / x)) ^ k
Next k
' you can see your result in B2 cell of excel sheet
Range("B2").Select
ActiveCell.Value = Sum
End Sub

' to cehck result just write =Ln(x) in any cell of excel sheet
' here x is your input value

iesformula () Sub ser write x value in A2 cell of excel sheet Range (A2) . Select xActiveCel1.Value Sum0 For k = 1 To 50 sinput value output 10 2.301796253 exact value 2.302585093

Add a comment
Know the answer?
Add Answer to:
The natural logarithm can be expressed as a Taylor series of the following form 1. Write a VBA pr...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Problem #5 Equation 1 is the infinite Taylor series expansion of ln(1 + x), where In is the natur...

    Problem #5 Equation 1 is the infinite Taylor series expansion of ln(1 + x), where In is the natural logarithm: 5 (-1)k+1 Eqn. 1 Σ(-1)k+1 k In(1 + x) Eqn. 2 Equation 2 is the finite version that calculates an approximation for ln(1 + x). Instead of letting k go to infinity, it stops summing once k reaches some fixed value N. Task Develop a program that can compute ln(1 +x). Have it first ask the user to enter x...

  • Write VBA functions to calculate sin (x) using the Maclaurin arcsine series, and compare the values...

    Write VBA functions to calculate sin (x) using the Maclaurin arcsine series, and compare the values for sin-1(x) from your program to those given by the Excel spreadsheet function ASIN(x). The Maclaurin arcsine expansion is given by x 3x 6 40 (2n)! sin1(x)-2((2n+1) Note: This function by definition is only defined for-1 SxS1. When you write the code for calculating it, you will need to include code that assigns a value to it that reflects it is undefined for values...

  • Problem #5 Equation 1 is the infinite Taylor series expansion of ln(1 + x), where In...

    Problem #5 Equation 1 is the infinite Taylor series expansion of ln(1 + x), where In is the natural logarithm: 5 (-1)k+1 Eqn. 1 Σ(-1)k+1 k In(1 + x) Eqn. 2 Equation 2 is the finite version that calculates an approximation for ln(1 + x). Instead of letting k go to infinity, it stops summing once k reaches some fixed value N. Task Develop a program that can compute ln(1 +x). Have it first ask the user to enter x...

  • Problem 5 xx The Taylor series expansion for sin(x) is sin(x) = x -H + E-E+...

    Problem 5 xx The Taylor series expansion for sin(x) is sin(x) = x -H + E-E+ = o E- (-1) . 2n +1 no (2n+1)! !57 where x is in radians. Write a MATLAB program that determines sin(x) using the Taylor series expansion. The program asks the user to type a value for an angle in degrees. Then the program uses a while loop for adding the terms of the Taylor series. If an n is the nth term in...

  • The following function computes by summing the Taylor series expansion to n terms. Write a program...

    The following function computes by summing the Taylor series expansion to n terms. Write a program to print a table of using both this function and the exp() function from the math library, for x = 0 to 1 in steps of 0.1. The program should ask the user what value of n to use. (PLEASE WRITE IN PYTHON) def taylor(x, n): sum = 1 term = 1 for i in range(1, n): term = term * x / i...

  • can someone please help me out with this? i have to write this in vba excel....

    can someone please help me out with this? i have to write this in vba excel. Question 2: (40 Pointsy) The total cnerey, E. ofa movins hint i comual to energy, E, of a moving object is equal to the sum of its kinetic and potential energieS: where m is the mass (in kg) v is the velocity (in m/s) h is the height of the object (in m) g is the acceleration due to gravity (9.81 m/s') 5 m/s...

  • MATLAB ONLY!! PLEASE WRITE IN COMPUTER SO I CAN COPY PASTE!!! ANSWER COMPLETELY, USE FOR LOOPS....

    MATLAB ONLY!! PLEASE WRITE IN COMPUTER SO I CAN COPY PASTE!!! ANSWER COMPLETELY, USE FOR LOOPS. THE PROGRAM TO BE MODIFIED IS THE NEXT ONE: clc clear % Approximate the value of e ^ x using the Taylor Series x = input( 'Enter the value of x for e^x. x = ' ); t = input( 'Enter the amount of desired terms. t = ' ); i = 1; e_taylor = 0; % initializing the variable for the accumulator while...

  • 1) Write and test a well-commented Python function, called “myexp” that approximates the value for the...

    1) Write and test a well-commented Python function, called “myexp” that approximates the value for the function ?(?) = ? ? . This function can be approximated by a Taylor series ? ? ≈ ∑ ? ? ?! ∞ ?=0 , and recall that the factorial function is given by the recursive relationship ?! = ? (? − 1)!, ?ℎ??? ? ∈ ??? ≥ 0, ??? 0! = 1 1. You will need to write your own factorial function, and...

  • ​​​​​​ C Programming Language The operation of multiplication for positive integers can be expressed as: A.B=2...

    ​​​​​​ C Programming Language The operation of multiplication for positive integers can be expressed as: A.B=2 1 A for (A+[A.(B-1)] B=1 for B>1 Task 1 (for 1 point) is to write a program that will read and print on the screen the values of two integers (A and B) given by user as command line parameters. Task 2 (for 1 point) is to write a program that will calculate the result of the multiplication of two integers. It should print...

  • In MATLAB The value of cos(x) can be approximated using a Maclaurin series + +... cos(x)=1-1...

    In MATLAB The value of cos(x) can be approximated using a Maclaurin series + +... cos(x)=1-1 2! 4! 6! Which can be expressed compactly as cos(x) = {(-1)+7 (2(k-1))! 00 2(k-1) k-1 Write Matlab code using a while loop that calculates cos(2) with 5 terms of Maclaurin series. Compare the value with the one calculated with a built-in function cos (2) in Matlab. The following is an expected output from your code: Using the Maclaurin series cos( 2.0) with 5...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT