I have the following data of number of vouchers redeemed :
How can i calculate the mean value of total vouchers?
Cross Validated is a question and answer site for people interested in statistics, machine learning, data analysis, data mining, and data visualization. It only takes a minute to sign up.
Sign up to join this communityI have the following data of number of vouchers redeemed :
How can i calculate the mean value of total vouchers?
Do you know how many vouchers were sold in total?
If so - and if I understood the problem correctly - you could find the mean by
$\frac{(mean\_val\_vouch_1*\%\_vouchers_1*total\_vouchers)+(mean\_val\_vouch_2*\%\_vouchers_2*total\_vouch)+...}{total\_vouchers}$
So in your case it would be
$\frac{(4*0*total+14*1*total+25*2*total+...+850*3*total)}{total}$
You're basically reconstructing the number of items in each line by multiplying the % with the total, and the rest of the formula is the traditional combined mean (see e.g. https://www.statisticshowto.com/combined-mean/)