The total number of absents students in the four (4) school terms for a matric class at a highschool over a 4-year period are recorded and tabulated as shown below.YearTermNumber of absents150201823816416720192401248112820209537420114920212133378455Calculate the first centered moving average for this time series data.A. 27.25В. 29.375С. 31.5D. 32

Find the Given details below: Given details: Year Term Number of Absents 2018 1 50 2 38 3…

Answered: The total number of absents students in…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Show the steps on excel to plot the graph and insert the equation on the graph
Attendance at Orlando's newest Disneylike attraction, Lego World, has been as follows: Quarter Guests (in thousands) Quarter Guests (in thousands) Winter Year 1 63 Summer Year 2 120 Spring Year 1 99 Fall Year 2 54 Summer Year 1 149 Winter Year 3 94 Fall Year 1 75 Spring Year 3 151 Winter Year 2 64 Summer Year 3 210 Spring Year 2 83 Fall Year 3 99 Part 2 Based on the given attendance, the seasonal indices for each of the seasons are (round your responses to three decimal places): Season Index Winter enter your response here
Develop a 3-week moving average for the following time series Time Time Series Period Value |1 13 2 12 3 17 |4 15 6 15 15 Find the value for MSE. If needed round your intermediate calculations to no more than 2 decimal places. Round your final answer to 2 decimal places
Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR THIS YEAR January 315 February 418 March 390 April 430 May 400 [ June 480 July 430 August 320 September 385 October 530 November 592 555 December 300 400 350 460 390 395 355 245 340 Develop a forecast for the fourth quarter using a three-quarter, weighted moving average. Weight the most recent quarter 0.50, the second most recent 0.25, and the third 0.25. Do the problem using quarters, as opposed to forecasting separate months. (Round your answer to 2 decimal places.) Forecast for the fourth quarter
Consider the following from an estate agent business: Month Houses Sold Jan 380 Feb 360 Mar 390 Apr 400 May 390 June 380 July 394 Aug 454 Sep 460 Oct 460 Nov 430 Dec 370 a) Calculate the three point moving averages (quarters) and seasonal variation for the above data b) A detective figures he has a one in nine chance of recovering stolen property. His out-of-pocket expenses for the investigation are $9,000. If he is paid his fee only if he recovers the stolen property, what should he charge clients in order to breakeven? c) At the races, your horse, has a probability of 1/20 of coming 151, 1/10 of coming 2nd and a probability of ¼ in coming 3rd. First place pays $4,500 to the winner, second place $3,500 and third place $1,500. Hence, is it worth entering the race if it costs $1,000? d) Your company plans to invest in a particular…
Restaurant Student Population Quarterly Sales 1 2 58 2 6 105 3 8 88 4 8 118 5 12 117 6 16 137 For the data above, what would be the predicted quarterly sales for a restaurant with a student population of 15 (using linear regression)?
The dean of a school of business is forecasting total student enrollment for this year's summer session classes based on the following historical data:Year 2,8002020 Enrollment2017 2,0002018 2,2002019 3,000What is this year's forecast using a three-year simple moving average? O a. 2333 1x Ob. 2500 Oc. 2400 O d. 2600 O e. 2667
Community Federal Bank in Dothan, Alabama, recently increased its fees to customers who use employees as tellers. Management is interested in whether its new fee policy has increased the number of customers now using its automatic teller machines to that point that more machines are required. The following table provides the number of automatic teller transactions by week. Use trend projection with regression to forecast usage for weeks 13-16. 11 2 12 10 8 3 4 9 5 Period Transactions 716 838 634 694 712 719 837 825 663 Obtain the trend projection with regression forecast (Enter your responses rounded to the nearest whole number) Forecast, F 1 714 Period D 13 14 15 16 6 740 7 782
Tom Simpson, Director of the Chamber of Commerce for Exeter township is investigating the past ten years of tourist visits to the area. The following data has been gathered on number of tourists who signed into the local information center. Year Number of tourists 1 700 2 248 3 633 4 458 5 1410 6 1588 7 1629 8 1301 9 1455 10 1989 What is the forecasts for Year 11 using the simple moving method? (show in calculations in excel file)
14 Community General Hospital finds itself treating many bicycle accident victims. Data from the last seven 24-hour periods is shown below: Day Bicycle Victims 1 8 2 14 3 8 4 14 5 18 6 15 With an alpha value of 0.31 and a starting forecast in day 3 equal to the 21 , what is the exponentially smoothed forecast for day 4? (Round to two decimal places) 15 What is the exponentially smoothed forecast for day 5? (Round to two decimal places)
Given is a historical time series for job services demand in the prior 6 months. Month 1 2 3 4 5 6 Demand 799 816 789 814 815 805 The Period 6 forecast by using weighted moving average with weights of 0.05, 0.25, 0.40, and 0.30 = Blank 1 (in 2 decimal places)
Suppose these data show the number of gallons of gasoline sold by a gasoline distributor in Bennington, Vermont, over the past 12 weeks. Sales (1,000s of gallons) Week 1 17 2 21 3 19 23 5 18 6 16 7 21 8 19 9 23 10 21 11 16 12 23 (a) Using a weight of - for the most recent observation, for the second most recent observation, and - for third most recent observation, compute a three-week weighted moving average for the time series. (Round your answers to two decimal places.) Time Series Value Weighted Moving Average Forecast Week 1. 17 2 21 19 4 23 5 18 6 16 7 21

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS