Hello All,
I'm new here. My name is tayo. Please i need help with excel formula. I need to calculate the following on excel:
1. the mean of a group of values
2. the mean deviation
3. % of mean deviation
4. Variance of each of the values from the highest value in each category
5. % variance of each value from the highest in each category.
please see table below:
Values Category Average MEAN DEVIATION % Mean Deviation Variance from Category max %Variance from Category max 793,514.19
146,608.76 -
668,275.24 646,905.43 21,369.81 (125,238.95)
565,032.75
(81,872.68) (228,481.44)
560,799.54
(86,105.89) (232,714.65)
414,588.93
12,870.52 (46,811.07)
358,737.38
(42,981.03) (102,662.62)
358,737.38 401,718.41 358,737.38 (102,662.62)
404,152.00
2,433.59 (57,248.00)
461,400.00
59,681.59 -
429,579.20
27,860.79 (31,820.80)
384,834.00
(16,884.41) (76,566.00)
I will appreciate any help on this.
Regards
Tayo
I'm new here. My name is tayo. Please i need help with excel formula. I need to calculate the following on excel:
1. the mean of a group of values
2. the mean deviation
3. % of mean deviation
4. Variance of each of the values from the highest value in each category
5. % variance of each value from the highest in each category.
please see table below:
Values Category Average MEAN DEVIATION % Mean Deviation Variance from Category max %Variance from Category max 793,514.19
146,608.76 -
668,275.24 646,905.43 21,369.81 (125,238.95)
565,032.75
(81,872.68) (228,481.44)
560,799.54
(86,105.89) (232,714.65)
414,588.93
12,870.52 (46,811.07)
358,737.38
(42,981.03) (102,662.62)
358,737.38 401,718.41 358,737.38 (102,662.62)
404,152.00
2,433.59 (57,248.00)
461,400.00
59,681.59 -
429,579.20
27,860.79 (31,820.80)
384,834.00
(16,884.41) (76,566.00)
I will appreciate any help on this.
Regards
Tayo