Question

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.

Fig: 1

Fig: 2

Fig: 3

Fig: 4

Fig: 5

Fig: 6