BUS5PB - Principles of Business Analytics Assignment 02:Descriptive Analytics in Practice

Task 02.2 (5%) 

Perform linear correlation analysis on the sample data set using Excel.
• Develop a simple linear regression model using Excel. You need to use “Price” as the dependent (or response) variable and “Distance” as the independent (or explanatory) variable. You are required to submit the excel file.
• Refine and improve the developed linear regression model. Illustrate and explain why the model is enhanced.(Hint: Try to focus on the model and/or remove several influential points, use the coefficient of determination and other metrics to explain).