AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
![]() 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 You can clearly see that the maximum value is when x = 20.Ģ. The above trendline equation is entered in column A, from A7 through A26. ![]() A linear trendline usually shows that something is increasing or decreasing at a steady rate. Your data is linear if the pattern in its data points looks like a line. The chart has X-values in column B, from B7 through B26. Use this type of trendline to create a best-fit straight line for simple linear data sets. On the chart in the uploaded workbook, the trendline equation for Series 1 is : ![]() 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 : To follow this, download the file, and see how things work.ġ. ![]()
0 Comments
Read More
Leave a Reply. |