$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
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.
, 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:
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?
0.068 N
Mass9.8sin(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?
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.
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?
Yes
Chi-squared=sum((xi-xtheory)/deltax)^2
Chidist(2.83,1)=0.09
USE EXCEL FOR CHIDIST
Two carts approach each other, collide, and stick together after the collision. This is an
example of what type of collision:
Perfectly inelastic collision
Two carts collide and bounce off each other. If there are no external forces acting on the
system:
The total kinetic energy can change during the collision but the total momentum of the
carts must be the same before and after the collision.
A cart with mass 0.30 kg and velocity 0.20 m/s collided on an air-track with a cart with
mass 0.40 kg and velocity -0.10 m/s. What is the final velocity in m/s of the two carts if
they stick together?
0.029 m/s
m1v1+m2v2=(m1+m2)vf
What provides the vertical force to balance the force of gravity on the pendulum bob?