This is a small project. I have created data comparing the physical properties of my product vs. my competitor. I need this data presented in a 2 or 3 charts or graphs. Data needs to be smoothed, presumably with some type of regression function. I will use the charts or graphs in marketing my product via the web with images or incorporate into a flash video. Specifically I need 1 chart just showing the physical characteristics of my product in 4 different strengths. I also need a chart showing my high correction product vs. my competitor. Attached is raw data. I have a product with four correction strengths 1) high correction, 2) standard correction, 3) low correction and 4) very low correction. The attached excel spreadsheet has data from multiple tests on several of the correction strengths. We can remove the data that does not represent the best case scenario.
Having gone through the numbers and cleaned up the chart, I've posted a sample in my portfolio for you to have a look at. I've used LOESS smoothing to the data and re-plotted three samples. Best Regards Dave
24 freelancers are bidding on average $119 for this job
Hi, I will be happy to help you with this project. I do however need some more clarification especially with regard to identifying the specific columns that need to be plotted in each case
Dear Sir I went trough your project details and the attached spreadsheet I can do this job PERFECTLY Just need few hours to complete I look forward to hearing from you soon Best regards Priyal
It is very easy to made chart in excel and as i have experience in excel i can do best in excel chart with pivot table and dashboard i there is a large amount of data.
Hello. I have extensive Excel and statistical knowledge. I would choose the best smoothing function for your dataset and provide you with quality charts highlighting strong points of your product.