Excel tutorial
15
pages
English
Documents
Le téléchargement nécessite un accès à la bibliothèque YouScribe Tout savoir sur nos offres
15
pages
English
Documents
Le téléchargement nécessite un accès à la bibliothèque YouScribe Tout savoir sur nos offres
‰‰CME 211 Excel Tutorial Excel Tutorial: Data plotting and Trendline Generation Basic Excel Open excel, it will open a window as shown below: The top blue line area shows the excel file name, which is now “Book 1”. 1 ©2008 Professor Karl Rockne ‰‰‰CME 211 Excel Tutorial The next line lists menus, which can drop down to show the expanded menu. As shown below: The third line lists several tool bars; you can add to the control line by toggling them on manually. The bottom line also shows additional tool bars that can help you draw lines or pictures, change text colors etc. 2 ©2008 Professor Karl Rockne ‰CME 211 Excel Tutorial Next to the bottom line, three worksheets are available, currently we are using “Sheet 3”. You can add additional worksheets by “right clicking” on worksheet (sheet 1, 2, or 3) → “insert” → select “worksheet” →click “OK”. 3 ©2008 Professor Karl Rockne ‰CME 211 Excel Tutorial 1. Graphing Data Two data sets are shown below (Input yourself or copy from other excel files) 4 ©2008 Professor Karl Rockne ‰CME 211 Excel Tutorial 2. Graphing Bar Charts Select “data set 1” and click the “chart wizard” bar on the toolbar line. We will use a bar chart to graph this data. Recall that data that can be put in a Table can also typically be graphed using a column (vertical) or bar (horizontal) chart. 5 ©2008 ...
Voir
Publié par
Langue
English
CME 211
Excel Tutorial
Excel Tutorial: Data plotting and Trendline Generation Basic Excel Open excel, it will open a window as shown below: The top blue line area shows the excel file name, which is now Book 1.
1
©2008 Professor Karl Rockne
CME 211
Excel Tutorial
The next line lists menus, which can drop down to show the expanded menu. As shown below: The third line lists several tool bars; you can add to the control line by toggling them on manually. The bottom line also shows additional tool bars that can help you draw lines or pictures, change text colors etc.
2
©2008 Professor Karl Rockne
CME 211
Excel Tutorial
Next to the bottom line, three worksheets are available, currently we are using Sheet 3. You can add additional worksheets by right clicking on worksheet (sheet 1, 2, or 3) → insert → select worksheet → click OK.
3
©2008 Professor Karl Rockne
Two data sets are shown below (Input yourself or copy from other excel files)
1. Graphing Data
l
CME 211
Excel Tutorial
2. Graphing Bar Charts Select data set 1 and click the chart wizard bar on the toolbar line. We will use a bar chart to graph this data. Recall that data that can be put in a Table can also typically be graphed using a column (vertical) or bar (horizontal) chart.
5
©2008 Professor Karl Rockne
l
Finally you get picture as below if you selected create chart in worksheet (note you can also create a new worksheet with the chart itself).
Click on column below chart type → click next on the lower-right corner of the window → make appropriate adjustments by following the instructions → continue to click next until you finish the data entry.
xEec lCEM2 11nkeR coesofPr8 rlKar soairotuT002© 6 
CME 211
Excel Tutorial
By right clicking on different parts of the picture, you can format your chart area, plot area etc.
7
©2008 Professor Karl Rockne
CME 211
Excel Tutorial
The following figure is adjusted for a better shape and changing the y axis to proper % format. Note: it is a good idea to remove the default grey background to the chart. It shows up much better when printed on a black and white printer.
You will notice that this dataset does not highlight the difference in % isopropyl alcohol content and capillary rise because they are small relative to the difference in surface tension. In addition, the plotting of three data really doesnt capture the cause and effect of how the independent variable (% isopropyl alcohol) affects the dependent variables. In situations such as this, it is preferable to plot the data on an x-y scatterplot with the dependent variable on the x axis. With this dataset, it would also be appropriate to use alternate y-axes (i.e. the left axis would be on a different scale than the right axis). Alternately, if datasets vary by more than an order of magnitude, this is an appropriate situation to use a LOG scale on the axis. However, in logarithmic scale, you lose the ability to see small differences in the datasets. If that is important, you may prefer to use a linear scale.
8
©2008 Professor Karl Rockne
Select from standard type menu the xy (scatter) item → click next → adjust your graph by following the instruction of windows
l
3. Graphing a Continuous Linear Dataset As this dataset consisted of data that varied as a function of another dataset, it would be more appropriate to chart this dataset to show how the dependent data (capillary rise and surface tension) varied as a function of the independent data (% isopropyl alcohol).
We will now see how to graph the same dataset in an x-y scatterplot. Select the data set 1, and Click the chart wizard bar located on the toolbar line.
02809 © efssP orarl or KneRock 112 EMC Telxc Eiaorut
Adjust your picture to provide a better appearance as before.
l
Finally you get picture as below:
CM21E E1 1oria TutxcelseosrPfo00 8 02©eknoc RrlKar 
CME 211
Excel Tutorial
4. Graphing an x-y scatter plot Similarly as in steps 3 and 4 steps, youll get figure below by using data set 2.
This dataset starts to curve upwards and appears to increase in an exponential form.
11
©2008 Professor Karl Rockne
