Assignment Two: Regression Model Subject Title: Quantitative Methods Subject Code: BAC21 A Assessment Title: Case Problem 2 Assessment type: Individual Weighting: 20% Submission type: Turnitin Format / Layout of Assessment: ? Cover page ? Introduction (summary of case) ? Managerial report ? Conclusion ? References (if any) ? Appendices (if any) Assessment instructions: Regression is a statistical tool used to understand and quantify the relation between two or more variables. Regressions range from simple models to overly complex equations. The two primary uses for regression in business are forecasting and optimization. In addition to helping managers predict such things as future demand for their products, regression analysis helps fine-tune manufacturing and delivery processes. This assignment focuses on applying regression methods. Students are given a case (next page) and a data set (data for each student on excel sheet available on Moodle) to analyse and make a managerial report. This assessment requires students to focus on the key learnings from the lectures on linear and multiple regression and how they apply to real-life situations.Case problem: Consumer Research, Inc. Consumer Research, Inc., is an independent agency that conducts research on consumer attitudes and behaviours for a variety of firms. In one study, a client asked for an investigation of consumer characteristics that can be used to predict the amount charged by credit card users. Data were collected on annual income, household size, and annual credit card charges for a sample of 21 consumers. Managerial Report: Use the regression technique, students need to include the following in their report.

1) Develop estimated regression equations, first using annual income as the independent variable and then using household size as the independent variable. Which variable is the better predictor of annual credit card charges? Discuss your findings.

2) Develop an estimated regression equation with annual income and household size as the independent variables. Discuss your findings.

3) Discuss the need for other independent variables that could be added to the model. What additional variables might be helpful?

Assignm File Home Insert Page Layout Formulas Data Review View Help Arial 10 AA ap Wrap Text Paste BI U~ A Merge & Center Clipboard Font Alignment E14 X V fx O A B C Income ($1000s) Household Size Amount Charged ($) 54 4016 W N 39 3159 32 5100 59 41 10 48 4208 27 4219 10 00 33 2477 65 2514 10 63 4214 51 4965 U - N O A W N - A O A W N - A W W A N W 12 25 4412 13 48 2448 14 27 2477 15 33 2514 16 65 4214 17 63 4965 18 42 4412 19 37 2448 20 62 2995 21 21 4171 22