AVERAGE Excel ka ek important statistical function hai. Iska use kisi group of numbers ka ausat (average) nikalne ke liye kiya jata hai.
Simple words mein, jab hume multiple numbers ki ek common ya middle value pata karni ho, tab AVERAGE ka use kiya jata hai.
Maan lijiye ek student ne 5 subjects mein ye marks score kiye:
60, 70, 80, 90, 100
In sabhi marks ko mila kar 400 milte hain. Total 5 subjects hain, isliye average 80 marks hota hai.
Yaani student ka average score 80 hai.
Excel mein AVERAGE ka use real-life data ko samajhne aur compare karne ke liye kiya jata hai, jaise:
Large datasets mein har value ko individually analyse karna difficult ho sakta hai. Average ek single representative value provide karta hai, jisse overall performance ya data ko quickly understand kiya ja sakta hai.
For example, agar kisi company ki 6 months ki sales alag-alag hain, to average sales se company ko apni overall sales performance ka basic idea mil sakta hai.
| ๐ Item | Details |
|---|---|
| Function Name | AVERAGE |
| Purpose | Numbers ka average nikalna |
| Syntax | =AVERAGE(number1, number2, ...) |
| Range Syntax | =AVERAGE(A2:A10) |
| Calculation | Total Values รท Number of Values |
| Example | =AVERAGE(60,70,80,90,100) |
| Result | 80 |
| Subject | Marks |
|---|---|
| English | 60 |
| Hindi | 70 |
| Computer | 80 |
| Maths | 90 |
| Science | 100 |
| Average | 80 |
Leave a Reply