Analysis Toolbox Ad-in for charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top