Department of Statistics

Department of Statistics

Business Statistics - STAT 2160

How to run Excel at WMU's computer labs

Schneider
UCC/Bernhard
Rood
Project data

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.



Directions for obtaining your unique data subset:
  • Go to www.stat.wmich.edu/s216/ and click on the HW Data link.
  • Click on the file name as indicated by your instructor.
  • Under Select variables, put check marks next to all the variables
  • Enter 30 for Sample size.
  • Enter the four digits of your on-line homework PIN for PIN Number.
  • Click on the Submit button.
  • 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 Excel File 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.
    • Change the name on the tab at the bottom of the worksheet to data.
  • Finally, go to File | Save as, change the following and click on save.
    File name: excelData.xls
    Save as type: Microsoft Excel Workbook

This data set is now ready to be used for all of the computer projects that you will do this semester.  Keep this as a separate data file and DO NOT save any project output to this file.


 

Department of Statistics
3304 Everett Tower
Western Michigan University
Kalamazoo MI 49008-#### USA
(269) 387-1420 | (269) 387-1419 Fax
stat-loren.heun@wmich.edu