- #1
susanto3311 said:hi Mark, thanks but i confuse how to use your formula...
could you use my data sample (post #1)?
I like Serena said:Hi susanto3311! Welcome to MHB! :)
The formula for your mean is:
$$Mean = \frac{
\overbrace{35+35+...+35}^{6}
+ \overbrace{40+40+...+40}^{8}
+ \overbrace{25+25+...+25}^{12}
+ \overbrace{20+20+...+20}^{24}
}{6+8+12+24}$$
In your picture each of the sums under an overbrace has been put in a separate cell. The result is calculated afterwards.
In Excel, you can do it in one formula: [m]=SUMPRODUCT(A2:A5, B2:B5) / SUM(B2:B5))[/m].
This is the same formula as the one that Mark gave, just in Excel style. (Wasntme)
susanto3311 said:without multiplication for each data with frequency...
The "Find Mean With Multiple Data [Shortcut]" method is a mathematical technique used to determine the average value of a set of numerical data. It is also known as the arithmetic mean and is commonly used in statistics and data analysis.
The formula for finding the mean using this shortcut method is:Mean = (Sum of all the values in the data set) / (Number of values in the data set)
This method is different from the traditional method of finding the mean because it allows you to find the mean quickly and easily without having to list out all the individual data values. It is a shortcut that uses the sum of the values and the number of values to find the mean.
This shortcut method is appropriate to use when you have a large set of data and you need to find the mean quickly. It is also useful when you only have access to the sum of the values and the number of values, rather than the individual data points.
Yes, there are some limitations to using this shortcut method. It is only applicable for numerical data and assumes that the data is normally distributed. If the data is skewed or has outliers, this method may not accurately represent the average value.