Analyzing Costs

using Pivot Tables to consider gross gross gross sales Data Task 1: Examine spreadsheet in dramatis personaeation. Procedure 1.Read the active-MIS, upward(a) Decision devising: Using Pivot Tables to Analyze Sales Data, in the school text on page 360. 2.Download the Hands-On MIS Data Files spreadsheet from the buster website and usance the PivotTable feature in surmount to examine the data and dress the questions listed in the scenario. Where ar the comely purchases higher? The mediocre by purchases argon higher in the south, with an medium of $42.94. What form of indemnify is the just about humanity? The almost commonality form of hire is credit posting payment glide path in with $12692.94 of gross sales. atomic fleck 18 there some(prenominal) times of daytime when purchases are most common? Do people buy products musical composition at conk out or at home? The most common times of day when purchases are most common are after work from 4pm-10pm. The most sales are purchased at home in the evening times.

Whats the blood amongst regions, type of product purchased, and average out sales price? The relationships in the midst of regions are the East averages in give-and-take sales $59.39, and online sales $19.22 with a impart average of $41.86. North averages in take hold sales $42.96 and online sales $19.99, with total average of $32.48. South averages in book sales $58.13, and online sales $19.79 with total average of $42.94. west averages in book sales $54.16, and online sales $19.88, total average $38.08. The greatest average of sales is in the south, with the East coming in second place.If you command to get a encompassing essay, order it on our website: Ordercustompaper.com

If you want to get a full essay, wisit our page: write my paper