Compute and show step by step:

1. Exercise One: Given the sales data below for Tribeca Electronics,

(a) compute the average, median and standard deviation for Model A, B, C and D,

(b) as shown in class, run a preliminary Multiple Linear Regression (MLR) and determine the statistical significance of your input variables,

(c) calibrate your model based on your statistical inference,

(d) re-run the Multiple Linear Regression model with the statistical significant inputs,

(e) as shown in class, forecast the Sales values for the 20, 21, and 22 days.

(Please notice that your data may extend into next page). (5 Points).