Foreign
So let’s say that I am putting some population data. For example, I am putting the decadal sensors for the year 1991, then I am putting it for 2001, and then I am putting it for 2011. Let’s say that this year had 100 people, this year had 120 people, and this year has 135 people, right?
Now, I want to calculate the population for the year 2023 and one more census in 2021, let’s say the people were 140.
Now, we need to calculate the projected population using three methods: arithmetic increase method, geometric increase method, and incremental increase method.
But we don’t know how to put a formula here. So what we can do is we can write ‘Please calculate the population’. But do you think this will work? No, this will not work.
So we just cut this thing and then we tell the same thing to ChatGPT. We say, ‘Listen, ChatGPT, I have put something in columns A1, A2, A3, A4, and then I need something in the column C7. What do we need? That is something I am going to enter now.’
Okay, I have entered some population data in cells B1 to B4 for four decades, and I want to calculate the population using the geometric method in Excel. Please give me a formula.
Now, one more thing that you can do here is you can actually tell ChatGPT that for the four decades mentioned in A1 to A4, so accordingly, you give me a formula that I can simply paste it and then I can get the calculations done.
Okay, so it has actually done our work. Now, let’s say that we want to calculate the population using the geometric method in Excel for the years 2035 and 2050 based on the population data in B1 to B4 and the corresponding years in A1 to A4. You can use the formula assuming that the cell where you want to calculate the population for 2035 is C1 and for 2050 is C2. You can use the following formulas:
For 2035: [formula] For 2050: [formula]
So you see, this is the population. Now, we know that populations cannot be in a fraction, but still, we can manipulate it and decrease the decimals. Okay, so it will be actually 224. This is the value for the year 2035. Then, similarly, for 2050, the population has been calculated.
So, that’s it for this lecture. To know more about how you can use Excel using ChatGPT, you can refer to the ebook provided in the link in the description.
