Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
how do i construct a correlogram in excel?
Using Microsaoft Excel 2003, trying to construct a correlogram using data
analysis tool pak. Will only accept 255 values .. i have 339. Is there another way to do this, i know it can be done .. but how? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
how do i construct a correlogram in excel?
Alice -
Using Microsaoft Excel 2003, trying to construct a correlogram using data analysis tool pak. Will only accept 255 values .. i have 339. Is there another way to do this, i know it can be done .. but how? < Please provide more details about what you are trying to do and what is happening or not happening. There is no feature named "correlogram" in Excel. The word sometimes refers to a scatter plot or to some other graphical method of showing relationships. There is the Correlation tool of the Analysis ToolPak. - Mike www.mikemiddleton.com |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
how do i construct a correlogram in excel?
Using Dara analysys tool pak, i am attempting tro put data from cells A2:A330
into a corellogram, that is my 'input data", my oyt put is on another worksheet, something like K2. Excel wont allow me to do this. I want to display the relationsgip the data has between each value. I have only been using excel for 3 months! "Mike Middleton" wrote: Alice - Using Microsaoft Excel 2003, trying to construct a correlogram using data analysis tool pak. Will only accept 255 values .. i have 339. Is there another way to do this, i know it can be done .. but how? < Please provide more details about what you are trying to do and what is happening or not happening. There is no feature named "correlogram" in Excel. The word sometimes refers to a scatter plot or to some other graphical method of showing relationships. There is the Correlation tool of the Analysis ToolPak. - Mike www.mikemiddleton.com |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
how do i construct a correlogram in excel?
Alice -
What do you mean by "corellogram"? It seems you have data for a single variable. What do you mean by "the relationship the data has between each value"? Or, do you have time sequence data for a single variable (in which case you may want to look at lagged relationships)? Please explain the nature of your data and the kind of analysis you want. - Mike www.mikemiddleton.com "Alice" wrote in message ... Using Dara analysys tool pak, i am attempting tro put data from cells A2:A330 into a corellogram, that is my 'input data", my oyt put is on another worksheet, something like K2. Excel wont allow me to do this. I want to display the relationsgip the data has between each value. I have only been using excel for 3 months! "Mike Middleton" wrote: Alice - Using Microsaoft Excel 2003, trying to construct a correlogram using data analysis tool pak. Will only accept 255 values .. i have 339. Is there another way to do this, i know it can be done .. but how? < Please provide more details about what you are trying to do and what is happening or not happening. There is no feature named "correlogram" in Excel. The word sometimes refers to a scatter plot or to some other graphical method of showing relationships. There is the Correlation tool of the Analysis ToolPak. - Mike www.mikemiddleton.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Excel MDI/SDI/Excel Instance to behave more logically | Setting up and Configuration of Excel | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |