6 questions use excell and word .docx attached

3) Below is a collection of data for an iron-concentration thermocouple. Temperature is in degrees Celsius, and the electromotive force (emf) is in millivolts.

1. plot the data on excel with the voltage as the independent

2. using the method of selected points, find the equation of the line using a computer.

4) there are design specifications for the minimum sight distance (distance to see an approaching vehicle measured along the roadway from the intersection of the two roadways) that a driver stopped at a stop sign must have to safely enter a roadway where vehicles do not stop. Values in the table below are for safe entry to cross the roadway (not to turn onto the other roadway but to cross) where vehicles do not stop.

1. plot the graph with design speed as the independent variable.

2. determine the equation of

3. the relationship using the method of selected points.

4. determine the equation of the relationship using computer-assisted methods.

5. predict the slight distance required at 55 mph.

5) a spring was tested in Chicago last Thursday. The test of the spring, (X-19), produced the fallowing data.

1. plot the data on rectangular graph and determine the equation that expresses the deflation to be expected under a given load. Use both the method of selected points and computer.

2. predict the load required to produce a deflation of 75 mm.

3. what load would be expected to produce a deflation of 120 mm.

6) an AMC ferns was tested 45 days ago in your home town to determine the heat generated, expressed in thousands of British thermal units per cubic foot of furnace volume at varying temperatures. The results are shown in the table.

1. plot the data on log-log paper (or excel) with angular velocity as the independent Vrabel.

2. using the methods of selected points, determine the equation that best fits the data.

3. plot the graph in excel and determine the equation of the line.

7) the capacity of a 20-cm screw conveyor that is moving dry corn is expressed in liters per second and the conveyor speed in revolutions per minute. A test was conducted in Rockland IL, on conveyer model JD172 last week. The results of the test are given below.

1. plot the data on log-log paper (or excel) with angular velocity as the independent Vrabel.

2. determine the equation that expresses capacity as a function of angular velocity using the method of selected points.

20) according to the united states department of labor, the consumer price index for several household expense items are shown in the table below. The time period 1982-1984 is established as the basis with an index of 100.

(a) using excel plot all the data.

(b) describe what the plotted information suggest to you ??