the kpk excel macros n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
The KPK Excel Macros PowerPoint Presentation
Download Presentation
The KPK Excel Macros

Loading in 2 Seconds...

play fullscreen
1 / 11

The KPK Excel Macros - PowerPoint PPT Presentation


  • 124 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'The KPK Excel Macros' - ula


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
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
  • These macros are available at the DSCI 2710 website (address in the syllabus) or in Blackboard Learn
kpk macro s from blackboard learn
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

kpk macros from the dsci 2710 website
KPK Macros from the DSCI 2710 Website

The address is: www.cob.unt.edu/itds/courses/dsci2710

Click here to obtain the Excel macros

the excel macros
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

going to excel options
Going to Excel Options

Then press Options

In Excel 2010, start by clicking on File

2

1

managing add ins
Managing Add-Ins

Select Add-Ins

3

4

Select to Manage Add-ins and press Go

adding data analysis toolpack
Adding Data Analysis Toolpack

Check

Analysis Toolpakand Analysis Toolpak– VBA, then click OK. The first time around, some configuration may be necessary

5

data analysis is now available
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
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

running the macros
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.

running the macros1
Running the Macros

This is the path to use the Histogram macro.