#3 TEAM Assignment: Curve-fitting
University of the District of Columbia
Introduction to Engineering
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???