1. Task 1: Plot X and X^2
Type 'x' and 'x^2' as the names of the two columns. Then type '1' as the starting value
your mouse to drag (Press ctrl on your keyboard when you drag it) the
right bottom corner of the cell until 16. So you 'autofill' the cells
with numbers of 1-16.
start autofill the column of 'X^2'. Select the first cell, and type the
equation in the cell or in the function block above, then press 'Enter'
on your keyboard.
the first result is done, drag it to autofill all the corresponding
'X^2'. This time, you don't need to press 'Ctrl'. You should see the
Go to 'Insert', insert a plot panel 'Line with Markers'.
click the empty area of the plot panel, go to 'select data', then click
the marked button below and use your mouse to select the column of
'Enter' to plot the data. Click the 'Cross Sign' on the top right of
the plot panel, check the options shown in the figure below. Change the corresponding Axis titles and the title for the figure.
2. Task 2: Plot sinx and cosx. In
this task, you will create a column of data called 'degree', then use
excel to calculate and autofill the 'Radian', the 'Sinx', and the
'Cosx' of the degrees.
Autofill the degree first. You noticed
that the increment of the steps are 10 degrees. You need to change the
'autofill' properties in the following options: Home-Fill-Series.
Change the 'Step Value' to 10, 'Stop Value' to 360.
Then autofill the radians. The equation to acquire the radians are:
Autofill Cosx and Sinx use the similar method. The only differences are the functions:
Insert two figures and plot the Sinx and Cosx in the two separate figures.
Make sure the axis label is in the middle. See instructions below to do this:
Change the Axis titles and the figure titles.
3. Task 3: Plot the trajectory of the Cannon problem.
Create a column for 'delta t'. Notice the step size is 0.1 now, use the method mentioned above to change the step size.
Autofill column 'h' and column 'x', which are the height and the horizontal travel distance of the ball.
example functions can be found below. Note that the '$ Sign' is
used to freeze the constant from being changed when you doing the
autofill. (Do not directly type what I had in the 'function block'. The
location of your constant for '35 degrees', '10 m/s', and '9.81 m/s/s'
probably are different).
'RADIANS()' is the built-in function to convert 'degrees' into 'radians'.
Then autofill the horizontal 'travel distance':
Plot h and x in one plot to show the trajectory:
4. Task 4: Change the initial degree, autofill all the data and plot them in the same figure: ('t' is created/autofilled first):
Plot 'x' and 'y' using the functions shown in the following figures:
Plot multiple lines in one figure by adding new series. Like this:
Complete all the tasks above in ONE excel file. Use different worksheets to separate these tasks.
Send your excel file (along with your HW2) to firstname.lastname@example.org