Linear Functions and Correlation Concepts

What is the first step in deriving a linear equation from a data set?

• List the x and y variables

• Draw a graph

• Calculate the correlation value

• Identify the y-intercept

Which function is used to calculate the slope in a spreadsheet?

• TREND

• SLOPE

• LINEST

• INTERCEPT

What is the significance of the y-intercept in a linear equation?

• It represents the correlation value

• It represents the slope of the line

• It is the point where the line crosses the x-axis

• It is the point where the line crosses the y-axis

What formula represents the equation of a line?

• x = b + my

• x = my + b

• y = b + mx

• y = mx + b

Which of the following is NOT a method to find the slope?

• Using a trendline in a chart

• Using the INTERCEPT function

• Using the formula y2 - y1 / x2 - x1

• Using the SLOPE function

How can you visually derive the linear equation using a spreadsheet?

• By adding a trendline to a scatter plot

• By adding a trendline to a 2D line chart

• By using a pie chart

• By using a bar chart

What is the purpose of displaying the equation on a chart?

• To find the correlation value

• To visually represent the data

• To calculate the mean of the data

• To derive the slope and y-intercept

What does an r value close to 1 indicate?

• Strong correlation

• Negative correlation

• No correlation

• Weak correlation

What does the r value help determine?

• The mean of the data set

• The strength of the linear relationship

• The y-intercept

• The slope of the line

What is the result of a correlation value (r) close to zero?

• No linear relationship

• Strong linear relationship

• Perfect linear relationship

• Negative linear relationship