Kapalı

Excel-based trend analysis worksheet

I have several years worth of sales data that is daily in nature and also broken down by the minute if needed. I want to copy and paste the data into the spreadsheet, and what I need the Excel to do is show me variables such as (examples only):

1. Sales on January 15th are up versus January 14th 82% of the time.

2. Sales at 1230 local time are down versus 1215 local time 60% of the time

3. Sales at 1230 local time are up versus 1215 local time sales 80% of the time on the date May 6th.

Those types of scenarios. I just need the worksheet to do a +/- calculation from the data point before, and then be able to pivot it to find trends based upon time of day, date, or both.

Thanks for your interest.

Beceriler: Excel, Microsoft

Daha fazlasını görün: excel for data analysis, trend , spreadsheet microsoft excel, sales data and trend, microsoft data analysis, excel PIVOT, excel calculation, excel based, analysis excel spreadsheet, data trends excel, excel sales worksheet, daily sales spreadsheet excel, excel minute, date analysis excel, point excel, excel find date, daily sales excel spreadsheet, data analysis excel spreadsheet, daily trend, daily sales excel, spreadsheet data analysis, daily pivot, based pivot, excel sales analysis, spreadsheet sales data

İşveren Hakkında:
( 0 değerlendirme ) Bilbês, Egypt

Proje NO: #6530423

36 freelancer bu iş için ortalamada 477$ teklif veriyor

sawangupta

Hi, I can help you with your requirement. I have closed more than 150 excel projects at various forums. Please provide more details to help you better. Regards Sawan

in 10 gün içinde250$ USD
(26 Değerlendirme)
5.1
aarifakhtar

Hi: Please note that I have 100% completion rate and 5-star feedback on projects. Please connect with me to discuss more.

in 10 gün içinde250$ USD
(31 Değerlendirme)
5.0
xazoo

Hello! Being a Chartered Accountant I would love to work on this project, I hold Masters Degree of Economics as well and I am 100% sure, I can do this project professionally. You can check my reviews for my quality an Daha fazlası

in 7 gün içinde250$ USD
(28 Değerlendirme)
5.0
vikas0903

Hi, I am working as Lead Pricing Analyst in a Fortune 500 MNC. I have worked on pricing models, income statements, value-pricing projects etc. Some of the projects which I have done include: 1) Pattern identifi Daha fazlası

in 7 gün içinde333$ USD
(17 Değerlendirme)
4.8
khushh07

Hi I have seen your job post and understood your requirement . As an expert in web search and data analysis, I can do the job you posted within given time frame with maximum accuracy, and looking forward to work wit Daha fazlası

in 10 gün içinde250$ USD
(5 Değerlendirme)
3.6
wyliechan

10y Excel data analysis experience. time-series analysis correlations, causality... several years worth of daily sales data also broken down by the minute if needed. I want to copy and paste the data into th Daha fazlası

in 2 gün içinde250$ USD
(3 Değerlendirme)
3.5
kanchana1974

Hi, I would like to do your assignment. I have good experience in Excel functions, scenario analysis, pivot etc. The above would be delivered with high quality through predefined template and intellectual analys Daha fazlası

in 10 gün içinde250$ USD
(3 Değerlendirme)
2.2
MKL7

Dear, I understand that you are looking for someone who is strong with Excel and can build a tool to analyze a large amount of data. I hope to be able to have a look at this together with you as soon as possible Daha fazlası

in 3 gün içinde250$ USD
(3 Değerlendirme)
1.6
karanrajput1112

As a Post Graduate in Statistics and graduate in mathematics, i have a lot of experience in handling statistical data, especially in Time Series Modelling & Forecasting, Regression analysis,correlation , ANOVA, statist Daha fazlası

in 10 gün içinde271$ USD
(1 Değerlendirme)
0.8
msridge

Hi! I am pleased to offer you my MS Excel services. Message to discuss further details of this tasks. Thanks msridge

in 10 gün içinde555$ USD
(1 Değerlendirme)
0.8
tandonshailendra

I understand you have large data. To get the desired results from that you would need macro and Pivot table approach. Please send the sample data to enable plan. About Myself Good Day!. Let me introduce myself fo Daha fazlası

in 7 gün içinde300$ USD
(1 Değerlendirme)
0.0
anooppadhye

A proposal has not yet been provided

in 2 gün içinde288$ USD
(0 Değerlendirme)
0.0
michaljedryka

Hi, I am data analyst by profession and build different dashboards on daily basis, can do the task for You. Kind regards Michal

in 4 gün içinde250$ USD
(0 Değerlendirme)
0.0
hridayan

A proposal has not yet been provided

in 25 gün içinde777$ USD
(0 Değerlendirme)
0.0
mania00

Hello. I'm practiced on excel program as well as treathing some statistical data programming. And now I have a lot time to do this job. So, feel free to cantact me.

in 2 gün içinde352$ USD
(0 Değerlendirme)
0.0
ashurao

~~~Master in Mathematical Statistics~~~ Expert: @Time Series Analysis, Econometrics, Design of Experiment, @Multivariate analysis,Linear Regression analysis, @Bio-Statistics, Actuarial Statistics. Daha fazlası

in 8 gün içinde333$ USD
(0 Değerlendirme)
0.0
sathishiim1985

I have good experience in excel, data mining and analysis. I work in investment research and Corporate finance area and I am sure I would meet your expectation.

in 10 gün içinde555$ USD
(0 Değerlendirme)
0.0
apoorv1989

I have a 3 years work experience as a Business Analyst and have worked for Walmart & P&G. Have very good data analysis skills and can provide actionable insights. Am Microsoft certified advanced Excel trainer and goo Daha fazlası

in 7 gün içinde250$ USD
(0 Değerlendirme)
0.0
Rahul9911

I have worked with Microsoft Pro(Enterprise) support for 4 years in the networking department and Office 365 department. I have excellent skills with manipulating Excel sheets. Pivots/Filtering/Vlookup are just some Daha fazlası

in 5 gün içinde250$ USD
(0 Değerlendirme)
0.0
prashantpatole

Super Simple Software - As per our name we developed super and simple software to fulfil the user's requirement at user's cost. Our work maintain long relationship.

in 9 gün içinde750$ USD
(0 Değerlendirme)
0.0