Question

please use in excel vba

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:

1. Begin with an initial estimate x.

2. Divide the number by the estimate (i.e., a/x), to get a new estimate

3. Average the original estimate and the new estimate (i.e., (x + a/x)/2) to get a new estimate

4. 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 ….Loop While loop in the program.

Answer 1

Hopefully all yours doubt will clear if you have left with any doubt please let me know in comment. I will try my best to resolve that.

Here I am posting code and screenshot of output.

Ans 1) :-

Code :-

#include <sstream>
#include <string>
#include <iostream>
using namespace std;

// square root using approximation function
double square(int n)
{
// initial guess
int A = 1;
// first approximation
double B = (A + (n/A))/2;
// loop for next 9 better approximation
for(int i=0;i<9;i++)
{
B = (B + (n/B))/2;
}
// return square root calculated by 10th better approximation
return B;
}

int main()
{
// declare variable
int num;
// enter number
cout<<"Enter a number : ";
cin>>num;
// call function
double sqrt = square(num);
//print result
cout<<"Square root of "<<num<<" is : "<<sqrt;
   return 0;
}

Screenshot of output :-

Ans 2) :-

Code :-

#include <fstream>>
#include <string>
#include <iostream>
#include<cmath>
using namespace std;

// square root using approximation function
double square(int n)
{
// initial guess
int A = 1;
// first approximation
double B = (A + (n/A))/2;
// loop for next 9 better approximation
for(int i=0;i<9;i++)
{
B = (B + (n/B))/2;
}
// return square root calculated by 10th better approximation
return B;
}

int main()
{
// declare variable
double sqrt1,sqrt2,diff;
char data[100];
int num = 0;
// Declare variable ifile and outFile that represents input and output stream respectively
ifstream ifile;
ofstream outFile;
//open text file input.txt
ifile.open ("input.txt");
//open text file output.txt
outFile.open("output.txt");
// get file content line by line
while (ifile.getline(data, 100 ,' '))
{
// take each chat number and covert it into integer
for (int i = 0; data[i] != '\0'; i++)
{
num = 10 * num + (data[i] - '0');
}
// call function
sqrt1 = square(num);
// calculate square root using sqrt function
sqrt2 = sqrt(num);
// calculate difference
diff = sqrt1 - sqrt2;
// write results in output.txt file
outFile <<num<<" "<<sqrt1<<" "<<sqrt2<<" "<<diff<< endl;
num = 0;
}
// close both files
ifile.close();
outFile.close();
   return 0;
}

Screenshot of output.txt file :-