use the excel file and answer the questions

Are you pressed for time and haven’t started working on your assignment yet? Would you like to buy an assignment? Use our custom writing services for better grades. Even if your deadline is approaching fast, our writers can handle your task right when you need it. Our writers will complete your order from scratch and make sure it’s completely unique.


Order a Similar Paper Order a Different Paper

Evaluation Criteria:

Your submission will be graded based on whether the answers provided for each question are correct with supporting excel file. Create one sheet per question and name each sheet as Q1, Q2 etc. for Question 1, Question 2 etc.

Questions [Maximum possible points: 25]

1. What are the five best-selling products based on quantity sold? [2 pt.]

2. What are the five worst selling products based on quantity sold? [2 pt.]

3. What’s the average extended price by order? [2 pt.]

(HINT: Look at the extended price by order and then use “value field setting” to change to AVERAGE function)

4. What is the average quantity sold per order? [3 pt.]

(HINT: Look at the total quantity by order and then use “value field setting” to change to AVERAGE function)

5. Are our sales seasonal (look at total sales in dollars)? Explain. [3 pt.]

6. Based on the data we have, does our discount policy appear to help sales? HINT: You need to compare the average discount and average $ sales across product lines.[3 pt.]

7. What are the five most heavily discounted products? [2 pt.]

8. Who are our five best customers based on total sales (i.e., Extended Price)? [2 pt.]

9. What are the five most popular (quantity sold) products among our five best customers? (HINT: Apply a filter to include only the five best customers found in #8) [2 pt.]

10. Create a pi-chart to demonstrate the average discount enjoyed by each customer segment? [ 2 pt.]

11. Demonstrate (use a line graph) to show how total sales revenue (extended price) change for each State (customer State) [2 pt.]

Writerbay.net

Do you need help with this or a different assignment? Even when your task is complicated and the deadline is in less than 2 days, you still have every chance to get a good grade for it. How? By completing the order form, you will get the finest custom-written assignment at an affordable price. We also deliver a number of services for free (e.g., revisions, editing, checking the text for authenticity). Use our paper writing service to receive effective help with your homework.


Order a Similar Paper Order a Different Paper