Two variable regression

Task

Conduct a Two Variable Regression Analysis of the given data and display the statistical values in a table.

1.		Use the Move tool to highlight all cells of columns A and B that contain numbers.
2.		Select the Two Variable Regression Analysis tool to show the diagram in the Data Analysis Window.
3.		Select Show Statistics in the Data Analysis Window to see the statistic parameters of the data.
4.		Below the Data Analysis Window you can choose from a variety of regression models (e.g. Linear or Polynom).

	Description	Formula
MeanX	Calculates the arithmetic mean of the elements in the first column.
MeanY	Calculates the arithmetic mean of the elements in the second column.
Sx	Calculates the standard deviation of the numbers in the first column.
Sy	Calculates the standard deviation of the numbers in the second column.
r	Calculates the correlation coefficient.
	Calculates the Spearman's rank correlation coefficient.
Sxx	Calculates the statistic value:
Syy	Calculates the statistic value:
Sxy	Calculates the statistic value:
	Calculates the coefficient of determination. Note: If the Regression Model is linear, then
SSE	Calculates the Sum of squared errors between the y-values of the list and the function values of the x-values.	f...Regression curve