So, Excel automatically turns a number in scientific notation if the cell width is not sufficient for the number. Sometimes, you might want to stop this auto converting of numbers into scientific notation. When cells are in general format, you can type scientific notation directly. Enter the number, plus e, plus the exponent. If the number is less than zero, add a minus sign before the exponent. Note that Excel will automatically use Scientific format for very large and small numbers of 12 or more digits. David wrote: I am having an issue with Microsoft Excel 2010. After creating a trendline and trendline formula from a graph, the resulting trendline formula is reported in scientific notation. This formula is not specific enough for my needs. The formula is y = 2E+07x^-1.563. I need the 2E+07 or 20,000,000 to be more specific, such as 21,346,789 or what ever the case may be. I am not sure what you mean by 'not specific enough'. It appears that you want to see greater precision. But do you also want to see a different format other than Scientific? IMHO, in general, Scientific format is the best format to use in the trendline formulas. This is because the range of the coefficients can vary widely. In any case, you can select the format interactively as follows. • Click on the trendline formula. That should select the trendline formula 'data label' (object). • Right-click and click on Format Trendline Label. • Click on Number on the left if necessary. • Then select the numeric format from Category, as you would when formatting a cell. I would choose Scientific with 14 decimal places in order to see the greatest precision that Excel will format. FYI, if your intention is to use the displayed values as coefficients in formulas, there might be a better way using the LINEST or LOGEST function. Let us know if you are interested in this alternative. Thank you for those replies. Upon further review, I believe I am mistaken. Latest raw support for sierra 10.12.6 mac rumor. I believe my assumption that the formula was not specific enough is incorrect. The formula does report reasonable values for the range of data that I have included in the graph. ![]() However, I need a formula to estimate a value that is outside of the range of data that I have. In this estimation, I would use a 'x' value that is roughly twice any hard data that I have. I have tried to do this with a variety of the trendline types. Exponential is the only one that reports a reasonable value for my situation. Can LINEST or LOGEST help in this situation? Are their any other methods within excel that I could use? Mbox 2 driver download. David wrote: The formula does report reasonable values for the range of data that I have included in the graph. However, I need a formula to estimate a value that is outside of the range of data that I have. In this estimation, I would use a 'x' value that is roughly twice any hard data that I have. I do not understand what you mean by 'twice any hard data'. But perhaps the following will help. David wrote: I have tried to do this with a variety of the trendline types. Exponential is the only one that reports a reasonable value for my situation. Can LINEST or LOGEST help in this situation? First, the trendline formula y = 2E+07x^-1.563 is a 'power' trendline, not an 'exponential' trendline, as Excel uses those terms. If your x data are in A1:A10 and your y data are in B1:B10, select two horizontal cells (e.g. E1 and F1) and aray-enter the following formula (press ctrl+shift+Enter instead of just Enter): =LINEST(LN(B1:B10),LN(A1:A10)) Then for any x in A11 (e.g.), the estimated y is derived by the formula: =EXP($E$1)*A11^$F$1 You can confirm the formula by entering the following into C1 and copying down through C10: =EXP($E$1)*A1^$F$1 Note: Typically, the values in C1:C10 will not match B1:B10 exactly. But if you add a series for C1:C10 to your chart, the values should closely match the 'power' trendline. It might not match exactly because Excel does not use LINEST in this way to derive the trendline. In order to use LINEST with other types of trendline formulas, see ----- If that does resolve your problem to your satisfaction, I suggest that you upload an example Excel file (devoid of any private data) that demonstrates the problem to a file-sharing website. Ideally, include an explanation and an example with the result that you are looking for.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |