PHYS 261 CUMULATIVE LAB MOST ASKED
QUESTIONS AND 100% CORRECT ANSWERS
$A$5 means?
Fixed cell
How to plot cartesian coordinates
Scatter chart
Solver
Minimizes or maximizes a cell by varying other cells
To use a macro, you may have to first:
Go to view tab and click on the macro button
To exit a lab template:
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?
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?
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?
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?
0.016 g/cm3
(Deltap/p)^2=(deltaM/M)^2+(deltaV/V)^2
QUESTIONS AND 100% CORRECT ANSWERS
$A$5 means?
Fixed cell
How to plot cartesian coordinates
Scatter chart
Solver
Minimizes or maximizes a cell by varying other cells
To use a macro, you may have to first:
Go to view tab and click on the macro button
To exit a lab template:
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?
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?
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?
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?
0.016 g/cm3
(Deltap/p)^2=(deltaM/M)^2+(deltaV/V)^2
