About Stat 2160

Important Info

How to run Excel at WMU's computer labs

Haworth College of Business PC lab (Schneider Hall)

How to start up Excel:

First of all, start up Excel and check if
the Analysis Toolpak has been added-in by choosing the
Tools drop-down menu. Do you see
Data Analysis...?
If you do not see the Data Analysis...
function, then
choose the drop-down menu Tools | Add-ins...
| choose
Analysis Toolpak from the dialog box and click
OK.
If you see the Data Analysis... function, then
choose the analysis tool for the assignment from
the dialog box and click OK.

The University Computing Center (UCC) lab

and the Bernhard Center lab

How to start up Excel:

First of all, start up Excel and check if
the Analysis Toolpak has been added-in by choosing
the
Tools drop-down menu. Do you see
Data Analysis...?
If you do not see the Data Analysis...
function, then
choose the drop-down menu Tools | Add-ins...
| choose
Analysis Toolpak from the dialog box and click
OK.
If you see the Data Analysis... function, then
choose the analysis tool for the assignment from
the dialog box and click OK.
Note: The instructions for the UCC & Bernhard Center should also
be the method for any other PC on campus you may have access to
(such as in the dorms), if Excel is installed on it.

Rood Hall computer lab (3rd floor)

Room #3374, the first room as you walk in, has 4 PCs.
Room #3372, the first room inside on the right, has 20 PCs.
Room #3394, the second room inside on the right, has 20 PCs.

How to start up Excel:

First of all, start up Excel and check if
the Analysis Toolpak has been added-in by choosing
the
Tools drop-down menu. Do you see
Data Analysis...?
If you do not see the Data Analysis...
function, then
choose the drop-down menu Tools | Add-ins...
| choose
Analysis Toolpak from the dialog box and click
OK.
If you see the Data Analysis... function, then
choose the analysis tool for the assignment from
the dialog box and click OK.

In a few seconds, the data will appear on your screen.
From your browser Edit menu,
select Select All and Copy, next
start the program EXCEL and then
select Home tab and choose Paste the data into cell A1.

EXCEL 2007: select Home tab and
choose Edit and choose Paste and
select Data tab and choose Text to columns.

Follow the dialog box, choose Delimited and click Next.
choose Comma for step 2 and deselect
Tab and Click Next.
Everything should appear to line up in the box at the bottom of the window.
Click Finish

Now make the following changes:

From the ExcelFile menu, select
Page Setup and select the Margins
tab. Reduce the top and bottom margins to 0.5
and the right and left margins to 0.25.

Highlight the entire data set and change the Font size to 8.

Now adjust the column widths. This should make it
possible to fit the entire data set on one page.