Answered step by step
Verified Expert Solution
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 widthin 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 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; If the coefficients a to 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 shehe 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 and agree to repay it in annual payments at an interest rate of The formula to compute the annual payment is: Write a program to compute A Test with and an interest rate of i Interest rate and loan amount are your inputs; interest rate should be requested as a percentage. Compute results and 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 andaverage method. To find the square root of the number a: Begin with an initial estimate Divide the number by the estimate ie to get a new estimate Average the original estimate and the new estimate ie to get a new estimate Return to step Use this method to calculate the square root of a number. The value of the initial estimate must be greater than zero. Please use Do While Loop in the program.
Write your name on your Excel sheet otherwise it will not be graded.
Write a program that reads in the length and widthin 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
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;
If the coefficients a to 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 shehe 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 and agree to repay it in annual payments at an interest rate of The
formula to compute the annual payment is:
Write a program to compute A Test with and an interest rate of i
Interest rate and loan amount are your inputs; interest rate should be requested as a
percentage. Compute results and 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 andaverage method. To find the square root of the number a:
Begin with an initial estimate
Divide the number by the estimate ie to get a new estimate
Average the original estimate and the new estimate ie to get a new estimate
Return to step
Use this method to calculate the square root of a number. The value of the initial estimate
must be greater than zero. Please use Do While Loop in the program.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started