Finish the Data Analysis and embed it in your Word document. View/Complete Assignment: link for the experiment. Make sure all the calculations, comparisons, and graphs are complete. Data must be in shaded cells; any number in a non-shaded cell is calculated (using Excel, not a calculator). Uncertainties should be reduced to one or two significant figures, which gives the decimal place of the values they are the uncertainty of. If a point or points are significantly off the line (or curve) on the graph, double check your data to make sure the point was entered into Excel correctly. Obviously you want to do this before you leave the lab so you can retake bad data if necessary. Open up the Lab Report Template that you have downloaded to your computer from Blackboard. New (Mac or Windows). This will automatically start MS Word to a document with the proper formatting. You must enable the macros. 2. Do not open the template directly from Word! 3. Please answer all the prompts.

You need all this information in your report anyway and your answers will automatically go in their proper place. Go to the Data Analysis page in your new document. Browse… to the file, Insert, and Display as icon. Do not check the Link to file option. Double clicking on the icon from any computer starts Excel and loads the spreadsheet. Write the Sample Calculations. Go to the Sample Calculations page. Use the Equation Editor, once for each calculation. Louisiana Tech tutorial for engineering freshmen. You need a sample of each type of calculation you did, except for averages, least squares fits, and standard deviations. Look at all the numbers in non-shaded cells in your finished spreadsheet. How were they calculated? Each Sample has to be written as if it were a homework or test problem and consists of three lines. Since the basic Equation Editor does not have an option for drawing a line through multiple characters, we will draw a line through single characters as many times as needed.

This is the convention for showing cancellation, different from previous quarters. You have to include one SET (if any comparisons were made), doing the actual calculation. 3. Do the Error Analysis. The Measurement Uncertainties will be the error estimates from your Data Sheet, unless you did a statistical analysis (i.e., found the standard deviation), which supercedes your estimate. Even though such a value is calculated, it is the error associated with a measured value. Include in the Systematic Errors only those circumstances that would identifiably change your results. Not only do you state what was inadequate, you state how it affected the final numbers. This is not the place to come up with guesses as to what was wrong with the experiment. For the Propagated Errors, you need to write down typical values of each type of calculated uncertainty of calculated values (no equations or derivations). This includes the values from LINEST if a least squares fit was done. If either the slope or the y-intercept were immaterial, that error does not have to be included. State what it is and how it was calculated.

Write a paragraph or so capsulizing the theory. State the numerical results, with uncertainties, and how they compared with theory or with other results. Discuss the results- were they what was expected, did they verify the premise, did you find the Holy Grail? Here is where you can wax eloquent about what might have gone wrong. 5. Answer the Questions. Answer it and justify that answer. When you are asked to propagate the uncertainty of an expression, you have to use the Equation Editor. A propagation is an algebraic proof, meaning that you have to justify each line. Write or sketch out the proof by hand to figure out how many lines you need. Start the Equation Editor and enter the equation. Select a variable-size matrix as shown. The second column is for justifying each step. For the first row and first column, you take the uncertainty of both sides. Leave the first row, second column blank. In your derivation, the justification of each line is the algebraic property applied or the propagation rule from the Lab References. 6. Write the Abstract. This is a concise (short and sweet!) summary of the experiment.