1. What is the main purpose of doing LINEST function in excel?

To find the maximum value of a data set

To find the average of a data set

To find the standard deviation of a data set

To find the slope of a scatter graph

2. Suppose you performed the LINEST function in the cell A1-B5. What does the number in A1 mean?

Uncertainty of the Y-intercept

Uncertainty of the slope

Y-intercept

Slope

3. Suppose you performed the LINEST function in the cell A1-B5. What does the number in B1 mean?

Slope

Uncertainty of the slope

Uncertainty of the Y-intercept

Y-intercept

4. Suppose you performed the LINEST function in the cell A1-B5. When performing LINEST of a speed vs. time graph, what does the value in the cell A1 mean?

distance

velocity

acceleration

duration

5. When performing LINEST of a speed vs. time graph, what should you select for the 'known_y' ?

time

speed

acceleration

6. Suppose you performed the LINEST function in the cell A1-B5. When performing LINEST of a mass vs. volume graph, what does the value in the cell A1 mean?

length

width

weight

density

7. When performing LINEST of a mass vs. volume graph, what should you select for the 'known_y' ?

mass

density

No answer text provided.

volume