- #1
Plasma
- 37
- 0
I have a graph of values, and I am trying to add an exponential trendline, but it won't allow me. Can anybody help?
Integral said:So what happens when you try to add the trendline?
I assume you are clicking on the ploted data series then selecting the chart menu and then add trendline
Plasma said:After Add-ins, it still doesn't work.
FredGarvin said:Just for kicks, did you try loading in the analysis toolpack add on? I have never seen a trendline option grey'd out like you are mentioning.
What does the data look like when it is plotted? What kind of plot are you trying to put the trendline in? I would first suggest you make sure that the plot is in an "xy scatter" and not a generic "line" format.
In addition, the Analysis ToolPak add-in provides a special set of
analysis tools, including tools to accomplish the following tasks.
Use this
To do this analysis tool
-------------------------------------------------------
Predict a value based on the forecast Exponential
for the prior period, adjusted for the Smoothing
error in that prior forecast
Project values in the forecast period Moving Average
based on the average value of the
variable over a specific number of
preceding periods
Perform linear regression analysis and Regression
return statistics and plots as specified
Table 2--Analysis ToolPak Add-in Features
To Use the Analysis ToolPak
---------------------------
In Microsoft Excel 5.0 and later:
1. On the Tools menu, click Data Analysis.
2. If the Data Analysis command is not available, click Add-Ins on the
Tools menu. In the Add-Ins dialog box, click to select the Analysis
ToolPak check box.
NOTE: If the Analysis ToolPak add-in is not listed, run the Setup program,
choose Add/Remove, and select the Add-ins option for Microsoft Excel.
In Microsoft Excel 4.0:
1. On the Options menu, click Analysis Tools.
2. If the Analysis Tools command is not available, click Add-In on the
Options menu. In the Add-Ins dialog box, click Add. Click Analysis.xla
in the Library\Analysis folder.
3. In the Data Analysis dialog box, choose the tool that you want to use,
such as Exponential Smoothing. For help on how to use a particular
analysis tool, click Help in the dialog box for the tool.
berkeman said:Aside hijack...
Hey Fred -- what is your new avatar? It looks like a mil patch. I have two new mil patches on my office door from my FTO colonel Steve from SJPD who re-deployed for a year with his Special Forces unit a few months ago. He was our FTO for my latest work ERT training evolution -- great and challenging stuff. Godspeed colonel Steve. Talk at you when you get back.
AlephZero said:Your last data point seems to have Y = 0. For exponential data fitting all Y values have to be > 0 (because the maths involves taking logs of the Y values)
I tried a test with Excel, with and without a Y=0 point in the data set. If you remove the point you should get the exponential option in the menu.
Your last data point seems to have Y = 0. For exponential data fitting all Y values have to be > 0 (because the maths involves taking logs of the Y values)
expList = Table[{x, Exp[-x]}, {x, .1, 2.1, .1}];
FindFit[expList, A Exp[- c x], {c, A}, x]
{c -> 1., A -> 1.}
expList = Insert[expList, {Random[Real, {0.1, 2.1}], 0} , Random[Integer, {1, 20}]];
FindFit[expList, A Exp[- c x], {c, A}, x]
{c -> 1.07562, A -> 1.01937}
To format cells in Excel, select the cells you want to format and click on the "Home" tab. In the "Number" section, you can choose different formatting options such as number, currency, date, and more. You can also customize the formatting by clicking on the "More Number Formats" option.
To create a chart in Excel, select the data you want to include in the chart and click on the "Insert" tab. In the "Charts" section, choose the type of chart you want to create. Excel will automatically generate a chart based on your data. You can also customize the chart by clicking on it and using the "Chart Design" and "Chart Format" tabs.
To use formulas in Excel, click on the cell where you want to enter the formula and start with an equal sign (=). You can then select the cells you want to include in the formula, or type in the values manually. Excel also has a function library that allows you to use more complex formulas for calculations.
To sort data in Excel, select the data you want to sort and click on the "Data" tab. In the "Sort & Filter" section, click on the "Sort" button. You can choose to sort by one or multiple columns and in either ascending or descending order. You can also add levels to your sorting criteria.
To freeze rows and columns in Excel, select the row or column below or to the right of the rows or columns you want to freeze. Click on the "View" tab and click on the "Freeze Panes" button in the "Window" section. You can choose to freeze the top row, first column, or both. This will keep those rows or columns visible even when scrolling through large amounts of data.