MIS$665$ has MANGT$366($e$.$g$.,$ Excel$)$ or an introductory computing course from other

colleges as a prerequisite. Therefore, the course assumes you have knowledge of Excel

and$/$or other similar tools.

$$ This is a self$-$assessment test to evaluate your data analytics skills. It is not an exam, but

to receive credits, you need to make your best efforts.

$$ Open coffeechain.xlsx $($Excel file$)$ and use Excel $($or any other software tool which

you$$re comfortable$)$ to answer the following questions.

$$ Document your answers with evidence $($e$.$g$.,$ charts, pivot tables$)$ in MS Word.

$$ Name the Word file $$yourlastname$\_$firstinitial$\_$analytics$\_$test.docx$$

$$ Upload the file to Canvas.

$1.$ Which product type $($Coffee$/$ Espresso$/$ Herbal Tea$/$ Tea$)$ yields the maximum profit in each

market size $($major$/$small$)?$

$2.$ Which product type $($Coffee$/$ Espresso$/$ Herbal Tea$/$ Tea$)$ yields maximum sales in each

market $($east$/$ west$/$south$/$central$)?$

$3.$ Which product $($Amaretto$,$ Columbian, Cafe Latte, etc.$)$ and product type$($Coffee$/$ Espresso$/$

Herbal Tea$/$ Tea$)$ give the maximum profit in which State$($California$,$ Florida, Texas,

Connecticut, etc.$)?$

$4.$ Which product type $($Coffee$/$ Espresso$/$ Herbal Tea$/$ Tea$)$ in which market $($east$/$

west$/$south$/$central$)$ has the maximum inventory?

$5.$ Product type Decaf has maximum sales in which State?

$6.$ How are the total sales related to total profit by product type?

$7.$ Time to complete this self$-$assessment $($e$.$g$.,30$ minutes$)\_\_\_\_\_\_\_\_\_\_$