Question

a.write write the formula to calculate the total sales of North zone

b.write the feature used for arranging the sales from lowest to the highest

c.to find the maximum sales in the east zone

d.to find the average sales in January- March in cell C7

e.find the difference between the sales in East zone and the west zone in April- June.​

Answer 1

$\\ \dag \: \underline{\Large\bf Formulas\:of\:Statistics} \\ \\ \bigstar \: \underline{\rm Mean:} \\ \\ \bullet\sf M=\dfrac {\Sigma x}{n} \\ \bullet\sf M=a+\dfrac {\Sigma fy}{\Sigma f} \\ \\ \bullet\sf M=A +\dfrac {\Sigma fy^i}{\Sigma f}\times c \\ \\ \bigstar \: \underline{\rm Median :} \\ \\ \bullet\sf M_d=\dfrac {n+1}{2} \:\left[\because n\:is\:odd\:number\right] \\ \bullet\sf M_d=\dfrac {1}{2}\left (\dfrac {n}{2}+\dfrac {n}{2}+1\right)\:\left[\because n\:is\:even\:number\right] \\ \\ \bullet\sf M_d=l+\dfrac {m-c}{f}\times i \\ \\ \bigstar \: {\boxed{\sf M_0=3M_d-2M}}$

Answer 2

Answer:

nan's house in the world of fashion and has a look on diwali for kids with the cardboard of the new 6euro in a pair in india in a new twist in india and a k from the ONLY way is the ONLY one in india to be a great addition for boys to make mini wear