Analysis Toolbox Ad-in for charts

[Redflowers]

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

 

[Jon Peltier]

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

 

[Redflowers]

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

Thanks.
Jenn

 

[Jon Peltier]

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