Please show me how to do this problem step by step in Excel! \' Problem A: Seaso

Question

Please show me how to do this problem step by step in Excel! '

Problem A: Seasonal Index Method Monthly Data for Beach Condo Rentals is provided in the data set. You will be predicting the next year's rentals using the past four years of data with the seasonal index (Seasonal Decomposition method). 1. Start by making your data into a table (learned in Simnet Lesson 4) 2. Use Table Functions to get the average at the bottom of each year 3. Make a separate table for Seasonal Indices and find the average seasonal index for each month. This is very easy if you are in table format!

Explanation / Answer

after entering data into excel sheet

at B16 cell place =AVERAGE(B4:B15) it finds the average of year1

you can place same formula at eavery row like  =AVERAGE(C4:C15)

if you need monthly average you can use same average forumula at F4 i.e  =AVERAGE(B4:E4)

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.