Task 1: Examine spreadsheet information.
Procedure
1.Read the Hands-On-MIS, Improving 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 use the PivotTable feature in Excel to examine the data and answer the questions listed in the scenario.
Where ar the mediocre purchases higher?
The average out purchases are higher in the south, with an average of $42.94.
What form of pay is the just about public?
The most common form of hire is credit card payment coming in with $12692.94 of gross sales.
atomic number 18 there any times of day when purchases are most common? Do people buy products while at work 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 relationship amongst regions, type of product purchased, and average sales price?
The relationships betwixt regions are the East averages in give-and-take sales $59.39, and online sales $19.22 with a total average of $41.86. North averages in book 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. westside 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 want to get a wide-cut essay, order it on our website: Ordercustompaper.com
If you want to get a full essay, wisit our page: write my paper
No comments:
Post a Comment