1. The following is the mattress sales data for the previous two years. Using Microsoft excel, do the following: a. Construct descriptive statistics report of sales b. Display the sales

data using a scatter diagram c. Construct a histogram and a Pareto chart for sales. d. Fit a line through the data using regression analysis. Write the equation of the line.