1. How might analytics be used in the following situations? Determining a personal investment plan Please answer using at least ten sentences.

2. Use Excel’s filtering capability in the Purchase Orders database to extract a. all orders for Electrical Connector. b. all orders for quantities of less than 5510 units. c. all orders for Electrical Connector with quantities of less than 5510 units. Please include Excel worksheets with all the details with your answer.

3. The monthly product sales for a company are given in the Homework 1 Question 3 Data excel file posted with this homework. Use Pivot Charts to create a useful dashboard for the data in this Excel file. Include the following 6 charts in your dashboard: - Total Product A sales units for each month - Total Product B sales units for each month - Total Product C sales units for each month - Total Product D sales units for each month - Total Product E sales units for each month - A clustered chart of total sales units for Product A, total sales units for Product B, total sales units for Product C, total sales units for Product D, and total sales units for Product E for each month Explain how a manager might use the dashboard. Please include the Excel worksheet with all the details and the dashboard with your answer.

Sales Units
Month	Product A	Product B	Product C	Product D	Product E
January	7450	3600	3200	4250	6580
February	7200	3024	4200	3751	9020
March	8200	5550	2147	3320	6827
April	6500	5600	2700	4057	8544
May	6000	5200	2726	3650	8550
June	9800	4000	3050	4700	9070
July	8702	6000	2891	5418	8389
August	10200	5500	2782	4085	7360
September	8986	4800	2524	5720	5377
October	8654	4746	3258	5333	7645
November	8300	3570	2150	7000	8200
December	8600	6200	5420	6563	7640

Answer rating: 100% (QA)

1 Analytics would be used in a personal investment plan to determine which investments are in the be... View the full answer