Making Decisions Based on Data Analysis

I. Open the Excel file – Dr. Robinson_Sample Data

II. Rename the File using the following naming convention – LastName FirstName_Data Analysis Decision Making

III. The assumption for this assignment is that you own a business and sell products (not a service).

IV. Choose a type of business and identify the products to be sold (i.e., office products store selling items like pens, pencils, rulers, post-its, chairs, desks, and the like). Note: you must have a minimum of 10 items.

V. Manipulate the data in the cells to reflect the following: Order Date
Region Representative Item
Units Unit Cost
Total (you do not have to change anything in this column as the formula is already inserted)
Remember: You can add or delete information as it is pertinent to your business and products sold.

VI. Using Pivot Tables provide at least 4 different tables (this means you will have 5 sheets within the workbook).

VII. For each table complete the following: A) summarize what the table shows, B) why you choose to highlight the table, and C) what business decision can you make using the table.

VIII. Submit the Excel file with summary on Canvas under the Data Analysis Decision Making assignment.

*Be sure to click save often to avoid losing your work.
Grading
Data Sheet 20
Pivot Table 1 (with table explanation/decision) 20
Pivot Table 2 (with table explanation/decision) 20
Pivot Table 3 (with table explanation/decision) 20
Pivot Table 4 (with table explanation/decision) 20
TOTAL 100 points

*Remember: The Excel file needed to complete this project can be found by clicking on the “FILES” link on Canvas.

Project 2 – Student Budget

I. Open the Excel file – My College Budget Template

II. Rename the File using the following naming convention – LastName FirstName_My College Budget_

III. Manipulate the data in the cells to reflect the following: Your Fixed Income
Your Variable Income Your Fixed Expenses Your Variable Expenses
Remember: You can add or delete information as it is pertinent to you.

IV. Review your Budget Sheet to reflect on the financial picture you have painted.

V. Provide a one paragraph that includes the following: A) summary of your finances, B) what you plan to change, and C) how you plan to implement that change.

VI. Submit the Excel file with summary on Canvas under the College Budget assignment.

*Be sure to click save often to avoid losing your work.
Grading
Monthly Income 20
Monthly Expenses 20
Semester Expenses 20
Summary Paragraph 8
File Naming Convention 2
Plot Chart 10
Income/Expenses Percentage and Totals 20
TOTAL 100 points

*Remember: The Excel file needed to complete this project can be found by clicking on the “FILES” link on Canvas.