A special CPI is constructed to measure the variation of these products, so that coffee and bread have a weight of 0.35 of the t
otal and egg, ham and cheese 0.1 of the total. variation of the CPI?
1 answer:
9514 1404 393
Answer:
The CPI increased 3.42% in Month 2.
Step-by-step explanation:
In a spreadsheet, the weighted sum is easily computed using the SUMPRODUCT( ) function. It multiplies the corresponding values of two arrays, then returns the sum of those products. If one of the values is a weight, then the result is a weighted sum.
Your CPI is computed as the weighted sum of the prices of the individual products. The percentage change is computed in the usual way:
pct change = ((new value)/(old value) -1) × 100%
Of course, the spreadsheet can format a fraction as a percentage, so the computation of the change can stop after 1 is subtracted from the ratio.
You might be interested in
The total surface area of any given net of a rectangular prism = area of each rectangular face.
<h3>What is the Total Surface Area of a Rectangular Prism?</h3>If we are given the net of a rectangular prism, the total surface area of the rectangular prism is the area of each rectangular face all summed together.
The image of the net of the rectangular prism is missing, however, let's assume the image attached below is the net of the prism.
Therefore, the total surface area of the rectangular prism = area of each rectangular face = 20 + 8 + 40 + 8 + 20 + 40 = 96 cm².
Learn more about the rectangular prism on:
