{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

(4) The Excel Macros

(4) The Excel Macros - 3 Select to Manage Add-ins and press...

Info iconThis preview shows pages 1–11. Sign up to view the full content.

View Full Document Right Arrow Icon
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)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
The DSCI 2710 Website The address is: www.cob.unt.edu/itds/courses/dsci2710 Click here to obtain the Excel macros
Background image of page 2
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
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Going to Excel Options Then press Excel Options In Excel 2007, start by clicking on the Office button 1 2
Background image of page 4
Managing Add-Ins Select Add-Ins
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Background image of page 6
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Background image of page 8
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Background image of page 10
Background image of page 11
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 3 Select to Manage Add-ins and press Go 4 Adding Data Analysis Toolpack Check Analysis Toolpak and Analysis Toolpak – VBA , then click OK . The first time around, some configuration may be necessary 5 Data Analysis is now available! Excel’s Data Analysis menu is available under Data 6 7 Select the desired Data Analysis method Opening a Macro file To enable macros, press Options In Excel 2007, when you open a macro file, the security warning appears here 1 2 Opening a Macro file Select “ Enable this content ,” and then click OK. 3 Running the Macros Click on the Add-Ins tab and you will see the Excel macros Running the Macros This is the path to use the Histogram macro....
View Full Document

{[ snackBarMessage ]}

Page1 / 11

(4) The Excel Macros - 3 Select to Manage Add-ins and press...

This preview shows document pages 1 - 11. Sign up to view the full document.

View Full Document Right Arrow Icon bookmark
Ask a homework question - tutors are online