# How to adjust a set/column of numbers closer to 0? Regression? Curve-fitting?

#### philia

##### New Member
I'm wondering how I would go about solving this problem:

I have a set/column of 60 numbers (percentages). They were generated
from a database program which generated them with an input value of 50

Some percentages are above 0, some are below 0. (The range is 5% to -23%.) The 60 numbers are on average 2.5% below 0 with a standard deviation of 4.85%.

How do I move the total set of percentages closer to 0? Do I need
to generate new percentages with, say, an input of 52.5 and 55 and so on
(increasing the input value by the current average precentage) and then somehow calibrate or slope the changes?

problem is it? It has been a long time since I've contemplated
curve-fitting and regression analysis, and I'm not even sure such
approaches apply to this problem.

Thank you.

### Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Replies
3
Views
280
Replies
3
Views
277
Replies
1
Views
180
Replies
1
Views
1K
Replies
0
Views
333