Excel help on Forecast

$10-30 USD

Cerrado

Publicado

hace más de 6 años

$10-30 USD

Pagado a la entrega

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?

ID del proyecto: 16038851

Información sobre el proyecto

29 propuestas

Proyecto remoto

Activo hace 6 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

29 freelancers están ofertando un promedio de $40 USD por este trabajo

@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 en 1 día

4,7

(152 comentarios)

7,2

@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 en 1 día

4,8

(123 comentarios)

6,6

@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 en 7 días

4,7

(38 comentarios)

6,3

@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 en 1 día

5,0

(27 comentarios)

5,2

@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 en 1 día

4,9

(23 comentarios)

4,7

@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 en 3 días

4,9

(42 comentarios)

4,8

@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 en 1 día

4,9

(24 comentarios)

4,5

@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 en 3 días

4,6

(4 comentarios)

3,7

@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 en 2 días

4,8

(27 comentarios)

3,5

@HussainGillani02

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

$60 USD en 2 días

5,0

(7 comentarios)

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 en 1 día

4,9

(2 comentarios)

1,3

@jayantwaghale

A proposal has not yet been provided

$25 USD en 3 días

0,0

(0 comentarios)

0,0

@maatallahmohsine

I'm good for it

$25 USD en 1 día

0,0

(0 comentarios)

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 en 1 día