MBA7233 Managerial Business Analytics Assignment 1 Brief | JUC Malaysia

MBA7233 Assignment 1 Brief 

Instructions

• This is an individual assignment.
• Write a report of at least 2,000 words, excluding references and appendices.
• Use APA referencing style.
• There must be a minimum of 10 references to be used for this assignment.
• Formatting: [Times New Roman], [size 12], [1.5 spacing], [justified alignment].
• Please email your assignment (Microsoft Word format) to academic@sea.com.my
• Include a cover page, table of contents, and reference list.
• Plagiarism – It is important to note, that your essay is entirely your own work. Students found guilty of plagiarism or collusion faced penalties. It is essential that you understand and follow standard procedures for referencing other people’s work.

Assignment Task        

Using Excel for Predictive Analytics in Finance

You will use the provided dataset in Excel to perform the following tasks

Subtask 1: Data Analysis and Visualization

1. Use Excel functions to clean and analyze the dataset.
2. Create visualizations (charts or graphs) to show trends or patterns in the data.

Subtask 2: Prediction Using Regression Analysis

1. Apply linear regression using Excel
2. Predict a financial outcome (e.g., stock price, sales revenue, or loan approval likelihood).
3. Interpret the regression output.

Subtask 3: Assessing Prediction Quality

1. Calculate and interpret metrics to evaluate the accuracy of the predictions:
   1. Mean Absolute Error (MAE).
   2. Root Mean Square Error (RMSE).
2. Discuss the implications of these errors in the context of the dataset.

Subtask 4: Scenario Analysis

1. Perform a “What-If” analysis using Excel.
2. Discuss how changes in input variables influence predictions.

Subtask 5: Skill vs. Luck in Predictions

1. Reflect on the accuracy and limitations of the predictions made.
2. Discuss the potential roles of skill and luck in influencing the results.

End of Question