Excel help on Forecast

$10-30 USD

Ditutup

Dibuat

lebih dari 6 tahun yang lalu

$10-30 USD

Dibayar ketika dikirim

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 Proyek: 16038851

Tentang proyek

29 proposal

Proyek remot

Aktif 6 tahun yang lalu

Ingin menghasilkan uang?

Alamat email

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda

Dapatkan bayaran atas pekerjaan Anda

Uraikan proposal Anda

Gratis mendaftar dan menawar pekerjaan

29 freelancer menawar dengan rata-rata $40 USD untuk pekerjaan ini

@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 dalam 1 hari

4,7

(152 ulasan)

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 dalam 1 hari

4,8

(123 ulasan)

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 dalam 7 hari

4,7

(38 ulasan)

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 dalam 1 hari

5,0

(27 ulasan)

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 dalam 1 hari

4,9

(23 ulasan)

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 dalam 3 hari

4,9

(42 ulasan)

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 dalam 1 hari

4,9

(24 ulasan)

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 dalam 3 hari

4,6

(4 ulasan)

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 dalam 2 hari

4,8

(27 ulasan)

3,5

@HussainGillani02

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

$60 USD dalam 2 hari

5,0

(7 ulasan)

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 dalam 1 hari

4,9

(2 ulasan)

1,3

@jayantwaghale

A proposal has not yet been provided

$25 USD dalam 3 hari

0,0

(0 ulasan)

0,0

@maatallahmohsine

I'm good for it

$25 USD dalam 1 hari

0,0

(0 ulasan)

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 dalam 1 hari