N2 please help me i will give good ratingb) The following table shows the number of people who are infected with Disease Z at District B inthe year 2018 to the year 2021.YearNumber of people infectedQ1Q2Q3Q4201888201915010839825420204945687945442021421498(i) Compute the moving average trend.(i) Calculate the average seasonal variationsusing the multiplicative model.(ii1) Forecast the number of people infected inQuarter 4 of year 2021.

Answered: please help me i will give good rating…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section13.4: Multiple Regression Models

Problem 17P: The owner of a restaurant in Bloomington, Indiana, has recorded sales data for the past 19 years. He...

See similar textbooks

Similar questions

Under what conditions might a firm use multiple forecasting methods?
The owner of a restaurant in Bloomington, Indiana, has recorded sales data for the past 19 years. He has also recorded data on potentially relevant variables. The data are listed in the file P13_17.xlsx. a. Estimate a simple regression equation involving annual sales (the dependent variable) and the size of the population residing within 10 miles of the restaurant (the explanatory variable). Interpret R-square for this regression. b. Add another explanatory variableannual advertising expendituresto the regression equation in part a. Estimate and interpret this expanded equation. How does the R-square value for this multiple regression equation compare to that of the simple regression equation estimated in part a? Explain any difference between the two R-square values. How can you use the adjusted R-squares for a comparison of the two equations? c. Add one more explanatory variable to the multiple regression equation estimated in part b. In particular, estimate and interpret the coefficients of a multiple regression equation that includes the previous years advertising expenditure. How does the inclusion of this third explanatory variable affect the R-square, compared to the corresponding values for the equation of part b? Explain any changes in this value. What does the adjusted R-square for the new equation tell you?
The following gives the number of accidents that occurred on Florida State Highway 101 during the last 4 months: Jan Feb Mar AprMonth 1 2 3 4Number of Accidents 25 40 60 105 Using the least-squares regression method, the trend equation for forecasting is (round your responses to two decimal places): y = ? + ?x
H The following gives the number of accidents that occurred on Florida State Highway 101 during the last 4 months: Month Jan Number of Accidents 25 Feb 48 Mar Apr 64 100 Using the least-squares regression method, the trend equation for forecasting is (round your responses to two decimal places): ŷ=+x
Consider the following quarterly demand level for electricity (in 1000 megawatts) in Mankweng from 2018 to 2022: 2018 2019 2020 2021 2022 Jan – March 21 35 49 60 10 - Apr – June 42 54 55 64 05 July – Sept Oct – Dec 60 91 95 99 12 14 74 80 1. Find the least squares trend line for electricity demand using Exx=0 method. 2. Find the seasonal index for each quarter. 3. Find adjusted seasonal index. 4. Find the De-seasonalized values for Quarter 1, 2,3 and 4 for the year 2023.
The following gives the number of accidents that occured on Florida State Highway 101 during the last 4 months: Month Jan Feb Mar Apr Number of accidents 25 48 60 105 Using the least-squares regression method, the trend equation for forecasting is (round your responses to two decimal places): ^ y [___] +[___] x
The following gives the number of accidents that occurred on Florida State Highway 101 during the last 4 months: Month Number of Accidents Jan 30 Feb 48 Mar 60 Apr 90 Using the least-squares regression method, the trend equation for forecasting is (round your responses to two decimal places): ŷ = 0+0x 20
The following gives the number of accidents that occurred on Florida State Highway 101 during the last 4 months: Month Jan Number of Accidents 25 Feb 48 Mar 64 Apr 100 Using the least-squares regression method, the trend equation for forecasting is (round your responses to two decimal places): y = -1 + 24.10 x Using least-squares regression, the forecast for the number of accidents that will occur in the month of May response as a whole number). = accidents (enter your
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
1. The number of bushels of apples sold at a roadside fruit stand over a 12-day period were PROBLEMS as follows: Day Numbar Sold Day Number Sold 25 35 31 29 33 32 38 10 40 37 32 34 11 37 12 If a two-period moving average has been used to forecast sales, what were the daily forecasts starting with the forecast for day 3? If a four-period moving average has been used, what were the forecasts for eacn uay starting with day 5? Plot the original data and each set of forecasts on the same graph. Which forecast has the greater tendency to smooth? Which forecast has the better ability to respond quickly to changes? What does use of the term sales instead of demand imply? b. C. 2. If exponential smoothing with a = .4 had been used to forecast daily sales for apples in Problem 1, determine what the daily forecasts would have been. Then, plot the original data, the exponential forecasts, and a set of naive forecasts on the same graph. Based on a visual comparison, is the naive more accurate or…
The following gives the number of accidents that occurred on Florida State Highway 101 during the last 4 months: Month Jan Feb Mar Apr Number of Accidents 30 48 70 90 Part 2 Using the least-squares regression LOADING... method, the trend equation for forecasting is (round your responses to two decimal places): y = enter your response here + enter your response here x Y=?+?x
28. Shoreline Park in Mountain View, California, has kept close tabs on the number of patrons using the park since its opening in January 1993. For the first six months of 2013, the following figures were recorded: Month Number of Patrons Month Number of Patrons April May June 640 January February March 133 183 1,876 2,550 285 a. Draw a graph of these six data points. Assume that January February fit of the data. Estimate the slope and intercept from your graph. period 1, period 2, and so on. Using a ruler, “eyeball" the best straight-line +

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Marketing

ISBN:

9780357033791

Author:

Pride, William M

Publisher:

South Western Educational Publishing

Contemporary Marketing

Marketing

ISBN:

9780357033777

Author:

Louis E. Boone, David L. Kurtz

Publisher:

Cengage Learning

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Marketing

ISBN:

9780357033791

Author:

Pride, William M

Publisher:

South Western Educational Publishing

Contemporary Marketing

Marketing

ISBN:

9780357033777

Author:

Louis E. Boone, David L. Kurtz

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS