Exercise insights Flashcards
How do you calculate correlation in libre office calc
Mark the columns you want to correlate. In header click Data -> Statistics -> correlation. Otherwise you can use the correl function.
Why is the correlation coefficient not the slope of an estimated line of equation for the relationship between two variables
Because the correlation coefficient is a measure of the strength of their relationship aka how well you can make a line of the scattered dots not how that line points, that is the job of the regression line.
Is the concept of dependent and independent variables related to correlation or regression
Regression
Is correlation a measure of how large the covariance is between two variables
Yes
How do you get the estimated slope coefficient of two variables in libre office calc
From the header you click Data -> Statistics -> Regression, you then mark the dependent and independent variable and where you want the result wereafter you get the slope coefficient under Coefficients next to X1 if you only have two variables.
What does it mean when we say that the estimated slope coefficient is statistically significant.
That there is strong evidence that the relationship between the independent variable and the dependent variable in a regression model is not due to random chance. A relationship is statistically significance if the p-value is low and there is no third factor that influences both
Can a regression model as a whole be statistically insignificant
Yes if the independent variables do not collectively explain a significant portion of the variation in the dependent variable. This can be due to a small sample size, noise in the data, a strong correlation between the independent variables or simply a weak relationship between the independent variables and the dependent ones.
What happens when the slope coefficient is equal to zero
It means there is no relationship between the variables detectable with a regression model.
If the p-value is high and the t-value is low is the relationship statistically significant
No if the t-value is high it indicates a strong relationship between the variables and when the p-value is low it means that the chance of observing such a t-value under the null hypothesis is very small. So if the t-value is high and the p-value is small it means that the null hypothesis of b being 0 is probably false and the model is statistically significant.
How do you insert a trend line and function in a scatter plot in libre office calc
You create a scatter plot by marking the related columns and clicking the chart icon were-after you choose scatter-plot. Then after you have made your scatter-plot you can right click on the dots you want a trend-line of and choose trend line and function in the drop-down menu.
The residual is the diference between the average dependent variable and the declared dependent varaible
No, thats the variance of that instance. The residual is the diference between the prediction of the estimator and the actual value at that point.
In a quadratic regression model the deriviative can be interpreted as the increase when x changes by one unit
True
In a linear probability model one can count on the model being restricted between 0 and 1
False, lines continue to infinity
In which regression models does B1/100 represent a UNIT change in y at a 1% change in x. Linear, log-log, exponential or logarithmic
Only logarithmic
In the log log model the coeficient is…
The expected percentage change in y when x changes by 1%
If the correlation is -0.87 and one variable increases by 1 the expected change in the other variable is -0.87
False becouse correlation does mesure their relationship but the strength of their covariance. The only thing we get is that the relationship is a strong negative one.