1 / 10

The KPK Excel Macros

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

Thomas
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)

    2. The DSCI 2710 Website

    3. The Excel Macros

    4. Going to Excel Options Then press Excel Options

    5. Managing Add-Ins

    6. Adding Data Analysis Toolpack

    7. Data Analysis is now available!

    8. Opening a Macro file To enable macros, press Options

    9. Opening a Macro file

    10. Running the Macros

    11. Running the Macros

More Related