Analysis Toolbox Ad-in for charts
 

Hi -

I am trying to create a histogram with relative frequency using a 10-point
interval to show distribution of some scores. My book suggests I click on
tools data analysis and choose my range numbers from the list. However the
add-in does not exist on my current tool bar. When I click on "ad-ins" my box
is empty. When I click browse to find what I need, I have no ad-ins to add
on.

I went to Microsoft Office.com and there is no download for the data
analysis toolbox. Any help would be greatly appreciated.

Tnx Red

Analysis Toolbox Ad-in for charts
 

You need the original CD. Run setup, and somewhere you get the choice to
reinstall or maybe repair. The Analysis ToolPak is buried somewhere in the
tree view of items you can select.

You can also make your own histograms:

http://peltiertech.com/Excel/Charts/Histograms.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Redflowers" wrote in message
...
Hi -

I am trying to create a histogram with relative frequency using a 10-point
interval to show distribution of some scores. My book suggests I click on
tools data analysis and choose my range numbers from the list. However
the
add-in does not exist on my current tool bar. When I click on "ad-ins" my
box
is empty. When I click browse to find what I need, I have no ad-ins to add
on.

I went to Microsoft Office.com and there is no download for the data
analysis toolbox. Any help would be greatly appreciated.

Tnx Red

Analysis Toolbox Ad-in for charts
 

So how would I add information in for a Least Squares line?

Thanks.
Jenn

"Redflowers" wrote:

Hi -

I am trying to create a histogram with relative frequency using a 10-point
interval to show distribution of some scores. My book suggests I click on
tools data analysis and choose my range numbers from the list. However the
add-in does not exist on my current tool bar. When I click on "ad-ins" my box
is empty. When I click browse to find what I need, I have no ad-ins to add
on.

I went to Microsoft Office.com and there is no download for the data
analysis toolbox. Any help would be greatly appreciated.

Tnx Red

Analysis Toolbox Ad-in for charts
 

If the data is charted, you can add a trendline. Right click on the series
and select the obvious command, and set the appropriate options. Then if you
double click on the trendline, you can adjust the options.

If the data is in the worksheet you can get the parameters into the sheet.
For a simple first order linear relationship you can use:

=SLOPE({y-range},{x-range})
=INTERCEPT({y-range},{x-range})
=CORREL({y-range},{x-range})

to get the slope, Y-intercept, and Pearson correlation coefficient R, for X
and Y data ranges.

For a more complex relationship, or to get more information from it, use
LINEST. Check the online help or this web page:

http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Redflowers" wrote in message
...
So how would I add information in for a Least Squares line?

Thanks.
Jenn

"Redflowers" wrote:

Hi -

I am trying to create a histogram with relative frequency using a
10-point
interval to show distribution of some scores. My book suggests I click on
tools data analysis and choose my range numbers from the list. However
the
add-in does not exist on my current tool bar. When I click on "ad-ins" my
box
is empty. When I click browse to find what I need, I have no ad-ins to
add
on.

I went to Microsoft Office.com and there is no download for the data
analysis toolbox. Any help would be greatly appreciated.

Tnx Red