Exploring Linear Regression and Correlation in Excel

What does a positive correlation indicate?

• There is no relationship between the variables

• Both variables increase together

• One variable increases while the other decreases

• Both variables decrease together

What is the range of the correlation coefficient?

• 0 to 100

• -0.5 to 0.5

• -1 to 1

• 0 to 1

What does a correlation coefficient close to 0 indicate?

• Strong positive correlation

• Moderate correlation

• Strong negative correlation

• Little or no correlation

What is considered a weak correlation?

• Correlation coefficient less than 0.3

• Correlation coefficient between 0.3 and 0.75

• Correlation coefficient greater than 0.75

• Correlation coefficient equal to 1

What should the columns be labeled when graphing temperature and water bottle sales in Excel?

• Temperature and Sales

• Time and Quantity

• Degrees Fahrenheit and Number of Water Bottles Sold

• X and Y

Which Excel function is used to create a scatter plot?

• X Y Scatter

• Line Graph

• Bar Graph

• Pie Chart

How can you modify the x-axis in Excel to better fit the data range?

• Double-click the y-axis

• Use the 'Insert' menu

• Double-click the x-axis

• Right-click the chart

What is the purpose of adding a trendline to a scatter plot?

• To change the color of the points

• To visualize the relationship between variables

• To add labels to the points

• To create a pie chart

What does the slope of the regression line represent in the context of temperature and water bottle sales?

• The change in water bottle sales per degree increase in temperature

• The average temperature

• The total number of water bottles sold

• The maximum temperature recorded

How do you calculate the correlation coefficient (r) from the r-squared value?

• Multiply r-squared by 2

• Subtract r-squared from 1

• Divide r-squared by 2

• Take the square root of r-squared