Find Mean With Multiple Data [Shortcut]

In summary: You can also use the VLOOKUP function to lookup the mean of a frequency table. (Dull)In summary, susanto3311 wanted to find the mean of a set of data without having to do any multiplication. He attached a picture of how he would like the calculation to look. He asked if anyone had any ideas on how to do it without having to do any multiplication. Dull was the only person who responded.
  • #1
susanto3311
73
0
hello everybody...

how to easy find mean with multiple data with simple formula [shortcut formula]?

please, see my picture..

thanks in advance...

susanto3311
 

Attachments

  • find mean with multiple data [shortcut].png
    find mean with multiple data [shortcut].png
    4.1 KB · Views: 55
Mathematics news on Phys.org
  • #2
Here is the formula:

\(\displaystyle \overline{x}=\frac{\sum\limits_{k=1}^n\left(x_kf_k\right)}{\sum\limits_{k=1}^n\left(f_k\right)}\)

But to compute the mean using the above formula, you will have to essentially do what is shown in the table.
 
  • #3
hi Mark, thanks but i confuse how to use your formula...

could you use my data sample (post #1)?
 
  • #4
susanto3311 said:
hi Mark, thanks but i confuse how to use your formula...

could you use my data sample (post #1)?

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)
 
  • #5
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)

i just want, how to find & calculate mean without hard work...
like my picture attach, without multiplication for each data with frequency...
do you have ideas?
 

Attachments

  • mean problem_1.png
    mean problem_1.png
    1.5 KB · Views: 49
  • #6
susanto3311 said:
without multiplication for each data with frequency...

Sorry, but that is not possible. (Dull)
The formulas given are the simplest way to calculate the mean of a frequency table.
 

FAQ: Find Mean With Multiple Data [Shortcut]

What is the "Find Mean With Multiple Data [Shortcut]" method?

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.

What is the formula for finding the mean using this shortcut method?

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)

How is this method different from the traditional method of finding the mean?

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.

When is it appropriate to use this shortcut method?

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.

Are there any limitations to using this shortcut method?

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.

Similar threads

Replies
2
Views
1K
Replies
4
Views
2K
Replies
5
Views
2K
Replies
2
Views
1K
Replies
11
Views
3K
Replies
1
Views
1K
Replies
5
Views
3K
Back
Top