![]() ![]() ![]() ![]() Known_data_x - The values of the independent variable(s) corresponding with known_data_y. if known_data_y is a single row, each row in known_data_x is interpreted as a separated independent value, and analogously if known_data_y is a single column. If known_data_y is a one-dimensional array or range, known_data_x may represent multiple independent variables in a two-dimensional array or range. If known_data_y is a two-dimensional array or range, known_data_x must have the same dimensions or be omitted. Known_data_y - The array or range containing dependent (y) values that are already known, used to curve fit an ideal linear trend. LINEST(B2:B10, A2:A10, FALSE, TRUE) Syntax ![]() Given partial data about a linear trend, calculates various parameters about the ideal linear trend using the least-squares method. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |