1 / 11

The KPK Excel Macros

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 Presentation

The KPK Excel Macros

An Image/Link below is provided (as is) to download presentation 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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. 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 • These macros are available at the DSCI 2710 website (address in the syllabus) or in Blackboard Learn

  2. KPK macro’s from Blackboard Learn 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

  3. KPK Macros from the DSCI 2710 Website The address is: www.cob.unt.edu/itds/courses/dsci2710 Click here to obtain the Excel macros

  4. 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

  5. Going to Excel Options Then press Options In Excel 2010, start by clicking on File 2 1

  6. Managing Add-Ins Select Add-Ins 3 4 Select to Manage Add-ins and press Go

  7. Adding Data Analysis Toolpack Check Analysis Toolpakand Analysis Toolpak– VBA, then click OK. The first time around, some configuration may be necessary 5

  8. Data Analysis is now available! Excel’s Data Analysis menu is available under Data 6 7 Select the desired Data Analysis method

  9. Opening a Macro file To enable macros, press Enable Macros In Excel 2010, when you open a macro file, a security warning appears here 1 2

  10. Running the Macros Click on the Add-Ins tab and you will see the Excel macros Important Note: These macros will not run on a Mac.

  11. Running the Macros This is the path to use the Histogram macro.

More Related