Data Analysis

**Objectives: **

To learn how to analyze and interpret data given

To create a report and make organizational decisions based on data given

**Deliverables:**

Powerpoint Presentation report

Excel Spreadsheet with the data in pivot table

**Task 1: Determine which branch has high and low sales for Company XYZ (Monthly for 2014)**

- Open the first spreadsheet. 1
- Determine the number of data and the parameter fields to be examined.
- Based on the given data, determine the number of branches of the company.
- Which branches are not in Metro Manila?
- How much is total yearly sales of the company?
- Which branch has the highest amount of sales? How much?
- Which branch has the lowest amount of sales? How much?
- Based on the given data, what is your forecast next year? Which branch will yield the highest sales? The branch that will yield the lowest? Why?
- Which 3 branches will you recommend to close should the company opt to do a reorganization based on total sales?
- Create a chart showing the total sales of each branch per month.

__Note:__ Place your results in a Powerpoint slide for Tasks 2-10 (1 slide per task), and save as Task1(LastnamesOfMembers).ppt and send to justinp@apc.edu.ph

**Task 2: Determine the information about your customers**

- Open the second spreadsheet. 2
- Determine the number of data and the parameter fields to be examined.
- Based on the given data, determine how many customers are male and female.
- How many customers have an Advantage Card?
- How many customers that have an Advantage Card are male and female?
- How many customers are from Luzon, Visayas and Mindanao?
- How much is the sales for Luzon, Visayas and Mindanao.
- Create a chart showing the total sales in Luzon, Visayas and Mindanao with the gender as qualifier.

__Note:__ Place your results in a Powerpoint slide for Tasks 2-8 (1 slide per task), and save as Task2(LastnamesOfMembers).ppt and send to justinp@apc.edu.ph

—– NOTHING FOLLOWS —–

### Like this:

Like Loading...