Histogram, Cohort and Regression Analysis

$30-250 SGD

Completed

Posted

over 8 years ago

$30-250 SGD

Paid on delivery

This work requires a relatively high skill level of Excel analysis. > If you feel this work is within your capability I can share the Excel file. > > - Each row of the data will represent one delivery of one product type for one customer on one particular date. > - All data is for year 2015 > - The deliveries are of so-called "Meal Kits" of the sort you find here [login to view URL] > - The rows will be as follows: > - cusid - unique customer identification number > - product - product identification number > - deldate - date of delivery > - month - calendar month > - week - calendar week > - price - product price > - shortdesc - short descripton > - proddesc - description of product (in dutch) > > Using this data I am interested to get insights on a number of things: > 1) Historgram Analysis ([login to view URL]): > By "shortdesc", what proportion of unique customers order 1, 2, 3, 4, 5 times etc. > > 2) Cohort Analysis ([login to view URL]). I would like to know: > - By "week" > - By "shortdesc" > - Count of brand new customers ordering for the first time > - % of customers who then ordered a 2nd time, 3rd time, 4th time etc (all the way up to 30th time) > > There are 33 weeks of data and 8 "shortdesc" products. The first 4 products were sold between week 10 and week 27, the other 4 products were sold between week 28 to 43. This means there should be 264 cohorts that need plotting. Ideally I would like to see these weekly cohorts plotted as line charts, where the first data point (the week of first delivery) is 100% and each week thereafter is a sliding % of customers still ordering. In total there would be 8 separate charts, one for each product. > > 2) Ordering Pattern > For each of the products, I am interested to know if the customers order one delivery after another and then simply stop, or if they order only here and there (for example, order 8 times over 24 weeks but with 3 week intervals). I don't have a specific idea how to represent this pattern - can you make a suggestion? > > Please don't hesitate to come back with questions, especially on the budget and end date estimates.

Analytics

Business Analysis

Project ID: 8848383

About the project

15 proposals

Remote project

Active 9 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@Hassanmurtza

I have a strong and proven track record of doing DATA ANALYSIS, STATISTICAL ANALYSIS, SURVEY ANALYSIS AND FORECASTING FUTURE OUTCOMES IN FINANCIAL MARKETS. I have worked entire data analysis life cycle from requirements through listing, questionnaire design, field strategy, data gathering, cleaning, analysis and reporting. Moreover, I assisted economists and public policy experts based at HARVARD UNIVERSITY, PRINCETON UNIVERSITY, LONDON SCHOOL OF ECONOMICS AND LAHORE UNIVERSITY OF MANAGEMENT SCIENCES. I have the experience, confidence, demeanor and desire to be in position where I can manage development solutions. I speak well in public and have strong technical writing skills. In addition, I am willing and able to take on leadership roles. I have a thorough understanding of econometrics, statistics and finance how the Regression and economic analysis could be used to interoperate the data meaningfully. Able to work on own initiative and as part of a team. First-class analytical, design and problem solving skills. Well-versed in current and new finance methodologies. 1. Strong knowledge and experience of complete data analysis life cycle. 2. Highly skilled in statistical software’s like STATA, Excel and SPSS 3. Proven ability to determine priorities, schedule work and meet critical deadlines. 4. Proven ability to manage a team and use of scarce resources efficiently.

$200 SGD in 3 days

4.6

(1 review)

2.4

15 freelancers are bidding on average $376 SGD for this job

@gregorybair

Greetings! I am an Excel guru with 15 years of experience. I am well-versed in macro and Visual Basic, PivotTables and PivotCharts, and I work with quality, not speed as my goal. I hold both Bachelor of Business Administration and Master of Business Administration degrees. None of the work I do is ever outsourced. I would like to work with you on this project, and I invite you to contact me via www.Freelancer.com to discuss specifics. Thank you in advance. Gregory Bair 1

$2,194 SGD in 10 days

4.9

(371 reviews)

9.1

@Ziakhan2013

TURNITIN Plagiarism Report, Perfect work and references will be shared. I am having a Phd, Masters of Science in Management Sciences and Bachelors of Science in Business Administration having gold medals in both. I have completed my A & O Levels from Cambridge. I have been working as an academic writer for the last 3 years having great experience of working on various projects, academic writing tasks, essays, dissertations, proposals and reports. I have great research, communication and problem-solving skills that distinguish me from others. I am responsible, committed and dedicated to meeting the deadline by submitting high-quality work. I can follow Harvard, MLA & APA referencing styles according to your requirements. I also check the plagiarism of my work on Turnitin and write check before submission that i can share with you for the originality of my work. Hopefully I get this opportunity to work with you as I am sure it will be a good working experience.

$51 SGD in 3 days

4.9

(213 reviews)

7.0

@tolgahantarkan

Hi Pete, I had also bid to your project on Upwork. I made an even lower bid here. Hope work with you on this project. In order to remind you who I am here is my proposal: I am an industrial engineer holding masters degree from Sweden. I have been working as a business and supply chain consultant for more than 2 years. During this time I have analyzed huge amount of data in MS Excel and Access most of which is related to logistics. I can do all the analysis and charts you need very easily. I have created hundreds of pivot tables, histograms. I also done cohort analysis a few times so I know how to do it. I can also design online interactive charts for you which could be much more appealing. Would you be interested in that? Looking forward to hear from you, Best Regards, Tolgahan

$189 SGD in 2 days

5.0

(8 reviews)

4.5

@suyashdhoot

Hi I am a very experienced statistician . I have completed several pHD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have done projects involving high level quantitative analysis and data interpretation skills to study the trends, time behaviour and compare the variables in the data. I can do advanced level analysis in SPSS, R, WEKA and excel tools like machine learning, hypothesis testing, forecasting, T-test, ANOVA etc. Looking forward to discussion, Best Regards, Suyash

$500 SGD in 3 days

4.6

(8 reviews)

4.2

@naveenthourani

Dear Valued Employer, I can add value to your project, by suggesting new ideas. I am fast and reliable. For further understanding why I am the right candidate for your project, kindly check my profile, reviews, rating and portfolio. With over 8 years of cross-functional experience, and helping clients world wide, I provide genuine and innovative solutions as per your circumstances and requirements. I hold MBA-Finance, M.A-Economics and Chartered Accountancy. If you feel to discuss more before you award me the project, you can send me the message. Kind regards, Freelancer

$277 SGD in 7 days

4.4

(3 reviews)

2.8

@principal0

I've performed analysis of this nature for multiple clients, mostly local technology companies in Silicon Valley. I also have intimate familiarity with Excel after nearly a decade of experience in Wall Street firms. As a word of advice, regardless of whether you select my bid, I would be concerned about anyone bidding outside the US/Europe, to be frank. I've put design projects on this website, and taken bids from areas outside the US/EU, and have fairly routinely been disappointed in the results. Good luck with your project, and I'll look forward to your decision. Best, Matt

$155 SGD in 3 days

0.0

(0 reviews)

0.0

@rpmathur

Following is my proposition for analyzing the ordering patterns. For each customer, create a histogram of orders per unit time. Perform a neighborhood averaging filter, which is a common algorithm in image processing. Basically, a new data set is created, where a given element is calculated by averaging the value of elements in that and neighboring positions in the first set. For example, the 5th entry in the new set is calculated by averaging the 4th, 5th, and 6th entries in the original set. Then take the peak value, normalize it by dividing by this customer's overall average, and this gives a quality factor for how distributed their purchases are. Consider 3 customers, who each bought 4 items in 8 weeks. Person A bought one item every other week. Person B bought one item every week for the first four weeks. C bought 4 items the first week. The processed set for A is [.5 .5 .5 .5 .5 .5 .5 .5], person B is [1.0 1.0 1.0 .66 .33 0 0 0] and person C is [4 2.66 0 0 0 0 0 0]. The highest value for A is .5 , B is 1.0, and C is 4.0. From these numbers we can tell that A was the most evenly distributed, C had the sharpest spike, and B was in between. In addition to my idea for the ordering pattern, I would like to mention I have extensive experience with excel, and I believe I could accomplish all of this in 1-2 days. I quoted 7 so you may review my results, and let me know any changes you would like done. Thank you, Ronjan Thank you,

$144 SGD in 7 days

0.0

(0 reviews)

0.0

@MGRUHITHA

A proposal has not yet been provided

$155 SGD in 3 days

0.0

(0 reviews)

0.0

@ranasgautam

I bring with me close to 20 years of experience in Predictive Analytics, Informatics, Visualization and Consulting. Backed by ability to see across multiple domain areas and connect disparate pieces to come up with new ideas. I bring in creativity to solve practical business problems. While I started my career as research assistant undertaking Qualitative Research, in recent past lot of my work has been in the area of Explanatory Research and Predictive Analytics. Bulk of my work has been in the Banking and Financial Services spanning over Retail, Cards and Trade Operations. Excel is not the best tool to carry this out. Regression is more about validation of model which cannot be done with excel. I will carry this out in R and can share any insight you desire. I have understood your need however would like to have a discussion on the same

$155 SGD in 3 days

0.0

(0 reviews)

0.0

@jk31

Hello, I think this work is in my capability. NOT with my Excel analysis skills, but using my programming skills (I would program in Python and eventually R). The excel files I will use as .csv files for this purpose. 1) Histogram Analysis: This I could perform the counting via Python programming and using Libre-office calc (which is compatible with Excel) for plotting. 2) Cohort Analysis: Also one could using Python for counting and visualize using Libre-office calc. For me, your problems are all about counting and bring them in a form which Excel (or Libre-office Calc) can represent in a nice graphical form. This should not be a big problem. Programming takes more time, but you can ask for more complex steps for analysis. We could think together about a good visualization strategy to find out the information you actually want. 3) Ordering Pattern: I think for this problem, a good visualization is key - to have a good overview in a small graphical area. And depending on which pattern one can see, one has eventually to change the counting strategy and plotting strategy. I will be flexible concerning the analysis procedure, but I would need eventually more time, since I won't be 100% of the day at home in front of computer but might work only 50% of my available time for work. That is why I suggest 3 weeks (to be sure, but actually I might be able to do the analysis in much less time ~1-2 weeks). I will decide after I have seen the Excel sheet, to be more sure.

$444 SGD in 21 days

0.0

(0 reviews)

0.0

@jezzalenko1

Hello I have extensive experience with data analysis and have very good excel and report writing skills. I consider that I would be able to help you with your project. Thank you Jeremy

$150 SGD in 3 days

0.0

(0 reviews)

0.0

@herryherman

Will analyze your data

$250 SGD in 7 days

0.0

(0 reviews)

0.0

@gretly

A proposal has not yet been provided

$555 SGD in 8 days

0.0

(0 reviews)

0.0

@FredSA

Hi there, I'm new to Freelancer so I am currently offering 50% discounts to my first 5 customers in order to get my first reviews. Don't hesitate too long! I have extensive experience in Strategy Consulting (4 years at Bain & Company) and second-to-none Excel skills. I am really interested by your project and would actually present the analysis in a different way, as much as I understand your objectives. Your main challenge is that you have weekly orders and only a few weeks of history. 1) You can't compare all your customers on their number of orders, some joined 33 weeks ago and others joined last week. I suggest to replace this analysis by a table with 2 axes: number of weeks since first order vs. number of total orders. 2) Can customers move from one product to the other? If yes I would consider customers as a whole rather than product by product. Also I suggest to have only one dynamic graph instead of 264. It will also allow comparisons. 3) The table in 1) will give you a good view of order frequency. As a deep dive I would replace "first order" by "weeks of activity" with the following definition: "a customer is active week X if he orders week X or any following week". This will give you the average frequency, not the distribution. But if my "answer first" is right 90% of customers will have 100% frequency until they become completely inactive. Happy to discuss a bit more over the phone, not easy to explain this by email. Kind regards, Fred

$222 SGD in 2 days