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.

Evner: Matematik

Se mere: 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

Om arbejdsgiveren:
( 5 bedømmelser ) BISHOP AUCKLAND, United Kingdom

Projekt ID: #19000869

10 freelancere byder i gennemsnit $168 på dette job


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 Flere

$200 USD in 3 dage
(36 bedømmelser)

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 Flere

$150 USD in 3 dage
(21 bedømmelser)

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 dage
(22 bedømmelser)

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 Flere

$133 USD in 3 dage
(1 bedømmelse)

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 Flere

$100 USD in 3 dage
(0 bedømmelser)

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

$133 USD in 3 dage
(0 bedømmelser)

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 Flere

$500 USD in 3 dage
(0 bedømmelser)

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 Flere

$120 USD in 3 dage
(0 bedømmelser)

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 Flere

$166 USD in 3 dage
(0 bedømmelser)

Math instructor

$30 USD in 3 dage
(0 bedømmelser)