Excel-add-ins - row(3 For Excel 2010 load the Analysis...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Dear All, Here are some tips regarding how to draw histograms using Excel. Let's focus on Excel 2007 (Windows) in (1) and (2). See (3) for Excel 2010. (1) Activate ``data analysis'' as add-ins: -- click on the circle at the upper left corner in Excel; -- click on ``Excel options'' on the bottom blue bar; -- in the pop-out window, click on ``add-ins''; -- you should see ``analysis toolpak'' there, if it's listed as ``inactive'', then move to the bottom row, and click on ``go'' (on the right of ``Excel add-ins''); -- in another pop-out window, make sure ``analysis add-ins'' is checked, click on ``OK''; -- if you are asked to install something, do it; -- ``analysis add-ins'' will be activated. (2) Now you open Excel, click on ``data'', then ``data analysis'' should appear on the rightmost column below the top
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: row. (3) For Excel 2010, load the Analysis ToolPak as follows: Step 1. Click the File tab, click Options, and then click the Add-Ins category. Step 2. In the Manage box, select Excel Add-ins and then click Go. Step 3. In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK. Tip: If Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate it. If you are prompted that the Analysis ToolPak is not currently installed on your computer, click Yes to install it. With ``data analysis'' in your Excel, you can do various statistical analyses: histogram, numerical summaries, etc. Hope this instruction helps . .. Chuanshu Ji...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online