Aww

Thank you!

You're welcome!

Hey can you please tell me which course are you taking, where you study things like forecasting? is it data analytics? I ll be joining university soon and wanted to know.

@@smaranrai4898Hi, i'm studying Value Chain Management which includes everything from Marketing and Supply Chain to Forecasting, Inventory Management, Planning and many others.

@@iliankostadinov8209 Thankyou so much! Really appreciate it! :)

for this there are various formula you can use but let me help in answering your question first...the time series variables or observations , for example stock are the y1,y2,y3...yn , for this particular example, sold are the y1,y2,y3...yn..e.g the first observation is the y1 etc ....for levels you also use [(Y3 - Y1)/2] or [(Y2 - Y1) + (Y3 - Y2)/2] ... so to answer your question, let the first observation take the value y1, then use any formula. If I got your question right

I guess Im asking randomly but does anybody know of a way to log back into an Instagram account?? I stupidly lost my password. I would love any tips you can offer me.

hey sorry for bothering you after one year but I got the same question, do you mind sharing answer if you got one?

Bill, To download the data used by Leslie in this example: 1) visit this page at Redfin: www.redfin.com/news/data-center/ 2) scroll down to "Home Prices, Sales & Inventory" 3) select "All" for States 4) select the "Download" Tab 5) select the "Download" Icon at the bottom of the Table (right side of gray Tableau bar) 6) choose "Crosstab" from the list 7) choose "Excel" from the next list and click "Download" 8) download complete Good luck!

@@metropropertiesgroup4363 Home Prices, Sales & Inventory is not on that page

Found it - the new link is www.redfin.com/news/data-center/ then follow all the steps she mentions

However, the numbers don't match. Homes sold in her spreadsheet for January 2015 is 131646 but the file has 310785.

@@JimKernix I see the discrepancy. You can reduce the Home Sales number by filtering by Property Type to "Single Family Residential". However, this doesn't reduce the number to the example value though. My guess is Redfin has expanded their sales database and the downloaded table will still work, but the results will vary from the example. *I have counties around me that still are not tracked by Redfin and not part of their current sales database. FYI...I have used @Leslie Major layout and formulas on a private sales database and it performs the same as in the example. Speaking of that, you can filter the Redfin sales data to your specific area and use her layout for your specific market. Good luck!

Yes, you would have to use 52 periods instead of using 12 periods, since 52 weeks in a year vs 12 months in a year.. And instead of months match week with equivalent week of previous year. Split seasonality into weeks. It will become a lot more tedious though.

I think it's multiplicative one.

I think so

its pseudo additive

Yes if the trend is negative, the data is trending down. Sometimes the trend for a particular timestep doesn't reflect what the actual data is doing. That can happen particularly if there is lots of random fluctuations in the data

@@lesliemajor6676 oh, so does it go the same with the level and season?

@@lolbich9420 yes although the seasonal shouldn't be negative if the data is well suited for holt winters

@@lesliemajor6676 thanks, now i have understood, thank you so much for answering my question

@@lolbich9420 You're very welcome!

Will do! I'll post the file tomorrow:)

@@lesliemajor6676 where did you post the excel file please?