Trendline Value in Excel

MS EXCEL

    Sponsored Links

    Next

  • 1. Protected Cells in OfficeX2004 but not Windows Office
    I'm having trouble accessing cells in a spreadsheet created in Windows Excel. There are a number of cells that should be protected and are, but I also don't have access to over half the cells I should have access to. These cells are not protected when the document is opened on a Windows based machine. Any ideas?
  • 2. 2007 Excel Hack
    Is there a patch or download that MAC users can get so we can open the new Windows Office 2007 .xlsx files? I have the latest version Office 2004. Thanks
  • 3. Excel cannon complete this task with available resources...
    This happens with just one of my files whenever I try to save it. Once I click "save" the message will appear. I've looked online for potential fixes but most of them don't seem to apply to me. I don't use names, pivot tables, etc. The file is large with about 12 different worksheets in the workbook, but I have larger files that I regularly use without this problem. Any help would be greatly appreciated! Let me know what additional information would be helpful, thanks!
  • 4. Excel: Can I use absolute or relative references to.....
    I have a hundreds of rows of information in an Excel worksheet: product #, desscription, pricing, etc... the data in each row is unique to the product # at the beginning of that row. I'll call this 'SHEET 1' My goal is to create another worksheet (I'll call this 'SHEET 2') that will allow me to input a product # (from the 'SHEET 1') and have the rest of the data (from the 'SHEET 1' row) poplate into 'SHEET 2'. I'm not sure this makes sense. I have looked into absolute references and it might work, but it seems like it'd only work per field - I don't know how to do it for a whole row of data. Any ideas? Thanks.
  • 5. Concatenate & IF Function
    Hello, I have a cell formula, E2, that concatenates several cells to establish a file name. =+$A2&"_"&$B2&"_"&$C2&"_"&$D2&"BPM"&".mp3" However, if D2, which normally contains a 2 to 3 number entry (120) is blank, I would like the formula to drop "_"&$D2&"BPM"& from the resulting file name. If entry found in D2, Jazz_Combo_Live_120BPM.mp3 If no entry found in D2, Jazz_Combo_Live.mp3 What is the best way to solve this? Not sure how to exactly construct a concatenation with an IF function. Thank you, Scott

Trendline Value in Excel

Postby Kazuma122 » Sat, 10 Jan 2009 14:12:37 GMT

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hello all,

I am still getting acclimated to using Excel 2008 and had an issue with the trendline chart and was hoping someone could help me.

The issue that I have is I want to get the values of the future periods from the trendline created. I tried looking in the chart menu, but they did not have it or maybe I am looking in the wrong place.

The next option I tried was using either the growth/trend/forecast function. I found some tutorials online, but I think I may be using these array formulas incorrectly (I am using the ctrl+shift+enter command to put them in, but I am still getting the incorrect value). Maybe there is another step for Excel on the Mac that I am unaware of?

To make a long story short, I need help pulling trendline number values off the chart. If anyone can help me, I greatly appreciate it.

Take Care,

Kazu~

Re: Trendline Value in Excel

Postby Mike Middleton » Sun, 11 Jan 2009 10:35:07 GMT

Kazu~  -


Consider using worksheet functions, described by John Walkenbach at

 http://www.**--****.com/ 

-  Mike Middleton
 http://www.**--****.com/ 
Excel Add-ins and Books for Data Analysis and Decision Analysis










Similar Threads:

1.How to get the trendline values in excel 03 direct into cells

Thanks for the answer, however my challenge is to have a 'dynamic' 
regression, meaning that if I would like to omit some data points (which I do 
by the 'hide' function) I get a new slope on the plot from the trendline 
function. How can I get hold of this new slope to be used in further 
calculations ? (Or is it possible to have the slope function dynamic, meaning 
that the hided values are omitted from the 'x and y's ?

Thanks in advance

Regards
Ole Nygaard

"David Biddulph" wrote:

> "nygaard" < XXXX@XXXXX.COM > wrote in message 
> news: XXXX@XXXXX.COM ...
> > In regression analysis the gradient is used for further analysis. By 
> > hiding
> > values (coloumns) the number of points in the trend analysis varies and 
> > the
> > gradient changes. How can the gradient values be transferred to a cell and 
> > as
> > such be used in further analysis / equations ?
> 
> Assuming that you are using a linear trend line, use the LINEST() function.
> -- 
> David Biddulph 
> 
> 
> 

2.How to get the trendline values in excel 03 direct into cells ?

In regression analysis the gradient is used for further analysis. By hiding 
values (coloumns) the number of points in the trend analysis varies and the 
gradient changes. How can the gradient values be transferred to a cell and as 
such be used in further analysis / equations ?

3.logarithmic trendlines using zero values

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

Hi,
I would like to add a logarithmic trendline to my scatter plot. However, when I attempt to do so, i get an error message indicating that some trendline options do not allow zero or negative values. (There is one zero value as the first data point on the x-axis). I have never had this problem with other versions of excel, where zero values were appropriately graphed. The data is clearly best represented using a log scale. Any suggestions?
Thanks.

4.Scope value In trendline chart incorrect

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

Hi, <br>
I have a big problem with a chart I have created a simple chart with this values: <br><br>X                  Y <br>
1.13700	    0.39213 <br>
1.46200	    0.23851 <br>
1.63300	    0.13124 <br>
1.87500	    0.04913 <br><br>and I add a trendline , when I extract the formula the scope value and the interceptor value are wrong, If I try to calculate the same value with excel formule (SCOPE - INTERCEPTOR) I obtain a correct value. <br><br>Do you have an Idea why I have different value, what can I solve the problem? <br><br>Thanks for any suggestion. <br><br>Luca

5.how do you create a trendline for only the x-axis values in excel

How do you create a trendline for only the x-axis values in excel?

6. Excel trendline - get the R2 value by code

7. How generate trendline equations for Power, Exp and Log trendlines

8. How to Show/calculate End-values of Trendline?



Return to MS EXCEL

 

Who is online

Users browsing this forum: No registered users and 20 guest