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.
You will need to copy to a separate spreadsheet and format, so numbers are clearly visible and correctly formatted.
Note: You may use XLMINER also; applying the same method.
Notesome 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 worth 15 Marks
Review Supplementary Chapter A on Non-linear Optimisation it is available on Moodle and provide a summary(10 marks)
and do Q9 below(5 marks)
Q9
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 Supplementary Chapter A it has data for Q9.
You are required to type in a spreadsheet and use solver add-in in Excel (You can also use XL Miner in google sheets).
MPOM7103 Assignment: Strategic Decision-Making and Operational Resilience in Petronas Amid Energy Transition
Read MoreMPIB7103 Assignment: Critical Perspectives on International Business Strategies and Regional Integration
Read MoreMPHR7113 Assignment: Strategic HR Analysis of Golden Heritage Café (HRM)
Read MoreTHEA1013 assignment: Theatrical Storytelling: Exploring the Unique Power of the Stage
Read MoreBusiness Strategy Assignment: Strategic Expansion: A Business Outlook
Read MoreGSGM7324 Assignment: Organisational Development and Change Management
Read MorePHY098 LOD 2, C4 Assignment: Mitigating Damage to Electrical Appliances from Lightning Strikes
Read MoreBM070 Business Research Assignment: Business Report Framework for Corporate Development
Read MoreHBET1203 Assignment: Comparing Pronunciation of Selected Words in Text and Reading to Standard British English
Read MoreIdentify key technological challenges affecting e-invoicing adoption in Malaysia.
Read More