Marketing Research - MKTG 441 Resource Guide: Using Excel for Statistics

Columbia College students can get a free version of Microsoft Office, including Excel, by following these steps:

1. Go to http://aka.ms/getoffice

2. Enter your CougarTrack username with @ccis.edu and CougarTrack password. NOTE: Your username should be yourusername@ccis.edu NOT your CougarMail email (such as yourusername@cougars.ccis.edu).

3. Click Sign In.

4. Once signed in, students may click Install to load Office 365 on a desktop, or select Phone & Tablet on the left to install the Microsoft Office apps.

Office 365 ProPlus supports PCs and Windows tablets running Windows 7 or higher, and Macs with Mac OS X 10.6 or higher. Office for iPad can be installed on iPads running version 7.0 or higher. For information about mobile devices, visit www.office.com/mobile.

Loading the Analysis Toolpak

For some of the assignment requirements, it will be useful to use the Excel Add In called Analysis ToolPak.  Instructions to download are here: https://support.office.com/en-us/article/Load-the-Analysis-ToolPak-in-Excel-6a63e598-cd6d-42e3-9317-6b40ba1a66b4

Resources for excel based assignments are available in the textbook, and in this MKTG 441 Marketing Research Resource Guide.  This is also a resource on how to use the Analysis ToolPak: https://support.office.com/en-us/article/use-the-analysis-toolpak-to-perform-complex-data-analysis-6c67ccf0-f4a9-487c-8dec-bdb5a2cefab6