ompute and report the characteristics of the affinity

$-$

based segment for Product

$3$

$($

our candidate as given above

$)$

$.$

$$Report the characteristics in terms of the following

descriptors: IPr, Iin, ICp, ICl, ICn, IBr, I

$*$

pPr

$3$

$0$

$,$

$$I

$*$

pPr

$1$

$0$

$,$

$$I

$*$

pPr

$0$

$5$

$,$

$$I

$*$

pIn

$0$

$.$

$5$

$,$

$$I

$*$

pIn

$1$

$,$

I

$*$

pIn

$3$

$,$

$$I

$*$

pCp

$1$

$2$

$,$

$$I

$*$

pCp

$2$

$0$

$,$

$$I

$*$

pCp

$3$

$2$

$,$

$$I

$*$

pClD

$,$

$$I

$*$

pClF

$,$

$$I

$*$

pClE

$,$

$$I

$*$

pCnSl

$,$

$$I

$*$

pCnSp

$,$

I

$*$

pCnLk

$,$

$$I

$*$

pBrA

$,$

$$I

$*$

pBrB

$,$

$$I

$*$

pBrC

$,$

$$and the demographics income, age, sports and

gradschl. For this you need to compute the weighted average of all the columns in the

"for

$-$

cluster

$-$

analysis" worksheet, weighted by the probabilities given in column BF of

the "mugs

$-$

full" worksheet. You should not do this in Excel directly. You are to load

the data into python or R and compute the weighted averages in R or python;