If you’re not sure how to use a particular function, you can click the 'Help on this function' link at the bottom of the Insert Function dialog box, and that will bring up Excel’s Help. On your spreadsheet select the cells containing the y values by. Note that for each function, this second window will look different. The Excel spreadsheet function linest is a complete linear least squares curve fitting. To select, use the mouse to click on the first cell and drag through the cells you would like to add. The Insert Function dialog box that appears gives you a list of operations that Excel can perform.Ĭhoose a category from 'select a category' (which includes an option to show all), and then choose a particular function from the 'Select a function'.Īnother dialog box opens which asks you to select the cells you would like to involve in the formula. Go to the Formulas ribbon – choose either the Insert Function icon to bring up the Insert Function dialog box (same dialog box you would get with the first method), or click the arrow next to the correct category in the Function Library Group, and then choose the desired function.On the Home ribbon, click on the arrow next to the AutoSum icon and select More Functions.Once there, choose one of the methods below to insert your function: Before you do anything, make sure your cursor is in the cell in which you want the result. There are several ways to insert functions.
