WCU PHYS 261 EXAM FINAL PAPER
QUESTIONS SOLUTIONS GRADED
A+
◉ (Exp 1)Which type of chart in EXCEL will actually plot the point at
its Cartesian coordinates? Answer: scatter chart
◉ (Exp 1)What is the Solver used for? (pick the best answer)
Answer: minimizing or maximizing a cell by varying other cells
◉ (Exp 1)To run a macro in EXCEL, you may need to first click on.....?
Answer: the view tab and then click on the macro button.
◉ (Exp 1)Before the lab template will let you exit from EXCEL,
according to step 21, you must... Answer: 1) enter your name in the
designated area of the spreadsheet
2) enter your section number in the designated area of the
spreadsheet
3) save the file using the gray save button in the body of the
spreadsheet
◉ (Exp 2)"1/3" rule to determine the uncertainty ∆x Answer: Error
is 1/3 of the smallest unit
,(Ex: ruler in mm, error=1/3mm)
◉ (Exp 2)estimate Answer: sum of values/# of values
◉ (Exp 2)The smallest increment the scale can display is 0.1 g and
thus the uncertainty ∆M in a measurement of mass would be about
Answer: 0.033 g
◉ (Exp 2)Using the ruler, and without using the vernier calipers,
estimate how precisely you can measure the length of one of the
sides of one of the blocks. Answer: To the nearest mm with an error
of 1/3mm
◉ (Exp 2)Volume error Answer: ∆V =V*sqrt((∆c/c)^2 + (∆b/b)^2 +
(∆a/a)^2)
◉ (Exp 2)Density error Answer: ∆ ρ =ρ sqrt((∆V/V)^2 + (∆M/M)^2)
◉ (Exp 2)Mean error Answer: ∆〈x〉=∆x/sqrt(N)
◉ (Exp 2)χ2 Answer: =∑((xi-xtheory)/∆xi)^2
◉ (Exp 2)Determining if values are consistent Answer: are within 2
error bars from the accepted value
, ◉ (Exp 2)Density consistent value Answer: measured and accepted
density should differ by no more than twice the uncertainty.
◉ (Exp 2)"two-sigma rule" Answer: if your data point is no more
than two error bars from the accepted value then the disagreement
is not significant
◉ (Exp 2)reduced χ2 should equal (blank) for good fit Answer: 1
◉ (Exp 2)reduced χ2 eqn Answer: χ2/v
◉ (Exp 2)Degrees of freedom (v) Answer: N-α (where N is the
number of measurements and α is the number of fitting parameters
used to find the theoretical value from the data)
◉ standard deviation Answer:
◉ propagation of errors equation Answer:
∆f=sqrt(sum((df/dx)*∆x)^2))
◉ (Exp 3)tilt angle of the air-track Answer: theta= invsin(added
height/length of track)
QUESTIONS SOLUTIONS GRADED
A+
◉ (Exp 1)Which type of chart in EXCEL will actually plot the point at
its Cartesian coordinates? Answer: scatter chart
◉ (Exp 1)What is the Solver used for? (pick the best answer)
Answer: minimizing or maximizing a cell by varying other cells
◉ (Exp 1)To run a macro in EXCEL, you may need to first click on.....?
Answer: the view tab and then click on the macro button.
◉ (Exp 1)Before the lab template will let you exit from EXCEL,
according to step 21, you must... Answer: 1) enter your name in the
designated area of the spreadsheet
2) enter your section number in the designated area of the
spreadsheet
3) save the file using the gray save button in the body of the
spreadsheet
◉ (Exp 2)"1/3" rule to determine the uncertainty ∆x Answer: Error
is 1/3 of the smallest unit
,(Ex: ruler in mm, error=1/3mm)
◉ (Exp 2)estimate Answer: sum of values/# of values
◉ (Exp 2)The smallest increment the scale can display is 0.1 g and
thus the uncertainty ∆M in a measurement of mass would be about
Answer: 0.033 g
◉ (Exp 2)Using the ruler, and without using the vernier calipers,
estimate how precisely you can measure the length of one of the
sides of one of the blocks. Answer: To the nearest mm with an error
of 1/3mm
◉ (Exp 2)Volume error Answer: ∆V =V*sqrt((∆c/c)^2 + (∆b/b)^2 +
(∆a/a)^2)
◉ (Exp 2)Density error Answer: ∆ ρ =ρ sqrt((∆V/V)^2 + (∆M/M)^2)
◉ (Exp 2)Mean error Answer: ∆〈x〉=∆x/sqrt(N)
◉ (Exp 2)χ2 Answer: =∑((xi-xtheory)/∆xi)^2
◉ (Exp 2)Determining if values are consistent Answer: are within 2
error bars from the accepted value
, ◉ (Exp 2)Density consistent value Answer: measured and accepted
density should differ by no more than twice the uncertainty.
◉ (Exp 2)"two-sigma rule" Answer: if your data point is no more
than two error bars from the accepted value then the disagreement
is not significant
◉ (Exp 2)reduced χ2 should equal (blank) for good fit Answer: 1
◉ (Exp 2)reduced χ2 eqn Answer: χ2/v
◉ (Exp 2)Degrees of freedom (v) Answer: N-α (where N is the
number of measurements and α is the number of fitting parameters
used to find the theoretical value from the data)
◉ standard deviation Answer:
◉ propagation of errors equation Answer:
∆f=sqrt(sum((df/dx)*∆x)^2))
◉ (Exp 3)tilt angle of the air-track Answer: theta= invsin(added
height/length of track)
