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.

Beceriler: Matematik

Daha fazlasını gör: calculate differences data field, spss correlation data entry, list quantitative math data sets, how to correlate two data sets in excel, correlation between two datasets in r, what is the relationship between two sets of data, find relationship between two sets of numbers, correlation calculator, correlation between two different sets of data, how to find correlation between two variables, correlation examples in statistics, python large data sets, data sets resources spss, spss correlation data interpretation, automobile data sets, automotive data sets, calculate financial data, calculate form data, calculate monthly data crystal report, calculate quarterly data

İşveren Hakkında:
( 5 değerlendirme ) BISHOP AUCKLAND, United Kingdom

Proje NO: #19000869

Bu iş için 10 freelancer ortalamada $168 teklif veriyor


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 Daha Fazla

$200 USD in 3 gün içinde
(36 Değerlendirme)

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 Daha Fazla

$150 USD in 3 gün içinde
(21 Değerlendirme)

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 in 3 gün içinde
(22 Değerlendirme)

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 Daha Fazla

$133 USD in 3 gün içinde
(1 Yorum)

Hi I am an electrical engineer and a lecturer in a reputed university. I can help you accomplish the analysis because of my knowledge and experience in such jobs. I will explain the logic behind the solution in a Daha Fazla

$100 USD in 3 gün içinde
(0 Değerlendirme)

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

$133 USD in 3 gün içinde
(0 Değerlendirme)

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 Daha Fazla

$500 USD in 3 gün içinde
(0 Değerlendirme)

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 Daha Fazla

$120 USD in 3 gün içinde
(0 Değerlendirme)

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 Daha Fazla

$166 USD in 3 gün içinde
(0 Değerlendirme)

Math instructor

$30 USD in 3 gün içinde
(0 Değerlendirme)