Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write your name on your Excel sheet otherwise it will not be graded. Write a program that reads in the length and width ( in

Write your name on your Excel sheet otherwise it will not be graded.
Write a program that reads in the length and width(in meters) of a rectangular yard and the
length and width of a rectangular house in the yard. Your program should compute and
print the time required to cut the grass at a rate of 2m2s.
There are standard equations for calculating the heat capacity of a gas at specified temperature.
One common heat capacity equation is a third order polynomial as follows;
C=a+bT+cT2+dT3
If the coefficients a to d are known for a particular gas, you can calculate the heat capacity.
Write a VBA function to calculate the heat capacity and write a sub procedure to test your
function. Please ask the user to enter the number of gases she/he wants to calculate the heat
capacity and write your code using FOR NEXT loop. Please let the user know that the
temperature should be entered in Celcius Degrees. Please use double precision variables.
Outputs should be written to Excel as shown below. Use VBA to solve following questions. Create different modules for each question.Your Excel sheets where you will print your outputs should be neat. If your program is not user friendly, it will not be graded.Economic formulas are available to compute annual payment for loans. Suppose that you borrow
an amount of money P and agree to repay it in n annual payments at an interest rate of i. The
formula to compute the annual payment A is:
A=Pi(1+i)n(1+i)n-1
Write a program to compute A. Test with P=55000TL and an interest rate of %6.6(i=0.066).
Interest rate and loan amount are your inputs; interest rate should be requested as a
percentage. Compute results n=1,2,3,4, and 5 and display the results as a table as shown
below. Titles should be bold. You are required to use a Do Until loop in the program. You
will not get any grade if you program it without a loop.
A simple yet efficient method to calculate the square root of a number is variously called the
divide- and-average method. To find the square root of the number a:
Begin with an initial estimate x.
Divide the number by the estimate (i.e.,ax), to get a new estimate
Average the original estimate and the new estimate (i.e.,x+ax2 to get a new estimate
Return to step 2.
Use this method to calculate the square root of a number. The value of the initial estimate x
must be greater than zero. Please use Do While Loop in the program.
image text in transcribed

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

Students also viewed these Databases questions