EXCEL
HANDOUT
SETUP INSTRUCTIONS
These instructions were written under some assumptions:
|
You have little or no computer experience. |
|
You will use University computers on campus or your own
computer at some other location. |
|
On campus, you have some memory storage device: a 3
1/2" blank disk or a flash stick. |
|
You will use EXCEL 2007 on campus or either EXCEL 2007
or some earlier versions at other locations (I.e. EXCEL 2003, EXCEL 95 or EXCEL XP). |
THE PRENTICE HALL PHSTAT ADD-IN
The Prentice Hall PHStat Microsoft Excel add-in enhances
Microsoft Excel to better support the statistical analyses taught
in an introductory
statistics course. Using PHStat lessens the technical training needed to use
Microsoft Excel to perform
statistical analysis and allows you to generate results
that would otherwise be very tedious or impossible to produce from
worksheets built from scratch. PHStat requires that “Data
Analysis” is installed on EXCEL and the following system
requirements:
|
-Any Windows 95 (or later) system; Microsoft Excel 95
or Microsoft Excel 97 (or later) |
|
-32 MB of main memory; 64 MB required when running
sampling distribution simulations and data-intensive regression analyses;
approximately 5 MB hard disk free space during setup process and 3MB hard
disk space after installation. |
|
-Preferred Display settings: PHStat will run with any
display settings, but for best results set the Desktop area to 800 by 600
pixels with Small Fonts. (Use the Settings tab of the Display applet of the
Control Panel to change settings.). |
INSTALLING “DATA ANALYSIS” ON EXCEL
For EXCEL 2003 or
earlier version: Click on the
“Tools” tab/pull-down menu and click on “Data Analysis.” If
“Data Analysis” does not appear on the “Tools”
pull-down menu, then click on “Add-Ins” and click on the first two
boxes (“Analysis
ToolPak” and “Analysis ToolPak-VBA”).
Click “OK” and open “Data Analysis.”
For EXCEL 2007: Click on the “Microsoft Office” button in the upper left hand corner of the EXCEL spreadsheet and
click on “EXCEL Options”
in the lower right hand corner of the pull-down
menu. On
the left side of the “EXCEL
Options” page click on
“Add-ins” and then the “Go” button at the bottom of the page. This should open the “Add-ins”
section. Select “Analysis ToolPak” and “Analysis
ToolPak-VBA” and click “OK.”
EXCEL 2003 or
Earlier Versions Macro virus warning dialog box
If
Excel will not open PHStat, Double click on “Tools”, “MACRO”, “Security”, and
“Low” and “OK”.
Installing and
Operating the Prentice Hall
To use the Prentice Hall
PHStat Microsoft Excel add-in, you first need to run the setup program
(Setup.exe) located
in the PHStat directory
on this disk. The setup program will install the PHStat program files to your
system and add icons
on your Desktop and
Start Menu for PHStat. To do this simply
insert PHStat disk in your CD drive and follow directions.
To operate PHStat or
EXCEL simply double clicks on the PHStat icon. For EXCEL 2007 users, you will
likely have to
click on “Enable Macros”
which should popup by itself.
LOGGING
ONTO THE NETWORK ON CAMPUS
Go to either 005, 012, or 026 Library Annex or Rike Hall
computers. Turn on the power to the PC,
WITHOUT
your data diskette in drive A. At the
screen which prompts you for Login ID: and Password: press return.
GETTING INTO EXCELL
ON CAMPUS USING THE PHSTAT ADD-IN
From Windows 2007 on campus: Double click on “Applications”,
“All”, “PHStat”.
COMPUTER ASSIGNMENT INSRUCTIONS
1. Enter the data from page 6 of your MS204 Syllabus (remember that all the data for Machine A is entered in column “A” and all the data for Machine B is entered into column “B.” |
|
2. Insert your memory device into the proper
slot of the computer. Save the data. |
|
3. In column A row 1, type the title “Machine
A”. Start the data for machine A in
column A row 2 |
|
4. In
column B row 1, type the title “Machine B”.
Start the data for machine B in column B row 2 |
|
5.
Insert your memory device into the proper slot of the computer. Save
the data. |
DESCRIPTIVE STAISTICS
1. For EXCEL 2007, go to the “Data” tab and click on “Data Analysis.” From, here click on “Descriptive Statistics”. |
|
2. For earlier EXCEL versions, go to the “Tools”
tab and click on “Data Analysis.” From
here click on “Descriptive Statistics”. |
|
3. For your input range, place your cursor in
the appropriate box and highlight all the data you entered for machine A
(starting with the title in column A, row 1). If you desire, you may add your
bin rang (not required). |
|
4. Make
sure both the “Labels in First Row” box as well as the “Summary statistics”
box are checked. Then click “OK”. |
|
5. Perform
steps 1 through 4 for the machine B data. |
HISTOGRAM
1. For EXCEL 2007, go to the “Data” tab and click on “Data Analysis.” From here, click on “Histogram”. |
|
2. For earlier EXCEL versions, go to the “Tools”
tab and click on “Data Analysis.” From
here click on “Histogram”. |
|
3. For your input range, place your cursor in
the appropriate box and highlight all the data you entered for machine A
(starting with the title in column A, row 1). |
|
4. Make
sure both the “Labels in First Row” box as well as the “Chart Output” box are
checked. Then click “OK”. |
|
5.
Perform steps 1 through 4 for the machine B data. |
STEM-AND-LEAF DISPLAY
1. For EXCEL 2007, go to the “Add-ins” tab and click on “PHStat”. From here, click on “Descriptive Statistics,” “Stem-and Leaf Display” |
|
2. For earlier EXCEL versions, go to the “PHStat”
tab and click on “Descriptive Statistics.”
From here click on “Stem-and Leaf Display”. |
|
3. For your |
|
4. Make
sure both the “Labels in First Row” box as well as the “Summary Statistics”
box are checked. Also, set the stem unit as 10 and the title is “Machine
A”. Then click “OK”. |
|
5.
Perform steps 1 through 4 for the machine B data with the title
“Machine B”. |
BOX AND WHISKER PLOT
1. For EXCEL 2007, go to the “Add-ins” tab and click on “PHStat”. From here, click on “Descriptive Statistics,” “Box and Whisker Plot” |
|
2. For earlier EXCEL versions, go to the “PHStat”
tab and click on “Descriptive Statistics.”
From here click on “Box and Whisker Plot”. |
|
3. For your |
|
4. Make
sure both the “Labels in First Row” box as well as the “Five-Number Summary”
box are checked. Also, enter title as “Machine A”. Then click “OK”. |
|
5.
Perform steps 1 through 4 for the machine B data with the title
“Machine B”. |
PERSONALIZING
THE EXCEL OUTPUT
EXCEL 2003 - On the “File” pull-down menu, click “Page Setup” and
select the “Header/Footer” tab. Click the
Customize Header button and enter your name and seat
number. Do this on each output page.
EXCEL 2007- Click on the “Microsoft
Office” button in the upper left hand
corner of the EXCEL Then click “Print”,
“Print Preview”, “Page Setup” and select the “Header/Footer” tab. Click
the Customize Header button and enter your
name and seat number.
Do this on each output page.