BIS 155 Course Great Wisdom / tutorialrank.com BIS 155 Course Great Wisdom / tutorialrank.com | Page 43

table to begin your analysis, through the use of sorting, filters,
subtotals, and so on. If you choose to do so, be sure to include an
appropriate page title and sheet name to describe your work.
STEP 3: Create the Three-Scenario Analysis

This is an opportunity to show your intuition, creativity, and Excel
skills, so be sure to provide good examples here, for each scenario
that you present.
Analyze the Data
As mentioned, analyze the data in at least three different ways. Each
form of Data Analysis should be provided on a separate,
appropriately labeled worksheet. It is expected that each sheet will
be professionally formatted and clearly documented with titles,
comments, and explanation. Remove any extra sheets so your
workbook is as compact as possible when you turn it in. Go back and
review your iLabs for assistance in completing the different types of
analysis. There is a memo template that you will be using to present
your analysis.
The following are some examples of analysis you might wish to do.
•
Sort by discount level. Have discounts increased sales
volumes? Is there any discount level that appears to be more
effective than others?
•
Graph sales over time to see trends. Are there any peaks and
lows in sales? Is there any time of year in which sales are highest?
Lowest?