Average Calculator: How to Calculate an Average

Averages are everywhere in daily life — whether you're tracking your daily commute time, monitoring your Meralco electricity bill, or calculating your basketball shooting percentage. Understanding how to calculate an average is a valuable skill for students, professionals, and anyone dealing with numbers.

This guide covers everything from simple averages to weighted averages and moving averages, as well as how to calculate them in Microsoft Excel. Plus, if you need quick results, our online Average Calculator can do the work for you — no maths required!

How to Calculate an Average?

Averages are useful in everyday life, whether you're tracking your travel time from Quezon City to Makati, monitoring your monthly grocery expenses, or checking your grades in school.

To calculate the mean (average), use this formula:

Average = Sum of All Values ÷ Number of Values

Calculating AverageCommute Time in Metro Manila

Let’s say you take the MRT from North Avenue to Taft Avenue every morning, but some days there’s heavy traffic and train delays.

Over the past five days, your commute times were: 40, 45, 42, 48, and 50

Average Commute Time = (40 + 45 + 42 + 48 + 50) ÷ 5 = 45

So, on average, your daily commute takes 45 minutes.

How to Calculate a Weighted Average?

A weighted average gives more importance to certain values. This is commonly used in:

• School grading systems (where exams have a higher weight than quizzes)
• Mortgage and interest rate calculations
• Investment and portfolio performance tracking

Formula for Weighted Average:

Weighted Average = ∑(Value × Weight) ÷ ∑Weights

Calculating Average Grades

Your final grade in a subject is based on:

• Quizzes (30%)
• Midterm Exam (30%)
• Final Exam (40%)

Your scores are:

• Quizzes: 85%
• Midterm Exam: 78%
• Final Exam: 90%

Final Grade = ((85×0.3) + (78×0.3) + (90×0.4)) ÷ (0.3 + 0.3 + 0.4)​ = 84.9%

So, your final weighted grade is 84.9%.

How to Calculate a Moving Average?

Moving averages help identify trends over time and are often used in:

• Stock market analysis
• Business sales tracking
• Weather forecasting

Example – Calculating Sales Trends for a Sari-Sari Store

You own a sari-sari store in Cebu and want to track your weekly earnings. Your weekly sales are:

• Week 1: ₱10,000
• Week 2: ₱10,500
• Week 3: ₱9,800
• Week 4: ₱11,200
• Week 5: ₱12,000

To calculate a 3-week moving average, use:

1st Moving Average = (10,000+10,500+9,800) ÷ 3 = ₱10,100

2nd Moving Average = (10,500 + 9,800 + 11,200) ÷ 3 = ₱10,500

3rd Moving Average = (9,800 + 11,200 + 12,000) ÷ 3 = ₱11,000

This smooths out fluctuations and helps you predict future sales trends.

How to Calculate a General Average?

In the Philippines, general averages are used in schools to determine a student’s performance across subjects.

Example – Computing a Student’s General Average

If your grades are:

General Average = (88 + 85 + 90 + 87 + 86) ÷ 5 = 436 ÷ 5 = 87.2%

So, your general average is 87.2%.

How to Calculate Average Speed?

Knowing your average speed is useful for:

• Commuters traveling by bus, jeepney, or motorcycle
• Runners and bikers tracking their fitness progress
• Drivers checking travel times on EDSA

Formula for Average Speed:

Average Speed = Total Distance Travelled ÷ Total Time Taken

Driving from Manila to Baguio

You drive 250 km from Manila to Baguio and it takes 5 hours.

Average Speed = 250 ÷ 5 = 50 km/h

So, your average speed is 50 km/h.

How to Calculate an Average in Excel?

Need a quick way to calculate an average in Microsoft Excel?

Steps:

• Enter your data in a column.
• Click on an empty cell and type: =AVERAGE(A1:A5)
• Press Enter, and Excel will display the result instantly.

For a weighted average, use: =SUMPRODUCT(values,weights)/SUM(weights)

How to Calculate Average Price?

Whether you’re buying a condo, investing in stocks, or checking grocery prices, knowing the average price helps you make better financial decisions.

Formula for Average Price:

Average Price = Total Cost of Items ÷ Number of Items

Computing the Average Price of a Condo in Metro Manila

You check three condos in Makati:

• Condo 1: ₱5,500,000
• Condo 2: ₱6,200,000
• Condo 3: ₱5,800,000

Average Price = (5,500,000 + 6,200,000 + 5,800,000) ÷ 3 = 17,500,000 ÷ 3​ = ₱5,833,333

So, the average price of a condo in Makati is ₱5.83 million.

College Average Calculator – How to Compute Your Semester Grades?

In the Philippines, universities like UP, Ateneo, La Salle, and UST use different grading systems. A College Average Calculator helps students track their semester performance by computing the average of all subject grades.

Formula for College Average:

College Average = Sum of All Subject Grades ÷ Number of Subjects​

Example – Calculating a College Average at UP or UST

Let’s say you have these grades for the semester:

College Average = (1.75 + 2.00 + 1.50 + 2.25 +1.75) ÷ 5 ​= 1.85

So, your semester average is 1.85.

Grade Point Average (GPA) Calculator

The GPA system is commonly used in Philippine universities to measure student performance. Some schools use the 4.0 scale, while others use the 5.0 or 1.0 scale (where 1.0 is the highest grade).

Formula for GPA Calculation:

GPA = ∑(Grade×Credit Units) ÷ ∑Credit Units

Example – Computing GPA at Ateneo or La Salle

Let’s say your grades and credit units for the semester are:

GPA = ((3.5×3) + (4.0×4) + (3.0×3) + (3.2×2) + (3.8×3)) ÷ (3+4+3+2+3) ​= 3.55

So, your semester GPA is 3.55.

How to Calculate Cumulative GPA (CGPA)?

If you want to calculate your Cumulative GPA (CGPA) across multiple semesters, you use the same formula but include all previous semesters in your calculation.

CGPA = ∑(GPA×Total Units Per Semester) ÷ ∑Total Units

Computing Cumulative GPA for 2 Semesters

• Semester 1 GPA: 3.50 (Total Units: 15)
• Semester 2 GPA: 3.70 (Total Units: 18)

CGPA = ((3.50×15) + (3.70×18)​) ÷ (15+18) = (52.5 + 66.6) ÷ 33 = 119.1 ÷ 33 = 3.61

So, your Cumulative GPA is 3.61.

Percentage Average Calculator – How to Convert Grades to Percentages?

Many schools in the Philippines use percentage-based grading. A Percentage Average Calculator helps determine your final percentage score.

Formula for Percentage Average:

Percentage Average = ∑All Percentage Scores ÷ Number of Subjects

Example – Calculating Percentage Average for High School

If your subject scores are:

Percentage Average = (88 + 92 + 85 + 90 + 87) ÷ 5 = 442 ÷ 5 ​= 88.4%

So, your final percentage average is 88.4%.

Batting Average Calculator – Track Your Performance in Baseball or Cricket

In the Philippines, baseball and softball are more popular than cricket, but for those following cricket, a Batting Average Calculator helps measure a player's performance at bat.

Formula for Batting Average:

Batting Average = Total Runs Scored ÷ Total Number of Times Out

Example: Batting Average in Baseball

A baseball player scores 20 hits in 50 at-bats.

Batting Average = 20 ÷ 50​ = 0.40

So, the player's batting average is 0.40.

Example: Batting Average in Cricket

A cricketer scores 450 runs in 9 innings and has been out 9 times.

Batting Average = 450 ÷ 9 ​= 50.00

So, the player's batting average is 50.00.

Good to know

• Averages are everywhere, from daily commute times to grades, business sales, and investments.
• Understanding different types of averages (simple, weighted, moving) helps in better decision-making.
• Using online tools like our Average Calculator saves time and simplifies calculations.

Try our free Average Calculator today and make quick, accurate calculations for your daily needs!

Nishadh Mohammed

Nishadh Mohammed is a seasoned news editor and financial writer, working with HelloSafe since May 2023. Nishadh has developed expertise in financial markets, insurance, and investment products, with a deep understanding of the Canadian financial landscape. He has honed his SEO skills and content marketing strategies while writing for Canadian publishing houses. Armed with a master's in Business Analytics and extensive journalistic experience, Nishadh uniquely combines data proficiency and thorough research to deliver comprehensive and accessible information.