(c) In the worksheet Donnas Garden - Plot, first calculate the five-number summary of the actual sales in cell E3:I3 (Use QUARTILE.INC when calculating the quartiles and use any appropriate function when calculating the median.) (5 points) Then calculate the IQR in cell E6 (1 point). Are there any mild outliers? If not, show your argument. If so, which months actual sales are mild outliers? Show your answer in the merged cells E10:J13. (5 points)

(d) Next, draw a scatterplot for the data in the worksheet Donnas Garden - Plot. Please follow these requirements to format your scatterplot:

Remove the chart title Actual Sales. (2 points)

Set the range of the Y-axis as 60 to 120. (2 points)

Insert an appropriate trend line for the plot and show the equation. (4 points)

Set the color of the trend line as Black, dash type as Solid, and width as 0.5 pt. (2 points)

2

Change the format of the text in X-axis and Y-axis as Black, 10 font size, and Times New Roman. (2 points)

Finally, remove the Border (No line) of the Chart Area. (2 points) Notes: sometimes the plot cannot be read from students who use MAC. It would be better for you to double- check your Excel file using the online version of Excel from Office 365 before submission. Do not make any further changes beyond the above requirements and potential points will be deducted.