early morning stats help

[jst0ney]

Please help me with this simple stats problem. I was never any good at stats. At my work I get bonuses every pay period for a certain task. Every two weeks I tally how many times I do this then get paid accordingly. Well we have both determinded that tallying it every two weeks is a PITA. So we decided to come up with a number to be added to my paycheck every week. I have a years worth of data and I'm trying to come up with a number. The mean is around 60, range is 36-103, and the median is 57. I graphed it in excel and put in a linear trendline and found the linear equation to be y=0.6089x + 51.349 with Rsquared=0.0787.

Now from what I understand the R value is not close to 1 indicating that this does not have a linear relationship. Is this right? Is the mean a good number to use. Should be build in incremental increases like adding 1 per pay period?

Thanks.

I can provide more data if needs be.

 

[jst0ney]

no one?

 

[GasX]

You are either over thinking this or trying to get us to do your homework.

 

[HomeAppraiser]

Y = # of times and X = pay periods? Yes y=0.6089x + 51.349 with Rsquared=0.0787 is a nearly flat trendline with non-linear data. Was there a learing curve for the tasks at the beginning of the year? Are you really increasing # of tasks by 1 per pay period? Why not just use the average and adjust every year?

 

[jst0ney]

Originally posted by: Mwilding
You are either over thinking this or trying to get us to do your homework.

No homework here I have been out of school for awhile now. But, yes I am overthinking it. The mean seems reasonable to me but I was just looking for a trend because it will be hard to go back an adjust on an annual basis. Thanks for the input.