# Statistical Calculation: calculate correlation between data sets

I sell goods on eBay UK.

I sell various 'product lines' in several different 'categories'.

For each product line I have a set of numbers which are sales values as a percentage of the amount I aim to sell for. Naturally enough I call it 'sell-as-%-of-aim'. I then have an average 'sell-as-%-of-aim' for each product line. I also have an overall average 'sell-as-%-of-aim' for each category.

To estimate future sales values for each product line, I need to know what weighting I should give to the average 'sell-as-%-of-aim' of that product line, and what weighting to give to the average 'sell-as-%-of-aim' of that category.

Also, the more history I have for each line, presumably the more reliable the 'sell-as-%-of-aim' is for that line and the less relevant the 'sell-as-%-of-aim' is for that category. I therefore need to know how to weight between 'sell-as-%-of-aim' of that product line, 'sell-as-%-of-aim' of that category as history builds up.

The resulting equation needs to be 'straight line' simple enough to be programmed into MS Excel, and also simple enough to be easily understood.

All my sales data is in MS Excel and is laid out in a clear and easy to understand way.

Kĩ năng: Toán học

Về Bên Thuê:
( 5 nhận xét ) BISHOP AUCKLAND, United Kingdom

ID dự án: #19000869

## 9 freelancer đang chào giá trung bình \$176 cho công việc này

alkarajput3131

I am a data scientist proficient in machine learning and web scrapping. My expertise in Excel, Python and R have comes from my experience in Natural Language processing, statistical analysis, web scraping etc. I also h Thêm

\$200 USD trong 3 ngày
(36 Nhận xét)
5.1
RushService

Feel fee to contact me for calculate correlation between data [login to view URL] me message to discuss further more details .We provide the comments,images,videos,demos and live sessions in order to help the [login to view URL] p Thêm

\$150 USD trong 3 ngày
(21 Nhận xét)
4.8
blackbox311

Hi. I am a professional in applied mathematics. I have many experiences in statistical analysis. We can discuss details via chat. I wait for you now. Thanks.

\$150 USD trong 3 ngày
(22 Nhận xét)
4.5
invincible1428

Hello, Greetings of the day.!! I have a preferred freelancer badge. Which means I am in top 3% of AI ML freelancer. I have successfully delivered more than 80 AI/ML projects(R and Python) in last 9 Months with best Thêm

\$133 USD trong 3 ngày
(1 Nhận xét)
1.7
derrickquartey

Hello, I am a statistician and I clearly understand the work you need!! I wish to work with you!!

\$133 USD trong 3 ngày
(0 Nhận xét)
0.0
nhathuy

Hello, dear! Welcome to visit my profile. I just checked your project description in detail. My top skills are Mathematics, Algorithm, Control system, Computer Vision, Digital Image Processing and software engineeri Thêm

\$500 USD trong 3 ngày
(0 Nhận xét)
0.0
jswanson1

I take complex statistical procedures and convert them to Excel frequently in my job. I have to make sure I understand your problem but I believe my expertise will make it will a simple task. Relevant Skills and Exper Thêm

\$120 USD trong 3 ngày
(0 Nhận xét)
0.0
xammiegee

I am the best statician in Obafemi Awolowo university and I am very good. i help most final year students work on statical correlation between data sets and I have never disappointed Relevant Skills and Experience SPS Thêm

\$166 USD trong 3 ngày
(0 Nhận xét)
0.0
jhanzvril

Math instructor

\$30 USD trong 3 ngày
(0 Nhận xét)
0.0