PHYS 261 MOST ASKED QUESTIONS AND 100%
CORRECT ANSWERS
A cell in an EXCEL spreadsheet contains $A$5. What does it mean?
Cell A5 is a fixed cell.
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
Consider the tools in Excel.
What is the Solver used for?
minimizing or maximizing a cell by varying other cells
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.
You measure the length of the same side of a block five times and find: b =
11.0 mm, 11.1 mm, 11.2 mm, 11.2 mm and 11.3 mm.
What is the best estimate for b in mm?
take the average = 11.16
You measure the length of the same side of a block five times and each
measurement has an uncertainty of Δb = 0.10 mm.
What is the uncertainty in the best estimate for b in mm?
0.0447
=0.10/sqrt(5)
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.030 mm in each
measurement.
What is the uncertainty ΔV in the volume, in mm3, of the block?
6.8 mm^3
(DeltaV/V)^2=(deltaa/a)^2+(deltab/b)^2+(deltac/c)^2
A block is measured to have a mass M = 25.3 g and volume V = 9.16 cm3
with an uncertainty of ΔM =0.050 g in the mass and ΔV = 0.050 cm3 in the
volume.
What is the uncertainty in g/cm3 of the density?
, 0.016 g/cm3
(Deltap/p)^2=(deltaM/M)^2+(deltaV/V)^2
A block is measured to have a density ρ = 2.76 g/cm3 with an uncertainty
of Δρ = 0.030 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).
Chi-squared=4
Chi-squared=sum((xi-xtheory)/deltaxi)^2
In this lab, the position of a cart will be measured using a sonic ranger.
The ranger measures the position by...
emitting an ultrasonic pulse
A cart of mass m = 0.20 kg rides on an air track that is tilted at an
angle θ = 2° from the horizontal.
What is the magnitude of the total force in N on the cart?
0.068 N
Mass9.8sin(theta)
A cart of mass m = 0.25 kg rides on an air track that is tilted at an
angle θ = 3° from the horizontal
What is the magnitude of the cart’s acceleration in m/s2?
0.51 m/s^2
9.8*sin(theta)
A sonic ranger measures positions x = 0.10 m, 0.15 m, 0.22 m, 0.28 m at
times t = 0 s, 0.10 s, 0.20 s, and 0.30 s, respectively
Find the magnitude of the average velocity in m/s between t = 0.10 s
and t = 0.20 s.
0.7 m/s
Deltax/deltat
Suppose you measure g = 9.7 m/s2 with an uncertainty of Δg = 0.060
m/s2.
Is this consistent with the accepted value g = 9.801 m/s2?
Yes
Chi-squared=sum((xi-xtheory)/deltax)^2Chidist(2.83,1)=0.09USE EXCEL FOR
CHIDIST
CORRECT ANSWERS
A cell in an EXCEL spreadsheet contains $A$5. What does it mean?
Cell A5 is a fixed cell.
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
Consider the tools in Excel.
What is the Solver used for?
minimizing or maximizing a cell by varying other cells
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.
You measure the length of the same side of a block five times and find: b =
11.0 mm, 11.1 mm, 11.2 mm, 11.2 mm and 11.3 mm.
What is the best estimate for b in mm?
take the average = 11.16
You measure the length of the same side of a block five times and each
measurement has an uncertainty of Δb = 0.10 mm.
What is the uncertainty in the best estimate for b in mm?
0.0447
=0.10/sqrt(5)
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.030 mm in each
measurement.
What is the uncertainty ΔV in the volume, in mm3, of the block?
6.8 mm^3
(DeltaV/V)^2=(deltaa/a)^2+(deltab/b)^2+(deltac/c)^2
A block is measured to have a mass M = 25.3 g and volume V = 9.16 cm3
with an uncertainty of ΔM =0.050 g in the mass and ΔV = 0.050 cm3 in the
volume.
What is the uncertainty in g/cm3 of the density?
, 0.016 g/cm3
(Deltap/p)^2=(deltaM/M)^2+(deltaV/V)^2
A block is measured to have a density ρ = 2.76 g/cm3 with an uncertainty
of Δρ = 0.030 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).
Chi-squared=4
Chi-squared=sum((xi-xtheory)/deltaxi)^2
In this lab, the position of a cart will be measured using a sonic ranger.
The ranger measures the position by...
emitting an ultrasonic pulse
A cart of mass m = 0.20 kg rides on an air track that is tilted at an
angle θ = 2° from the horizontal.
What is the magnitude of the total force in N on the cart?
0.068 N
Mass9.8sin(theta)
A cart of mass m = 0.25 kg rides on an air track that is tilted at an
angle θ = 3° from the horizontal
What is the magnitude of the cart’s acceleration in m/s2?
0.51 m/s^2
9.8*sin(theta)
A sonic ranger measures positions x = 0.10 m, 0.15 m, 0.22 m, 0.28 m at
times t = 0 s, 0.10 s, 0.20 s, and 0.30 s, respectively
Find the magnitude of the average velocity in m/s between t = 0.10 s
and t = 0.20 s.
0.7 m/s
Deltax/deltat
Suppose you measure g = 9.7 m/s2 with an uncertainty of Δg = 0.060
m/s2.
Is this consistent with the accepted value g = 9.801 m/s2?
Yes
Chi-squared=sum((xi-xtheory)/deltax)^2Chidist(2.83,1)=0.09USE EXCEL FOR
CHIDIST
