PHYS 261 Study Guide - Fall 2018, Comprehensive Midterm Notes - Spreadsheet, Iso 216, Wavelength
12 Oct 2018
School
Department
Course
Professor
PHYS 261
MIDTERM EXAM
STUDY GUIDE
Fall 2018
Jayson DeNovellis
PHYS 261-0203
Fall 2018
Pre-Lab Exercises
8/27/2018
1. A cell in an EXCEL spreadsheet contains $A$5. What does it mean?
• Cell A5 is a fixed cell.
2. Suppose you are given an x-coordinate and a y-coordinate for a point, which type of chart
in EXCEL will actually plot the point at its Cartesian coordinates?
• Scatter chart
3. Consider the tools in EXCEL. What is the Solver used for?
• Minimizing or maximizing a cell by varying other cells
4. Consider the following: To run a macro in EXCEL, you may need to first click on.....?
• The view tab and then click on the macro button
5. Consider the following: Before the lab template will let you exit from EXCEL, according
to step 21, you must…
• Enter your name and section number into the spreadsheet in the designated area
and then click on the gray save button in the body of the spreadsheet
find more resources at oneclass.com
find more resources at oneclass.com
Jayson DeNovellis
PHYS 261-0203
Fall 2018
Pre-Lab Exercises
9/10/18
1. You measure the length of the same side of a block five times and find: b=11.0, 11.1,
11.2, 11.2 and 11.3 mm. What is the best estimate for b?
• 11.16 – take the average
2. You measure the length of the same side of a block five times and each measurement has
an uncertainty of ∆b = 0.1 mm. What is the uncertainty in the best estimate for b?
• 0.0447 – ∆b/sqrt(N)
3. You measure the lengths of three sides of a block and find a=12.23 mm, b=14.51 mm and
c = 7.45 mm with an error of ±0.03 mm in each measurement. What is the uncertainty ∆V
in the volume of the block?
• ∆V = 6.8 mm3 – (∆V/V)2 = (∆a/a)2 + (∆b/b)2 + (∆c/c)2
4. A block is measured to have a mass M = 25.3 g and volume V = 9.16 cm3 with an
uncertainty of ∆M =0.05 g in the mass and ∆V =0.05 cm3 in the volume. What is the
uncertainty in the density?
• ∆ρ = 0.016 g/cm3 – (∆ρ/ρ)2 = (∆M/M)2 + (∆V/V)2
5. A block is measured to have a density ρ = 2.76 g/cm3 with an uncertainty of ∆ρ = 0.03
g/cm3 . Find χ2 when the measured density is compared to the accepted density ρ = 2.70
g/cm3 of pure aluminum (see Appendix A for a discussion of how to calculate χ2 ).
N
• χ2 = 4 – χ2 = ∑ [(xi – xtheory)/∆xi]2
i=1
find more resources at oneclass.com
find more resources at oneclass.com
Document Summary
8/27/2018: a cell in an excel spreadsheet contains . 9/10/18: you measure the length of the same side of a block five times and find: b=11. 0, 11. 1, What is the best estimate for b: 11. 16 take the average, you measure the length of the same side of a block five times and each measurement has an uncertainty of b = 0. 1 mm. What is the uncertainty in the density: = 0. 016 g/cm3 ( / )2 = ( m/m)2 + ( v/v)2, a block is measured to have a density = 2. 76 g/cm3 with an uncertainty of = 0. 03 g/cm3 . Find 2 when the measured density is compared to the accepted density = 2. 70 g/cm3 of pure aluminum (see appendix a for a discussion of how to calculate 2 ). N: 2 = 4 2 = [(xi xtheory)/ xi]2 i=1.
