VehiclesFashionRecipesBlogsHuntTravelsSportFunHandmadeITEducation
Mini-Games
x

x
zakruti.com » IT - Software » Geeks Tutorial
How to Use the LINEST Function in Excel 2016

How to Use the LINEST Function in Excel 2016

FBTwitterReddit

video description

Rating: 4.0; Vote: 1
were going to show you how to use the LINEST) function in Excel 2016. LINEST) is used for linear regression among other statistics. You will need a set of known X values and known Y values to calculate the regression. For this example: =LINEST(B2: B5, A2: A5, TRUE) will result in (if multiple cells are selected and used in the array) 10 different statistics according to the line in question
Date: 2023-07-08

Comments and reviews: 5


I've been trying to get the extended stats for almost an hour now, you said something about control shift enter and some array, but I can't figure out what you're doing to save my life or my lab grade: (
reply

the thumbnail has a cubic graph but you choose to show linest with a linear function when the trendline and r values can already be calculated through the graph
reply

Very useful. Almost feels like when you find the whistle in mario brothers 3 hidden behind the map that takes you to the last level.
reply

Appreciate the vid even tho its 2 years later! I always do the formula right but it wouldnt copy correctly to the other cells.
reply

why my linest function only shows one value? I type the formula and also press CRTL+SHIFT+ENTER but still shows only one value
reply
Add a review, comment






Other channel videos