课业设计2(商业决策).doc

NAME OF STUDENT UNIT TITLE Business Decision Making ASSIGNMENT TITLE Multiple Regression Analysis ASSIGNMENT NO 2 of 2 NAME OF ASSESSOR Gang Cheng SUBMISSION DEADLINE 26th Dec, 2011 LEARNING OUTCOMES COVERED ASSESSMENT CRITERIA COVERED OUTCOME 1 Use a variety of sources for the collection of data, both primary and secondary 1.a prepare and implement a plan for the collection of primary and secondary data for a given business problem 1.b describe and justify the survey methodology and frame used 1.c develop and use a questionnaire and justify its design for a particular purpose OUTCOME 2 Apply a range of techniques to analyse data effectively for business purposes 2.c calculate quartiles, percentiles, correlation coefficient, and use to draw useful conclusions in a business context OUTCOME 3 Produce information in appropriate formats for decision making in an organisational context 3.b use trend lines in spreadsheet graphs to assist in forecasting for specified business information and thus inform decision making 3.d prepare a formal business report OUTCOME 4 Use software-generated information to make decisions at operational, tactical and strategic levels in an organisation 4.a review management information systems and suggest appropriate information processing tools for operational, tactical and strategic levels of the organisation 4.b review and evaluate inventory control systems in an organisation 4.c prepare a spreadsheet to enable material requirements planning and calculate economic order quantities 4.d prepare a project plan for an activity and determine the critical path 4.e use financial tools — discounted cash flow and internal rates of return (IRR function) to evaluate the financial viability of proposed investments NOTES TO STUDENTS This is a group work based assignment. Each member need to contribute to the assignment independently. please use the suggested format: words: minimum 1,000 font type: Times New Rom