![]() Subject to the Constraints : $B$7 >= 0, $B$7 <= 20Ĭlick on OK, and you will find that the Solver presents the same solution. The second method is to use the Solver add-in assuming you already have this installed and added to Excel, click on the Solver button when the dialog box comes up, put in the following data :Įqual To : click on the Max option button TREND returns the y-values along that line for the array of newx's that you specify. It fits a straight line (using the method of least squares) to the array's knowny's and knownx's. You can clearly see that the maximum value is when x = 20.Ģ. The TREND function returns values along a linear trend. The above trendline equation is entered in column A, from A7 through A26. The chart has X-values in column B, from B7 through B26. On the chart in the uploaded workbook, the trendline equation for Series 1 is : Tip Excel rounds the trendline equation to make it more. Once you have selected the trendline option for a particular series, ensure that in the More Options dialog box for the trendline, the following checkbox is checked : For a moving average trendline, you cannot display the trendline equation or the R-squared value. ![]() To follow this, download the file, and see how things work.ġ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |