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

philia

New Member
Joined
Apr 9, 2011
Messages
19
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?

How should I even go about thinking about this problem? What type of
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.
 

Some videos you may like

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.

Watch MrExcel Video

Forum statistics

Threads
1,118,852
Messages
5,574,663
Members
412,608
Latest member
Guromir
Top