Reference no: EM132667012

BUS201 Business Analytics Assignment - Gateway Business College, Australia

Task - Project Report

PART A -

Look at the tube under week 6 entitled "Tube doing a multiple linear regression using Excel Add-in ".

Do a multiple regression on the "employee retention" spreadsheet within the PLE Database.

You will need to copy to a separate spreadsheet and format, so numbers are clearly visible and correct formatted.

Note: You may use XLMINER also; applying the same method.

Make Years PLE as the dependent variable and assess independent variable at 95% confidence and confirm for each variable they are explanatory in terms of dependent variable. The independent variables are: YrsEducation, College GPA, Age, Gender, College Grad and Local.

Note some of the independent variables are categories you need to translate to a numeric scale.

It is important that show the working within the separate spreadsheet i.e. ANOVA analysis testing Hypothesis of Influence at 95% confidence level, you use may use t-stat and p-stats also.

You are required to postulate hypothesis at 95% confidence level.

Formulate the multiple regression formula correctly and provide relevant statistics. Explain what the statistics mean.

PART B -

Review Supplementary Chapter A on Non-linear Optimisation it is available on Moodle and provide a summary and do question.

Question - The Economic Order Quantity (EOQ) model is based on ordering only a single item. Suppose we allow for multiple items that are independent except for a budget restriction. Develop a model to minimize the total cost and meet a budget constraint on the total inventory value, defined by the product of the unit cost multiplied by the order quantity, summed over all items. Apply your model to the following data by implementing it on a spreadsheet and solving the model with Solver. Interpret the sensitivity report. Refer to chapter it has data. You are required to type in a spreadsheet.