#3 TEAM Assignment: Curve-fitting

Team Graphing Assignment Using Excel

(1) Data from trial run on the Utah salt flats made by an experimental turbine-powered vehicle are listed below.

a. Plot the data on excel using time as the independent variable.

b. Find an equation to describe the relationship between Time and Velocity

Time (sec)	Velocity (m/s)
10	15.1
20	32.2
30	63.4
40	84.5
50	118
60	139

(2) The resistance of a class and shape of electrical conductor was tested over a wide range of sites at constant temperature. The test was performed in Madison, WI on April 4, 1994 at the Acme Electrical Labs. The test results are shown in the Table below. The resistance is expressed in milliohms per meter of conductor length.

a. Plot the data on excel using area as the independent variable.

b. Find an equation to describe the relationship between Area and Resistance

Area (mm2)	Resistance (mohm/m)
0.021	505
0.062	182
0.202	65.3
0.523	22.2
1.006	11.3
3.32	4.17
7.29	1.75

(3) The voltage across a capacitor during discharge was recorded as a function of time (see Table).

a. Plot the data on excel with times as the independent variable.

b. Find an equation to describe the relationship between Time and Voltage

Time (sec)	Voltage (V)
0	88
10	62
17	23
26	9.5
32	3.5
38	1.9
42	1.33

(4) Plot and fit your data from IR sensor “Detection distance vs. Resistance” pg 236.

According to your data fit, what resistor (Ω) would you use to measure a distance of 2 feet using your IR sensor???