How to calculate quarter-on-quarter
In data analysis, quarter-on-quarter is an important metric that measures the growth or decline in a given quarter compared to the previous quarter. This article will introduce the quarter-on-quarter calculation method in detail, and combine it with the hot topics and hot content on the entire network in the past 10 days to help readers better understand this concept.
1. Quarter-on-quarter calculation method
The quarter-on-quarter calculation formula is as follows:
| indicator | formula |
|---|---|
| Quarter-on-quarter growth rate | (Data for this period - Data for the previous period) / Data for the previous period × 100% |
For example, if a company's revenue in the first quarter is 1 million yuan and its revenue in the second quarter is 1.2 million yuan, the quarter-on-quarter growth rate in the second quarter is:
| Data for this period | Last period data | month-on-month growth rate |
|---|---|---|
| 1.2 million yuan | 1 million yuan | (120 - 100) / 100 × 100% = 20% |
2. Hot topics and content on the entire network in the past 10 days
The following are the hot topics and content that have been highly discussed across the Internet in the past 10 days:
| hot topics | Discussion popularity | Related fields |
|---|---|---|
| New breakthroughs in artificial intelligence technology | high | Technology |
| global climate change summit | high | environment |
| New energy vehicle sales growth | in | car |
| E-commerce platform quarterly financial report | in | economy |
| healthy eating trends | low | life |
3. Practical application cases on a quarter-on-quarter basis
Taking the quarterly financial report of an e-commerce platform as an example, assume that the revenue data of a platform in the past two quarters are as follows:
| quarter | Revenue (100 million yuan) | month-on-month growth rate |
|---|---|---|
| first quarter | 50 | - |
| second quarter | 60 | (60 - 50) / 50 × 100% = 20% |
As can be seen from the table, the e-commerce platform's revenue in the second quarter increased by 20% month-on-month, and its performance was relatively strong.
4. The difference between quarter-on-quarter and year-on-year
Quarter-on-quarter and year-on-year are two different concepts, and their differences are as follows:
| indicator | Comparison object | Applicable scenarios |
|---|---|---|
| quarter-on-quarter | last quarter | Short term trend analysis |
| Year-on-year | same period last year | Long term trend analysis |
For example, if a company's revenue in the second quarter of 2023 is 6 billion yuan, and its revenue in the second quarter of 2022 is 5 billion yuan, the year-on-year growth rate is:
| Data for this period | Data for the same period last year | year-on-year growth rate |
|---|---|---|
| 6 billion yuan | 5 billion yuan | (60 - 50) / 50 × 100% = 20% |
5. Summary
Quarter-on-quarter is an important indicator for measuring short-term economic or business performance and can help companies and investors quickly understand the latest developments. Through the introduction of this article, I believe that readers have mastered the quarter-on-quarter calculation method and can conduct analysis based on actual data. Whether it is e-commerce platforms, new energy vehicle sales, or other fields, quarter-on-quarter can provide valuable reference information.
Hope this article helps you! If you have any questions, please leave a message in the comment area for discussion.
check the details
check the details
en
