MHB Find Mean With Multiple Data [Shortcut]

AI Thread Summary
To find the mean with multiple data points, the formula used is \(\overline{x}=\frac{\sum\limits_{k=1}^n\left(x_kf_k\right)}{\sum\limits_{k=1}^n\left(f_k\right)}\). Users expressed confusion about applying this formula to their data samples. An Excel shortcut for this calculation is =SUMPRODUCT(A2:A5, B2:B5) / SUM(B2:B5). However, it was clarified that calculating the mean without multiplying each data point by its frequency is not feasible. The provided formulas represent the simplest method for computing the mean from a frequency table.
susanto3311
Messages
73
Reaction score
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: 74
Mathematics news on Phys.org
Here is the formula:

$$\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.
 
hi Mark, thanks but i confuse how to use your formula...

could you use my data sample (post #1)?
 
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)
 
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: 66
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.
 
Suppose ,instead of the usual x,y coordinate system with an I basis vector along the x -axis and a corresponding j basis vector along the y-axis we instead have a different pair of basis vectors ,call them e and f along their respective axes. I have seen that this is an important subject in maths My question is what physical applications does such a model apply to? I am asking here because I have devoted quite a lot of time in the past to understanding convectors and the dual...
Insights auto threads is broken atm, so I'm manually creating these for new Insight articles. In Dirac’s Principles of Quantum Mechanics published in 1930 he introduced a “convenient notation” he referred to as a “delta function” which he treated as a continuum analog to the discrete Kronecker delta. The Kronecker delta is simply the indexed components of the identity operator in matrix algebra Source: https://www.physicsforums.com/insights/what-exactly-is-diracs-delta-function/ by...

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