Excel tutorial

Main

Description

‰‰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 ...

Informations

• Publié par: Assu
• Nombre de lectures: 29
• Langue: English

Extrait

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  

 

 

en lrakcoRssfe Kor0820ro P  EMCcxE  112orut Tel  © 4 ia

 

‰   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 11 nkeR coesofPr8 rlKar so airotuT 002© 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 doesnt 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   1 oria Tutxcel seosrPfo00 8 02©eknoc RrlKar 

CME 211

 

   

 

 

Excel Tutorial  

4.  Graphing an x-y scatter plot   ‰   Similarly as in steps 3 and 4 steps, youll 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