15) After graduation, you take a position at Top-Slice, a well-known manufacturer of golf balls. One of your duties is to forecast monthly demand for golf balls. Using the following data, you developed month. a regression model that expresses monthly saels as a function of average temperature for the Monthly sales= =-767.7 + (98.5 * Average Temperature) Month Monthly Sales Average Temperature Mar-14 4,670 52 April 5,310 58 May 6,320 69 June 7,080 75 July 7,210 83 August 7,040 82 September 6,590 78 October 5,520 65 November 4,640 54 December 4,000 48 Jan-15 2,840 41 February 3,170 42 a) Calculate the linear regression for the above data (use the Excel Data Analysis tool) to validate the formula above. This will create its own sheet, just highlight the appropriate values on the new sheet