Excel help on Forecast

$10-30 USD

Closed

Posted

over 6 years ago

$10-30 USD

Paid on delivery

I have attempted to solve the problem. My file and the original excel file are attached. a. Prepare a time-series plot of the data. Does the data appear to have a trend or seasonality? b. Use the naïve method to forecast the demand for the last three months of 2016. c. Use the moving average method with 4 periods, i.e., MA(4), to forecast the monthly demand for January 2016 through December 2016. d. Use the exponential smoothing method with alpha =0.4 to forecast the monthly demand for January 2016 through December 2016. Use the actual demand observed in January 2015 as your initial forecast for January 2015 (That is, start the model in January 2015. e. Fit a trend line to the data provided for January 2015 to December 2015. Using the equation of the trend line you found, forecast the monthly demand for January 2016 through December 2016. f. Compute the MAD for each method, that is, the Naïve, MA(4), ES(0.4), and the trend line during January 2016 to September 2016. g. Choose one of the time-series methods you analyzed thus far which will provide you the most reliable estimate and why? What are the demand forecasts for the last three months of 2016 if this method is used?

Project ID: 16038851

About the project

30 proposals

Remote project

Active 6 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

30 freelancers are bidding on average $40 USD for this job

@suyashdhoot

Hi I am a very experienced statistician and academic writer. 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, TABLEAU and excel tools like machine learning, hypothesis testing, forecasting, T-test, ANOVA etc. Looking forward to discussion, Best Regards, Suyash

$150 USD in 1 day

4.8

(133 reviews)

7.0

@usmanhassan123

sir I am MSc computer engineering and MPhil in STATISTICS and already done many forecasting projects. you are at right place please contact with me. Hi sir thanks for your project. I am accounting expert using excel and have designed such worksheets. I will design forecasting sheet with trend line graphs using equation of forecasting.

$30 USD in 1 day

4.8

(113 reviews)

6.4

@sheak

Hello! We are extremely interested in this project and would love to work on this project, please reply back to discuss further. Looking forward to hearing from you soon. Thanks!

$166 USD in 7 days

4.6

(35 reviews)

6.1

@labibhasan01718

Hello. I read your project description properly. Let's discuss. I need long term relationship with you. I can work 10 hours a day or more skills include: -Internet Research, web scraping, data entry, data mining, data processing, excel etc. I hope my skills and expertise will help you with your business and fine me as an appropriate candidate. Best regards, Labib

$30 USD in 3 days

4.9

(42 reviews)

4.8

@rifamorejo

HI mate! Greetings! I did masters in Statistics and now student of PhD in Middlesex University. Also have 5 years of experience as a professional freelancer. Good command over SPSS, STATA, AMOS, Smart PLS, EVIEWS, EXCEL. Did numerous projects like yours so don't worry you will be ended up with error free work. Available and willing to do this project as per your requirements. Can we have a chat dear? Thanks!

$50 USD in 1 day

5.0

(19 reviews)

4.8

@abdulkarim97

Dear Sir I saw your project now and I can do and I can give you quality work so if you chose me for your project then please message me. Thank You

$25 USD in 1 day

4.9

(21 reviews)

4.6

@jfami

Dear client, I am interested to help you in this assignment. Having more than 7 years of experience in Excel and accounting, I can help you in achieving your desired goals. Let's chat for complete understanding and work details. Thanks

$40 USD in 3 days

4.6

(4 reviews)

3.8

@HussainGillani02

I can help you to answer all above questions. I always deliver work accurately and efficiently.......

$60 USD in 2 days

5.0

(7 reviews)

2.9

@ReneRondon

Hello. I bid for this project because I'm an Chartered Accountant with lot of experience in MS Excel and finances. I guarantee you an accurate job, full functionality and fast delivery, all this in exchange of a fair rate that is perfectly adjusted to your budget.

$30 USD in 2 days

4.7

(17 reviews)

3.1

@OWINOKAMAU

Hello, am an experienced forecasting expert. I have done this job before at my work place and I believe am the best for the task

$25 USD in 1 day

4.5

(5 reviews)

2.9

@officedesk

Hi, I have worked in MS Excel and have done this type of project before. This is probably from operations management. I will provide quality of assignment and assure you will secure good grades.

$35 USD in 1 day

4.9

(2 reviews)

1.3

@jayantwaghale

A proposal has not yet been provided

$25 USD in 3 days

0.0

(0 reviews)

0.0

@maatallahmohsine

I'm good for it

$25 USD in 1 day

0.0

(0 reviews)

0.0

@uoscar

I am currently a PhD student in Ohio University in the US. I have excellent understanding of the various forecasting techniques: naive method, moving average, exponential-smoothing and trend analysis. I also posses excellent knowledge in the use microsoft excel in performing the various forecasting methods listed above. I promise to deliver a detailed and complete solution, and provide any further explanation you may require. If you send me a direct message, I would send you a sample of the excel solution to verify my claims before you make your decision for a freelancer.

$15 USD in 1 day

0.0

(0 reviews)

0.0

@IntelligenceUp

Hello! I'm ready to help you with calculations, will give comments on how to solve the problem (for each of 7 points). You'll get the result in clear and visible form. I'm experienced in Excel, market forecasts. Help students with their tasks in math, statistics, econometrics.

$25 USD in 2 days