Calculating mid-point values

[maculata]

I have a data set that includes multiple measurements within each wholenumber (e.g. 1.23, 1.59, 1.95). The range is from 0 - 600. I want to calculate/estimate the midpoint values for each whole number from 1 to 600 (e.g. 1.5, 2.5, 3.5, 4.5, etc...). What is the easiest way to do this in excel? I considered plotting every measurement on a curve and then somehow instructing excel to find the midpoint values for each whole number? How is this done or is there a better way to accomplish this task?

 

[Scott Huish]

Hi, welcome to the board!

Is this what you want?

Excel Workbook
	A	B
1	1.23	1.5
2	1.59	1.5
3	1.95	1.5
Sheet1

 

[thunder_anger]

is this what you want

<TABLE style="WIDTH: 144pt; BORDER-COLLAPSE: collapse" dir=rtl border=0 cellSpacing=0 cellPadding=0 width=192><COLGROUP><COL style="WIDTH: 54pt" width=72><COL style="WIDTH: 90pt; mso-width-source: userset; mso-width-alt: 3840" width=120><TBODY><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 54pt; HEIGHT: 14.25pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" dir=ltr height=19 width=72 align=right>1.5</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 90pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" dir=ltr width=120 align=right>12</TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" dir=ltr height=19 align=right>2.5</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" dir=ltr class=xl63></TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" dir=ltr height=19 align=right>3.5</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" dir=ltr class=xl63></TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" dir=ltr height=19 align=right>4.5</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" dir=ltr class=xl63></TD></TR></TBODY></TABLE>
12 is he sum of the nubers from 1.5 to 600 step 1??

 

[maculata]

Sorry, I didn't explain that well at all. Here's a sample of my light measurement data

column A Column B
300.23 33.2172
300.59 33.768
300.95 34.3984
301.31 35.005
301.67 35.606
302.03 36.214
302.39 36.815
302.76 37.3566

Column A is the wavelengths at which the corresponding column B measurements were taken. I'd like to calculate/estimate what the midpoint value would be for each wavelength (300.5, 301.5, 302.5)<table border="0" cellpadding="0" cellspacing="0" width="128"><tbody><tr style="height: 12.75pt;" height="17"><td style="width: 48pt;" align="right" width="64">
</td></tr><tr style="height: 12.75pt;" height="17"><td align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td align="right">
</td></tr><tr style="height: 12.75pt;" height="17"><td align="right">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td align="right">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td align="right">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td align="right">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td align="right">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td align="right">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td align="right">
</td> </tr> </tbody></table>

 

[Scott Huish]

How is that different than the answer I gave?