Graphs and Linear and Non-Linear Fit
 |
| (Credits to the owner) |
To create the graph, we need to have the variables of data in a table. From the data, only then we can make the graph.
If we are using Microsoft Excel as our program, we can find the standard deviation, variance and average by just inserting these following keys into the cells;
Standard Deviation : =STDEV(insert cell number)
Variance : =VAR(insert cell number)
Average : =AVERAGE(insert cell number)
The following image are the example on how to search for the variance.
After finding the variance,standard deviation and average of the data, we can continue with our graph. Choose the scattered form of graph. From the graph that has been plotted, we can make the linear regression or non-linear regression.But, what is linear and non-linear regression?
 |
| Non-linear regression |
 |
| Linear regression |
Linear regression is the curve fitting for relationships that are best approximated by a straight line, while non-linear regression is the variables that are best approximated by a curved.
From the regression, we can find the correlation coefficient, r , whereby, if the r is positive, it means that it has a positive linear correlation, and if the r is negative, it means that it is a negative linear correlation. Next, we can also search the coefficient of determination, r squared , that shows us the fluctuation of one variable compared to another variable. It shows us the percent of data that is the closest to the line of best fit. For example, if the r is 0.5. the r squared is 0.25.This means that only 25% of the total variation can be explained between the relationship of the variables, while the remainder of 85% is still remained unexplained.
To conclude, the graph can simply be made just by completing the data of variables, and just from the graph, there are so many information that can be spelled out in order for us to know them. We do not need to use the calculator to find the answers, but all we need to do is to learn on how to use the technology, and our life will be easier ☺.
❤ "Graphs and Linear and Non-Linear Fit" was Posted On: Thursday, March 2, 2017 @8:49 AM | 0 lovely comments ✿
« Older posts | Newer posts»
Graphs and Linear and Non-Linear Fit
|
| (Credits to the owner) |
To create the graph, we need to have the variables of data in a table. From the data, only then we can make the graph.
If we are using Microsoft Excel as our program, we can find the standard deviation, variance and average by just inserting these following keys into the cells;
Standard Deviation : =STDEV(insert cell number)
Variance : =VAR(insert cell number)
Average : =AVERAGE(insert cell number)
The following image are the example on how to search for the variance.
After finding the variance,standard deviation and average of the data, we can continue with our graph. Choose the scattered form of graph. From the graph that has been plotted, we can make the linear regression or non-linear regression.But, what is linear and non-linear regression?
|
| Non-linear regression |
|
| Linear regression |
Linear regression is the curve fitting for relationships that are best approximated by a straight line, while non-linear regression is the variables that are best approximated by a curved.
From the regression, we can find the correlation coefficient, r , whereby, if the r is positive, it means that it has a positive linear correlation, and if the r is negative, it means that it is a negative linear correlation. Next, we can also search the coefficient of determination, r squared , that shows us the fluctuation of one variable compared to another variable. It shows us the percent of data that is the closest to the line of best fit. For example, if the r is 0.5. the r squared is 0.25.This means that only 25% of the total variation can be explained between the relationship of the variables, while the remainder of 85% is still remained unexplained.
To conclude, the graph can simply be made just by completing the data of variables, and just from the graph, there are so many information that can be spelled out in order for us to know them. We do not need to use the calculator to find the answers, but all we need to do is to learn on how to use the technology, and our life will be easier ☺.
❤ "Graphs and Linear and Non-Linear Fit" was Posted On: Thursday, March 2, 2017 @8:49 AM | 0 lovely comments ✿
« Older posts | Newer posts»
