![]() ![]() ![]() The syntax for the LINEST function is LINEST( known_y's, , , ) where known_y's and known x's can be drag entered, the can have the values of TRUE where the intercept is treated normally or FALSE where the intercept is set to have the value of 0, and the can have the values of True where a set of regression statistics is returned with the slope and intercept or FALSE where the regression statistics are not returned. Once you have your data entered in Excel, highlight a blank area of 2 columns by 5 row and type =LINEST. Regression analysis is generally used to see if there is a statistically significant relationship between two sets of variables. The LINEST function is standard in Excel on both Macs and PC's and a version of it is available in Google docs. the null hypothesis and conclude there is a linear correlation between. To obtain the slope and the y-intercept, along with additional statistical details, you can use the LINEST function. Additional Regression Information with the Analysis ToolPak (Windows Users). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |