In this assignment, your learning on predictive analysis is tested on the series of data. You are required to analyze data by applying the techniques you have learned in regression analysis.

Submission of a PDF file and an Excel file is essential.

\fP roblem desoriptio n: If you are the manager of a grocery company with 5D stores across the city. The excel le contains data on the demand for grocery delivery: Delivery {1"} is the number of delivery per month Price [Ill is the average price of a delivery Income {:12} is average income in the neighbourhood You are required to use the Microsoft Excel package {the data analysis section} to finish the specific tasks below. Task 1: {5 marks} Plot the scatter plot for #Delivery [y-axisl and Income [it-axis}. Add the trendline with the equation and Iii-square. Interpret the R-souare and comment on the slope coefficient. Suggest one use or application for this information