Do you eat fruit every day? It has long been said that there is a shift away from fruits, and a survey in 2019 found that 1 Man 1 Fruit intake per day is approx. 100g and is targeted 200g It seems that there is only about half of that.
So what happens when we look at trends in consumption by fruit type?
The figure below shows the purchase quantity of each fruit such as apples, mandarin oranges, and pears from 2010 to 2022 ( 1 what year g (Purchased?) This is expressed as a line graph.
*While there is data on fruit consumption, we use the quantity purchased as it depends on the price of that year.
Data source: Ministry of Internal Affairs and Communications Statistics Bureau Household Survey
Since the weight of each fruit varies, it is difficult to compare fruits using this graph. Fruits that are relatively small in weight (such as strawberries and grapes) are displayed at the bottom of the Y-axis, and it is difficult to tell whether the purchase quantity is increasing or decreasing.
Line graph using indexed data
In such cases, there is a way to use a certain year as a base (100) and express the values of other years as percentages of this base year. this is" Indexization '' and is often used in the economic and financial fields. This method, where the base year is 100 and the values of other years are expressed as percentages of this base year, is also called the "base 100 index."
Therefore, I used 2010 as the standard (100) and expressed the relative percentages of other years as a line graph. Additionally, we changed the color of the polygonal line to remind people of the color of the fruit, and added a label to 2022 (the last year).
This graph shows that the purchase quantity of most fruits in 2022 has decreased compared to 2010. In particular, melon sales have fallen to 56% compared to 2010.
on the other hand, The purchase quantity of kiwifruit has increased by 151% compared to 2010.
Do these results apply to your family? Come to think of it, kiwi fruit is easy to eat and contains vitamins and minerals. C There may be a surprising number of people who think that it is because they are abundant that they start eating them.
To create this indexed line graph in JMP, you need to prepare indexed data in advance.
Exponentialize the data
The original data includes the quantity of each fruit purchased for each year, as shown below. This data is converted into an index, and here we use ``2010'' as an index. 100 You need to convert it into a percentage.
If you are familiar with absolute references in Microsoft Excel, you can also perform this calculation in Excel, but here we will explain how to use JMP's formula.
*This blog has attached a JMP data table ("Fruit consumption quantity (2010-2022) apples.jmp") in which the calculation formula was created using the following steps.
Data table column "apple" (g) '' as an example, you would create a calculation formula like the following.
The calculation formula is a little complicated. The point of this formula is that the calculation formula in the formula
How to make it and its meaning. Knowing the meaning of this calculation formula has a wide range of applications, not just this example, so it's a good idea to remember it. The steps are explained below.
1.Subscript() use functions
Apple (g) then select Subscript() When you select a function, you can specify a subscript as shown below. If you enter “1” in the selected subscript, 1 The value of the apple in the row ( = 12,371 ) can be obtained.
2. Col Minimum() use functions
In this example 2010 If you can obtain the value of apples for each year, you can calculate the percentage for each year from that value, so simply (g) 1 and the subscript 1 However, I will explain a more general method.
As shown below, in the subscript created in step 1, Col Minimum() Insert the function.
Col Minimum(column name ) The function is a function that returns the minimum value of the specified column for the column name specified as an argument.
3. Use the Row() function
Specify the Row() function as the argument of the Col Minimum() function created in step 2.
The Row() function returns the current row number. Therefore, 1 The value of the row is 1 , 2 The value of the row is 2 ,..., Ten The value of the row is Ten It will be.
From steps 2 and 3, Col Minimum(Row()) is the lowest row number of this data ( = 1 ) is returned.
The value of the apple in the first row is the so-called 2010 Since this is the number of apples purchased in a year, we are calculating the percentage for each year from this value.
by Naohiro Masukawa (JMP Japan)
Naohiro Masukawa - JMP User Community
