Place the formula letter and base units on each axis of the second graph that would linearize the function.


For all Excel graphs label axis and place equations on the charts.

Assume the data will be some exponential equation y=kx^n, where k and n are constants.

Do this problem paper first(2 graphs) and then in excel or on the calculator and insert these results into this document (2 additional graphs)

1. An object is provided various velocities and the resulting kinetic energy determined experimentally.

a. Plot the raw data on graph paper then excel.

v (m/s) / KE (J)
1.9 / 5.1
3.9 / 25
6.0 / 58
8.2 / 98
10. / 152
  1. Based on the graphs of the raw data predict a relative k (less than 1, about 1, greater than 1) and explain your prediction
  1. Predict an exponential and provide a justification for your prediction.
  1. Create additional graphs (on paper then excel) to determine your exponent and calculate a constant.(set the line graph intercept to zero)
  1. If the actual equation for the relationship between the two variables is KE=(1/2)mv2, determine the mass of the object in the experiment.(you may not use a single data point to perform this calculation but must use the equation of the line)

Do this problem paper first (2 graphs) and then in excel or on the calculator and insert these results into this document (2 additional graphs)

2. A spring has a force sensor attached to it and is pulled at increasing distances from rest. A reading is recorded on the force sensor and the data is plotted below.

  1. Plot the raw data on graph paper then excel.

x (m) / Force (N)
0.005 / 1.9
0.010 / 2.5
0.020 / 3.4
0.030 / 4.2
0.040 / 5.3
0.050 / 5.6
0.060 / 5.8
0.070 / 6.6
0.080 / 7.1
0.090 / 7.5
  1. Based on the graph of the raw data predict a relative k (less than 1, about 1, greater than 1) and explain your prediction
  1. Predict an exponential and provide a justification for your prediction.
  1. Create additional graphs to determine your exponent and calculate a spring constant. (set the line graph intercept to zero)
  1. Calculate the force necessary to stretch the spring exactly 3.0meters from the resting position.
  1. If a normal spring requires a force to extend the spring that is directly proportional to the distance extended, is this a normal spring? In other words, if it was a normal spring what should we have seen when we plotted a graph of the raw data?
  1. An astronomer analyzes a distant solar system. She determines the distance the planet is from the central star and the corresponding period of revolution for each planet.

Do the graphs for this problems on excel or on the calculator (2 graphs)

  1. Plot a graph of the data.
  2. Use the shape of your graph to predict the exponent (hint, this is a rare occasion in this course where the exponent will not be a whole number)
  3. Consider the equation in part e to determine how to manipulate the data to linearize the function. (On your graph, place the equation of the line in scientific notation to show more than one significant figure)
  4. Determine the period of revolution for a planet that is 5.0E12meters from the sun.
  5. If the gravitational equation is P=, where M is the mass of the star, G is a constant (6.67E-11), and d is distance from the star. Determine the mass of the star. Hear d (you may not use a single data point to perform this calculation but must use the equation of the line)