Question: please do on excel and show all formulas used with as much help for excel as possible , please and thank you so much 12.19.

please do on excel and show all formulas used with as much help for excel as possible , please and thank you so much
please do on excel and show all formulas used
please do on excel and show all formulas used
please do on excel and show all formulas used
12.19. A group of business students at Tech organized a student club called Prism to develop and disseminate content about business majors through a website they created. They would like the college and various academic departments to use their club website to provide information about, and promote their majors, and to post possible job opportunities from potential employers. In order to convince the college administration and department heads to use their site, they want to develop a forecast of future website visits. Following is the number of weekly visits the club's website has received for the past 24 weeks while it has been in existence: Week Website Visits 1 537 2 375 3 419 276 4 5 6 445 7 8 512 670 561 GO 9 705 10 619 11 768 12 13 14 15 16 645 822 677 1031 657 983 774 17 18 19 1210 20 811 21 22 1137 763 1225 941 23 24 542 Develop a linear trend line forecast, an exponential smoothing forecast (a = .60), and a three-month weighted moving average (with the most recent month weighted by 50, the next closest month by 30, and the final month by 20). Indicate which one seems to be the most accurate forecast model and the forecast for week 25

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!