Compares the data in a meaningful way


Discussion:

Using the ABC Technologies Inc., Q1 2012 Sales spreadsheet, analyze the data on Q1 2012 Sales identifying the following:

• Monthly sales by Region

• Quarter One sales by Region

• Monthly sales by Product

• Quarter One sales by Product

• Monthly sales by Region, by Sales people

• Quarter One sales by Region, by Sales people

• Create a graph or chart that compares the data in a meaningful way, i.e. compare regions by month, compare products by month, etc...

Create a spreadsheet formatted to present your analysis of the sales numbers to management. In your spreadsheet, use the following:

• Use the SUM function

• The date function

• An additional math or statistical function of your choice

• Fill colors to differential areas of your spreadsheet

• Border lines to differential area of your spreadsheet

Attachment:- Sheet.rar

Solution Preview :

Prepared by a verified Expert
Applied Statistics: Compares the data in a meaningful way
Reference No:- TGS01812467

Now Priced at $45 (50% Discount)

Recommended (95%)

Rated (4.7/5)