Use the Tab and Up, Down arrow keys to select menu items.
Using quantitative and statistical methods in business applications. Modelling with spreadsheets. This course is designed specifically for Commerce students.
This course provides a foundation of statistics and mathematics from a user’s point of view. The emphasis is on sensible and correct use of statistical and mathematical tools in real-life problems and critical interpretation of quantitative reporting. It will assume fairly elementary levels of competence in mathematics. Excel will be used as a tool within the course.
Topics Covered:Use of functions Drawing and interpreting graphs – slopes, intercepts, turning pointsConverting problems into algebraic form and algebraic solution methodsExcel: building Business modelsInterest; Discounting; Annuities; Internal rate of returnProbability, random variables, mean and standard deviation Binomial distribution and Normal Distribution Levels of measurement Statistical graphs; Graphing using Excel Sampling; Descriptive statistics Hypothesis tests – introduction to inference; Interpreting the p-value; t-testsCategorical dataCorrelation and linear regression Time series and index numbers
STAT111, STAT112
Nicola Petty
Irene David and Nicola Petty
A Pass grade is achieved when the student has passed all the module tests. Students may sit each test repeatedly until they have passed. The final examination is optional. Students who have passed all the module tests are eligible but not obligated to sit the final examination. The examination result will be a letter grade of C or above. A student who has passed the module tests and chooses to sit the examination will not receive a failing grade.Students who do not complete the six modules may carry completed modules over for one additional enrolment in the course within two years.
Swift, Louise. , Piff, Sally; Quantitative methods for business, management and finance / Louise Swift and Sally Piff ; 2nd ed; Palgrave Macmillan, 2005.
Relationship to Other Courses:This is a service course in statistics and mathematics necessary for students majoring in a non-mathematical commerce subject, such as AFIS and Marketing and Management. Departmental Academic Policies If you want a hard copy of this document, please ask the course co-ordinator. The Department assumes that you have read this document. You should also read the “Information related to courses and assessment” on page 350 of the Enrolment Handbook 2007 (also in UC Calendar under “General Course and Examination Regulations”).
Domestic fee $625.00
International fee $2,550.00
* All fees are inclusive of NZ GST or any equivalent overseas tax, and do not include any programme level discount or additional course-related expenses.
For further information see Management, Marketing and Tourism .