To exit super/subscript mode, repeat the process above. Click on the box to the left of subscript or superscript. In the lower left of the window it says Effects. Subscripts and Superscripts To insert a superscript or subscript in Excel click on Format on the menu bar. Open your Excel document and click on Edit and then Paste. Now select the and click on Edit on the task bar. Find the symbol on the table and select it. (If you are using a Macintosh computer hold down Alt key, shift key and hit the number 8 key.) Inserting a symbol To insert a symbol open up a word document. Inserting ( ) symbol To insert a degree ( ) symbol hold down the Alt key and type 248 on the number pad. 3Ĥ DO NOT enter values for your unknown in the table at this point. For data in rows, enter values for y in boxes to the right of your y axis heading e.g. For data in columns, enter values for y (numbers only, no letters or symbols) under the y axis heading e.g. Enter values for x in the 1 row following your heading if you are doing your data in rows. Enter the values for x (numbers only, no letters or symbols) in the A column under your heading if you are doing your data in columns. Also if you have increased the width of a column, your page width will not go as far as I anymore. Remember your page width only goes through I so if you have rows to the right of I they will not show up on your page when you print it. absorbance in the next box in the column, A2. To have your data in rows To have your data in rows, type in heading for the y axis e.g. To have your data in columns To have your data in columns, type in the heading for the y axis e.g. If the heading is too long to fit in the box, you may increase the column width by placing the cursor on the line between A and B so you get a double headed arrow and dragging to the width you want. Type in the heading for the x axis in the A1 box e.g. You didn't know what the absorbances 2ģ would be until you put the various concentrations in the spectrophotometer, so absorbance would go on the y axis. For example if you are measuring the absorbance of a number of dye concentrations the dye concentrations will be on the x axis since you decided on and prepared what concentrations you wanted to test. The information you knew before you ran the experiment goes on the x axis and the information you got by doing the experiment goes on the y axis. Making your Table Decide what data should go on the x axis (the determinate axis) and what data should go on the y axis (the indeterminate axis). Opening Excel Click on start at the bottom left of the screen.
Oh, there s no trick to following directions, and if I don t teach my children one other thing, I m going to teach them that. I never read beyond the operation I am engaged in, having a simple trust that the person who wrote them knew what he was doing. What you need is not intelligence, but a blind faith. All you have to do is follow them and you can follow them only one step at a time. They try to relate the first few steps to the whole, and there is no obvious relation, so they get discouraged and say, Oh, I can t learn things out of books. They read the whole thing through and it doesn t make sense to them, so they start with a defeatist attitude. I think the difficulty with people who can t follow printed directions for knitting or anything else is that they try to understand them. I can make up my own directions, or I can follow printed directions, which apparently is the harder thing to do, although I don t see why it should be.
Calculating the Mean Calculating the Standard Deviation How to embed an Excel graph and tables into a Word document Examples of Graphs a) Single Line Graph 28 b) Multi-line Graph 29 c) Histogram 30 On Following Directions From We Took to the Woods by Louise Dickinson Rich I m a good knitter, and I m proud of it. 14 To format graph title 15 To format the axes labels 15 To format the axes numbers and axes lines 16 To format the borders 17 To format the trendline Solving for Unknowns a) To solve for x when you know y 18 b) To solve for y when you know x Formatting your table a) Centering data 20 b) Formatting table headings 20 c) Adding borders Making a Multi-line Graph Making a Histogram 22Ģ 9. Making your graph 5 a) Deciding how to set the y intercept 11 b) Adding the correlation coefficient ( r ) to your graph 13 c) Formatting your graph To change the graph title, axes labels, etc. Making your table 2 a) Inserting a symbol 4 b) Inserting a 4 c) Subscripts and superscripts 4 d) Significant figures 4 e) Merging cells 5 4. Susan Petro TABLE OF CONTENTS Topic Page number 1. 1 USING EXCEL ON THE COMPUTER TO FIND THE MEAN AND STANDARD DEVIATION AND TO DO LINEAR REGRESSION ANALYSIS AND GRAPHING Dr.