Excel tutorial

Excel tutorial

-

English
15 Pages
Read
Download
Downloading requires you to have access to the YouScribe library
Learn all about the services we offer

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

Subjects

Informations

Published by
Reads 29
Language English
Report a problem
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 © 4ia
 
‰  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 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  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, 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