Trend watch

  • Thread starter Thread starter John
  • Start date Start date
J

John

Can excell help me with looking at trends. I guess I am
asking for help maybe an IF statement will work. Is there
a better way??????

Thanks for your help
John

Question: When B1 is +ve and A2-A1 also positive "Option
1"? OR If B1 is -VE and A2-A1 also -VE "Option 2"? B1 is
+ve but A2-A1 Negative "Option 3"? B1 is -VE and A2-A1 is
Positive "Option 4" How can I catch all this and see if
excell can catch if there is a trend?

Lets say I have two sets of numbers
Example:

A B
73.38 12
72.97 123
73.21 -130
73.37 -141
72.71 -554
71.39 0.54
71.58 118
72.07 106
72.45 178
 
John,

<<Can excell help me with looking at trends. I guess I am asking for help
maybe an IF statement will work. Is there a better way??????>>

Graph the two sets of data together and look at them. Is there a trend?

You can use Excel to do a regression analysis analysis (see XL help).

Regards,
Kevin
 
John,

10,000 lines should still be easy to read. You might want to turn off data
markers (not sure that is the correct term--actual data point "dots"--you
just want the line). The first thing you should do in statistics is to look
at your data in graphical form, so you know what you are trying to
accomplish. Perhaps you have a few strange sets of data that do not belong
with the others--outliers. Anyway, I would graph the data as my first step.

Regression

Tools | Add-ins | Analysis ToolPak ... then

Tools | Data Analysis | Regression and follow the steps

You can look at XL's help for further information for general assistance or
come back here for more specific requests.

Regards,
Kevin
 
Thanks Kevin
-----Original Message-----
John,

10,000 lines should still be easy to read. You might want to turn off data
markers (not sure that is the correct term--actual data point "dots"--you
just want the line). The first thing you should do in statistics is to look
at your data in graphical form, so you know what you are trying to
accomplish. Perhaps you have a few strange sets of data that do not belong
with the others--outliers. Anyway, I would graph the data as my first step.

Regression

Tools | Add-ins | Analysis ToolPak ... then

Tools | Data Analysis | Regression and follow the steps

You can look at XL's help for further information for general assistance or
come back here for more specific requests.

Regards,
Kevin






.
Click to expand...
 
Back
Top