Working with Spreadsheets

purpose:To get familiar with electronic spreadsheets by using them in some simple applications.
equipment:Computer with EXCEL software.

procedures:
 Our instructor gave a quick introduction on how to use the program excel on a computer should us how to use the basic tools to work on a spreadsheet we where given the equation f(x) = A sin(Bx + C). we where instructed to set  up a spreadsheet and find the values of this equation.



part 1
       Their was values given also they where A = 5, B = 3 and  C = π/3shown on figure 1 shows a which is the amplitude,b the frequency, and c the phase.

fig 1


part 2
The next step on this lab  was to enter our values for x (radians) into the column D. There were 100 values of x to calculate, from 0 to 10 in intervals of 0.1 radians. This was done quite easily by entering our first two numbers (0 and 0.1), proceeding to use the copy feature in excel to create our table of values all the way to 10

then we plugged in the values in the function that was given to us in our instructions ( f(x) = A sin(Bx + C)). the lines where given $ for the constant before and after each column header so all our values would remain the same but the (x) values would change the 100 times.

from doing this spread sheet we where able to  obtained a table of x and y values for our function. In order to see how the function behaved, the table of x and y values were copied and pasted into the graphical analysis software. The curve fit was set to be the graph of a sin function, and the values of A, B, and C all matched the coefficients that were entered in this lab excel originally. The only difference was the rounding off of C (π/3).

 

in this lab we learned how to use excel to insert data or functions or gathering info and to do multiple calculations at once saving us some time . it be to much work to do all the work  by hand so that's what this lab helps us how to master excel so the next upcoming labs we know how to input our data and save our self some time.