Reference no: EM132932417

Assignment - Regression Model

Quantitative Methods

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 Moodie) to analyse and make a managerial report.

This assessment requires students to focus on the key leamings from the lectures on linear and multiple regression and how they apply to real-life situations.

Case problem: Consumer Research, Inc.

Consumer Research. Inc.. a 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 20 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 a 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?