PHYS261 Cumulative Lab Question and
Correct Answers/ Latest Update 2025
$A$5 means?
Ans: Fixed cell
How to plot cartesian coordinates
Ans: Scatter chart
Solver
Ans: Minimizes or maximizes a cell by varying other cells
To use a macro, you may have to first:
Ans: Go to view tab and click on the macro button
To exit a lab template:
Ans: Enter name and section number and save file using macro
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?
Ans: 11.16 mm
Take the average
,You measure the length of the same side of a block five times and each
measurement has an uncertainty of 0.10 mm. What is the uncertainty in the best
estimate for b?
Ans: 0.0447
=0.10/sqrt(5)
Yoy measure the lengths of three sides of a block and find a=12.23 mm, b=14.51
mm, c=7.45 mm with an error of +-0.030 mm in each measurement. What is the
uncertainty in the volume of the block?
Ans: 6.8 mm^3
(DeltaV/V)^2=(deltaa/a)^2+(deltab/b)^2+(deltac/c)^2
A block is measured to have mass M=25.3 g and volume V=9.16 cm3 with an
uncertainty of deltaM=0.050 g in the mass and deltaV=0.050 cm3 in the volume.
What is the uncertainty in the density?
Ans: 0.016 g/cm3
(Deltap/p)^2=(deltaM/M)^2+(deltaV/V)^2
A block is measured to have a density p=2.76 g/cm3 with an uncertainty of
deltap=0.030 g/cm3. Find chi-squared when the measured density is compared to
the accepted density p=2.70 g/cm3.
Ans: 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. This
measures the position by:
Ans: Emitting an ultrasonic pulse
A cart of mass m=0.20 kg rides on an air track that is tilted at an angle 2 degrees
from the horizontal. What is the magnitude of the total force on the cart?
Ans: 0.068 N
Mass*9.8*sin(theta)
A cart of mass m=0.25 kg rides on an air track that is tilted 3 degrees from the
horizontal. What is the magnitude of the cart's acceleration?
Ans: 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. Find the magnitude of the average velocity between
t=0.10 s and 0.20 s.
Ans: 0.7 m/s
Deltax/deltat
Suppose you measure g=9.7 m/s^2 with an uncertainty of deltag=0.060 m/s^2. Is
this consistent with the accepted value g=9.801 m/s^2?
Ans: Yes
Chi-squared=sum((xi-xtheory)/deltax)^2
Chidist(2.83,1)=0.09
Correct Answers/ Latest Update 2025
$A$5 means?
Ans: Fixed cell
How to plot cartesian coordinates
Ans: Scatter chart
Solver
Ans: Minimizes or maximizes a cell by varying other cells
To use a macro, you may have to first:
Ans: Go to view tab and click on the macro button
To exit a lab template:
Ans: Enter name and section number and save file using macro
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?
Ans: 11.16 mm
Take the average
,You measure the length of the same side of a block five times and each
measurement has an uncertainty of 0.10 mm. What is the uncertainty in the best
estimate for b?
Ans: 0.0447
=0.10/sqrt(5)
Yoy measure the lengths of three sides of a block and find a=12.23 mm, b=14.51
mm, c=7.45 mm with an error of +-0.030 mm in each measurement. What is the
uncertainty in the volume of the block?
Ans: 6.8 mm^3
(DeltaV/V)^2=(deltaa/a)^2+(deltab/b)^2+(deltac/c)^2
A block is measured to have mass M=25.3 g and volume V=9.16 cm3 with an
uncertainty of deltaM=0.050 g in the mass and deltaV=0.050 cm3 in the volume.
What is the uncertainty in the density?
Ans: 0.016 g/cm3
(Deltap/p)^2=(deltaM/M)^2+(deltaV/V)^2
A block is measured to have a density p=2.76 g/cm3 with an uncertainty of
deltap=0.030 g/cm3. Find chi-squared when the measured density is compared to
the accepted density p=2.70 g/cm3.
Ans: 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. This
measures the position by:
Ans: Emitting an ultrasonic pulse
A cart of mass m=0.20 kg rides on an air track that is tilted at an angle 2 degrees
from the horizontal. What is the magnitude of the total force on the cart?
Ans: 0.068 N
Mass*9.8*sin(theta)
A cart of mass m=0.25 kg rides on an air track that is tilted 3 degrees from the
horizontal. What is the magnitude of the cart's acceleration?
Ans: 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. Find the magnitude of the average velocity between
t=0.10 s and 0.20 s.
Ans: 0.7 m/s
Deltax/deltat
Suppose you measure g=9.7 m/s^2 with an uncertainty of deltag=0.060 m/s^2. Is
this consistent with the accepted value g=9.801 m/s^2?
Ans: Yes
Chi-squared=sum((xi-xtheory)/deltax)^2
Chidist(2.83,1)=0.09
