# 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.

Kemahiran: Matematik

Tentang Majikan:
( 5 ulasan ) BISHOP AUCKLAND, United Kingdom

ID Projek: #19000869

## 9 pekerja bebas membida secara purata \$176 untuk pekerjaan ini

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 Lagi

\$200 USD dalam 3 hari
(36 Ulasan)
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 Lagi

\$150 USD dalam 3 hari
(21 Ulasan)
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 dalam 3 hari
(22 Ulasan)
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 Lagi

\$133 USD dalam 3 hari
(1 Ulasan)
1.7
derrickquartey

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

\$133 USD dalam 3 hari
(0 Ulasan)
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 Lagi

\$500 USD dalam 3 hari
(0 Ulasan)
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 Lagi

\$120 USD dalam 3 hari
(0 Ulasan)
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 Lagi

\$166 USD dalam 3 hari
(0 Ulasan)
0.0
jhanzvril

Math instructor

\$30 USD dalam 3 hari
(0 Ulasan)
0.0