The KPK Excel Macros. The textbook authors have written a set of Excel macros An Excel macro carries out statistical calculations or constructs a statistical chart Since Excel has very few built-in statistical options, these macros were necessary
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Left click here to obtain the Excel macros. Then select Save File to save this file on your hard drive.
Click here to obtain the Excel macros and data files for taking an Excel Quiz
The address is: www.cob.unt.edu/itds/courses/dsci2710
Click here to obtain the Excel macros
Right click this.
Select “Save Target As”
Save this file on your hard drive
Suggestion: Create a shortcut to this file on your computer desktop
Then press Options
In Excel 2010, start by clicking on File
Select to Manage Add-ins and press Go
Analysis Toolpakand Analysis Toolpak– VBA, then click OK. The first time around, some configuration may be necessary
Excel’s Data Analysis menu is available under Data
Select the desired Data Analysis method
To enable macros, press Enable Macros
In Excel 2010, when you open a macro file, a security warning appears here
Click on the Add-Ins tab and you will see the Excel macros
Important Note: These macros will not run on a Mac.
This is the path to use the Histogram macro.