Tjyylli

Is it possible to make a 9x9 table fit within the default margins?

Calculate the Mean mean of two numbers

What steps are necessary to read a Modern SSD in Medieval Europe?

My boss doesn't want me to have a side project

Salesforce opportunity stages

Prodigo = pro + ago?

Raspberry pi 3 B with Ubuntu 18.04 server arm64: what pi version

Incomplete cube

Why did the Drakh emissary look so blurred in S04:E11 "Lines of Communication"?

What did the word "leisure" mean in late 18th Century usage?

Car headlights in a world without electricity

Is it okay to majorly distort historical facts while writing a fiction story?

Calculating discount not working

How to pronounce fünf in 45

Are British MPs missing the point, with these 'Indicative Votes'?

Is there a rule of thumb for determining the amount one should accept for of a settlement offer?

Upgrading From a 9 Speed Sora Derailleur?

Is it a bad idea to plug the other end of ESD strap to wall ground?

How to show a landlord what we have in savings?

How to unfasten electrical subpanel attached with ramset

Cannot restore registry to default in Windows 10?

Find a path from s to t using as few red nodes as possible

What difference does it make matching a word with/without a trailing whitespace?

How do I keep Mac Emacs from trapping M-`?

Fill in blanks in a table with hyperbolic regression

0

1

I have a table as follows:

with the table continuing for about another 60 cells in the direction of the arrows.

I would like the fill the blanks in each of the countries, to have a completed dataset. I'm trying to make a table to compare to another 20 datasets (which all start in 1977), but I could only find annually available data from 1990 onwards, and a standalone list from 1977. I'd like to fill in the gaps, to at least have a usable, if not accurate, dataset.

After some experimentation and trial/error on this calculator, I've worked out that the best regression to use for this specific dataset is a hyperbolic regression. While I've found a couple of example implementations, none of them have been suitable to the layout I have, where it would be very difficult to have five helper rows for each row of data. I'd like one formula that I could just drag down/across to get all of my cells filled.

Thanks in advance.

microsoft-excel worksheet-function

share|improve this question

edited 3 hours ago

Geza Kerecsenyi

asked 4 hours ago

Geza KerecsenyiGeza Kerecsenyi

1799

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Here's a link for what you're asking: engineerexcel.com/hyperbolic-curve-fitting-excel. But hyperbolic regression won't give you the answer you think you want. If you can provide more detail on what the data represents, what data is available, the accuracy of the data, what you're trying to model or compare, etc., I can try to provide a little insight.
  
  – fixer1234
  1 hour ago
  

  
  
  
  

add a comment | 

0

1

I have a table as follows:

with the table continuing for about another 60 cells in the direction of the arrows.

I would like the fill the blanks in each of the countries, to have a completed dataset. I'm trying to make a table to compare to another 20 datasets (which all start in 1977), but I could only find annually available data from 1990 onwards, and a standalone list from 1977. I'd like to fill in the gaps, to at least have a usable, if not accurate, dataset.

After some experimentation and trial/error on this calculator, I've worked out that the best regression to use for this specific dataset is a hyperbolic regression. While I've found a couple of example implementations, none of them have been suitable to the layout I have, where it would be very difficult to have five helper rows for each row of data. I'd like one formula that I could just drag down/across to get all of my cells filled.

Thanks in advance.

microsoft-excel worksheet-function

share|improve this question

edited 3 hours ago

Geza Kerecsenyi

asked 4 hours ago

Geza KerecsenyiGeza Kerecsenyi

1799

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Here's a link for what you're asking: engineerexcel.com/hyperbolic-curve-fitting-excel. But hyperbolic regression won't give you the answer you think you want. If you can provide more detail on what the data represents, what data is available, the accuracy of the data, what you're trying to model or compare, etc., I can try to provide a little insight.
  
  – fixer1234
  1 hour ago
  

  
  
  
  

add a comment | 

I have a table as follows:

with the table continuing for about another 60 cells in the direction of the arrows.

I would like the fill the blanks in each of the countries, to have a completed dataset. I'm trying to make a table to compare to another 20 datasets (which all start in 1977), but I could only find annually available data from 1990 onwards, and a standalone list from 1977. I'd like to fill in the gaps, to at least have a usable, if not accurate, dataset.

After some experimentation and trial/error on this calculator, I've worked out that the best regression to use for this specific dataset is a hyperbolic regression. While I've found a couple of example implementations, none of them have been suitable to the layout I have, where it would be very difficult to have five helper rows for each row of data. I'd like one formula that I could just drag down/across to get all of my cells filled.

Thanks in advance.

microsoft-excel worksheet-function

share|improve this question

edited 3 hours ago

Geza Kerecsenyi

asked 4 hours ago

Geza KerecsenyiGeza Kerecsenyi

1799

share|improve this question

edited 3 hours ago

Geza Kerecsenyi

asked 4 hours ago

Geza KerecsenyiGeza Kerecsenyi

1799

share|improve this question

edited 3 hours ago

Geza Kerecsenyi

asked 4 hours ago

Geza KerecsenyiGeza Kerecsenyi

1799

asked 4 hours ago

Geza KerecsenyiGeza Kerecsenyi

1799

asked 4 hours ago

Geza KerecsenyiGeza Kerecsenyi

1799