(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 DocumentRight 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 DocumentRight 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 DocumentRight 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 DocumentRight 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 DocumentRight 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! Excels 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

This note was uploaded on 01/13/2012 for the course DCSI 3710 taught by Professor Pavur during the Fall '11 term at North Texas.

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
Ask a homework question - tutors are online