Foster MBA -
Statistics Jump Start
September 2013
Prof.
Thomas Gilbert
Links to Other Jump Start Courses:
- Jonathan Oakdale (former MBA student) will teach an
Excel workshop on the topics he wished he
had known when starting the MBA
- Wednesday 18 September at 7.30am (until 9am) in
Shansby Auditorium
- Topics: PasteSpecial, Sumif, Countif, Filter,
Vlookup, conditional formatting, data bars, sparklines, pivot tables
-
Excel spreadsheet for session
General:
- Syllabus
- Which calculator do you need for the stats and math jump start? Any
scientific calculator that has powers, exponentials, logarithms, and square
roots will do.
- Analysis ToolPak for Mac (info may be outdated)
- Go to
http://www.analystsoft.com/en/
- Download the free StatPlus:mac LE version in the bottom left-hand corner
of the page
- Install the program and drag the icon to your dock
- Once in Excel, if you want to use the program, just launch it from your
dock
- Solver for Mac (info may be outdated)
- Go to http://www.solver.com/mac/
- Download the program for free, install it, drag the icon to your dock, and
just launch it alongside Excel when you want to use it
-
Excel
Spreadsheet
-
Excel
Spreadsheet with Answers
Part 1:
Part 2:
Part 3: