Question: Problem 2 (8 marks) Fill in the blanks in the following table. Use those calculations to answer the three questions that follow beneath the table.

Problem 2 (8 marks) Fill in the blanks in the

Problem 2 (8 marks) Fill in the blanks in the following table. Use those calculations to answer the three questions that follow beneath the table. (Hint: see pages 81 to 83 in your textbook for guidance.) Students are encouraged to use Excel. Create a new blank sheet in the Excel workbook that you used for Problem 1 (above). Create a table that is a replica of the one presented below. Fill in the empty cells. And answer the 4 questions beneath the table. If a student is unable to use Excel for whatever reason, you may solve the problem manually by filling in these tables and labelling the columns and rows appropriately and neatly Week Forecast Actual Sales Error Absolute Error Percent Error Squared Error 1 130 180 272 2 280 350 3 384 4 420 456 5 210 480 Totals What is the Bias? What is the MAD? What is the Ave. Percent Error? What is the Standard Deviation

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!