Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Linest function: data not being selected in formula
Since upgrading from 2002 to 2003 a spreadsheet that worked is now not
working correctly. The formula is not calculating the selected data correctly. The formula is =INDEX(LINEST(D12:O16,D37:O41,,FALSE),1) Excel is having a problem selecting data on multiple rows. A test has been carried out when the data was moved into one column or one row and it worked. It appears excel is now only taking into account the first row of data. Is there an option that needs to be selected for it to work? The help files were compared between the versions of excel and there is no difference. The objective of the formula is to calculate a regression line. If you require more information please ask. Thank you Nathan |
#2
|
|||
|
|||
Linest function: data not being selected in formula
Please can anyone help me solve this problem.
Use linest function to estimate what A,B,C & D will be, Compare them. Y= a+bx+cx^2+dx^3 assum x=0, x=1, .................. x= 100 Calculate the corresponding value of Y. Choose any coefficient for the constant. Thanks and regards, Dave "NathanG" wrote: Since upgrading from 2002 to 2003 a spreadsheet that worked is now not working correctly. The formula is not calculating the selected data correctly. The formula is =INDEX(LINEST(D12:O16,D37:O41,,FALSE),1) Excel is having a problem selecting data on multiple rows. A test has been carried out when the data was moved into one column or one row and it worked. It appears excel is now only taking into account the first row of data. Is there an option that needs to be selected for it to work? The help files were compared between the versions of excel and there is no difference. The objective of the formula is to calculate a regression line. If you require more information please ask. Thank you Nathan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Web Services function call and data refreshing | Excel Worksheet Functions | |||
Using INDIRECT function to specify source data | Charts and Charting in Excel | |||
How do I access data stored in a SQL server for vlookup function? | Excel Worksheet Functions | |||
Charting data ranges that change | Charts and Charting in Excel | |||
how can i get the slope function to ignore missing data? | Excel Discussion (Misc queries) |