software

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?

Alice -

gt; Using Microsaoft Excel 2003, trying to construct a correlogram using data
gt; analysis tool pak. Will only accept 255 values .. i have 339. Is there
gt; another way to do this, i know it can be done .. but how? lt;

Please provide more details about what you are trying to do and what is
happening or not happening.

There is no feature named quot;correlogramquot; 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
Using Dara analysys tool pak, i am attempting tro put data from cells A2:A330
into a corellogram, that is my
'input dataquot;, 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!

quot;Mike Middletonquot; wrote:

gt; Alice -
gt;
gt; gt; Using Microsaoft Excel 2003, trying to construct a correlogram using data
gt; gt; analysis tool pak. Will only accept 255 values .. i have 339. Is there
gt; gt; another way to do this, i know it can be done .. but how? lt;
gt;
gt; Please provide more details about what you are trying to do and what is
gt; happening or not happening.
gt;
gt; There is no feature named quot;correlogramquot; in Excel. The word sometimes refers
gt; to a scatter plot or to some other graphical method of showing
gt; relationships. There is the Correlation tool of the Analysis ToolPak.
gt;
gt; - Mike
gt; www.mikemiddleton.com
gt;
gt;
gt;

Alice -

What do you mean by quot;corellogramquot;?

It seems you have data for a single variable. What do you mean by quot;the
relationship the data has between each valuequot;?

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

quot;Alicequot; gt; wrote in message
news
gt; Using Dara analysys tool pak, i am attempting tro put data from cells
gt; A2:A330
gt; into a corellogram, that is my
gt; 'input dataquot;, my oyt put is on another worksheet, something like K2.
gt; Excel
gt; wont allow me to do this. I want to display the relationsgip the data has
gt; between each value.
gt; I have only been using excel for 3 months!
gt;
gt; quot;Mike Middletonquot; wrote:
gt;
gt;gt; Alice -
gt;gt;
gt;gt; gt; Using Microsaoft Excel 2003, trying to construct a correlogram using
gt;gt; gt; data
gt;gt; gt; analysis tool pak. Will only accept 255 values .. i have 339. Is
gt;gt; gt; there
gt;gt; gt; another way to do this, i know it can be done .. but how? lt;
gt;gt;
gt;gt; Please provide more details about what you are trying to do and what is
gt;gt; happening or not happening.
gt;gt;
gt;gt; There is no feature named quot;correlogramquot; in Excel. The word sometimes
gt;gt; refers
gt;gt; to a scatter plot or to some other graphical method of showing
gt;gt; relationships. There is the Correlation tool of the Analysis ToolPak.
gt;gt;
gt;gt; - Mike
gt;gt; www.mikemiddleton.com
gt;gt;
gt;gt;
gt;gt;