# Calculating missing numbers

#### Romanseight18

##### New Member
I have several tables that indicate a cost per measurement. I need to determine costs for sizes that are not provided.

 LOW 4 6 8 12 14 16 18 20 24 16 ? ? ? ? ? ? ? ? ? 18 ? ? ? ? ? ? ? ? ? 20 ? ? 53.84 45.39 42.53 40.21 38.25 55.50 51.78 24 ? ? 52.28 43.64 40.74 38.39 36.42 51.97 48.05 28 ? ? 50.99 42.22 39.28 36.92 34.93 49.16 45.11 32 ? ? 49.90 41.02 38.06 35.69 33.70 46.85 42.71 36 ? ? 48.96 39.99 37.02 34.63 32.64 44.91 40.70 40 ? ? 48.13 39.09 36.11 33.72 31.73 43.24 38.98 44 ? ? 47.39 38.30 35.31 32.91 30.92 41.78 37.49 48 ? ? 46.73 37.58 34.59 32.19 30.20 40.49 36.18 52 ? ? 46.13 36.94 33.94 31.54 29.56 39.34 35.01 56 ? ? 45.58 36.36 33.35 30.96 28.97 38.30 33.96

<tbody>
</tbody>

How do I come up with numbers for where the question marks are? I tried grabbing the handle and spreading out the table and that works for some but not all of the numbers. I have tried trend and growth, but to no avail. I am certain it is something simple that I am doing wrong, but I have not been able to figure out what it is. Notice the smaller the "size" the higher the numbers.

Any help is greatly appreciated!

### Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Welcome to the board.

Look at this row:

20 ? ? 53.84 45.39 42.53 40.21 38.25 55.50 51.78
Does that look like something smooth that could be extrapolated to the left?

The other rows are similar -- the price goes down and then jumps up.

Last edited:
I think I included too many numbers. Sorry! There is a break where the numbers jump. These are numbers that represent a cost for Single Wide Manufactured Homes verses double-wides, which is why the numbers drop and then jump again. I should not have included that second set of numbers. (Not smart on my part!) I should not have included anything to the right of 18.

Having some insight into what those numbers represent and why they are what they are would guide you on how to extrapolate them. There's no context to the problem, just a bunch of numbers.

Replies
5
Views
636

1,196,116
Messages
6,013,563
Members
441,771
Latest member
clamnets

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back