The following table shows the monthly sales of a product for a 2-year period.Year Jan Feb. Mar. Apr.July Aug. Sept Oct.73МayJuneNov.Dec.173657070766875706670782716768727470737568736880a) Forecast sales for year 2 (January thru December) using moving average with trend model (even thoughwe already know actual sales). Use year 1 data as needed for 3-month and 5-month moving averagesb) Compare the two forecasts. Which one do you prefer?c) Forecast monthly sales for year 3 by using the selected forecast.

a) Forecast sales for year 2 by using 3-month moving average: From the given information, Excel…

Answered: The following table shows the monthly…

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018

18th Edition

ISBN:9780079039897

Author:Carter

Publisher:Carter

Chapter4: Equations Of Linear Functions

Section4.5: Correlation And Causation

Problem 2AGP

See similar textbooks

Similar questions

Calculate trend values by the method of least square from the data given below and estimate the sales for 1983 : Year 1976 1977 1978 1979 1980 : Sales of Co. ('000,000) : 70 74 80 86 90
Compute 3-yearly moving averages of the following data assuming the length Of business cycle as 3 year period and plot the trend va year Annual sales in $ '000 1990 40 1991 42 1590 46 1993 44 1994 49 1995 46 1996 42 1997 44 1998 50
What the three trend lines and seasonal variation information shown in Chart and Table1 indicate about historic sales of smart running shoes in Europe and how thisinformation could be used to determine a forecast of sales volumes for our new rangefor the for first 2 quarters of 2022.
At the end of Year 5, your consulting firm has been hired by a local service firm to help forecast future uncollectible accounts. You ask the service firm to provide several years of data on the percentage of uncollectible accounts based on the age categories of accounts receivable at the beginning of the year. With these historical percentages, you estimate a trend line (dashed line) to predict the percentage of uncollectible accounts for Year 6, the upcoming year. Graphs were provided to management from your analysis of each of the three age categories, as well as balances of accounts receivable by age category at the end of Year 5 as follows: Percentage of Uncollectible Accounts: 1-30 Days Past Due 8% 6% 4% 2% 0% 4% Year 1 Not Yet Past Due 2 3% 3 5% 5 6% 6 $140,000 $120,000 $100,000 $80,000 $60,000 $40,000 $20,000 8 $0 18% 16% 14% 12% 10% 16% 14% Year 1 2 3 $128,000 14% Not Yet Past Due Accounts Receivable by Age: End of Year 5 $84,000 15% 1-30 Days Past Due 6 46% 44% 42% 40% 38%…
For a period of 11 years, the figures in the accompanying table were found for annual change in unemployment rate and annual change in mean employee absence rate due to own illness. Year Change in UnemploymentRate Change in Mean Employee Absence Rate Due to Own Illness (Y) 1 -0.2 0.2 2 -0.1 0.2 3 1.4 0.2 4 1.0 -0.4 5 -0.3 -0.1 6 -0.7 0.2 7 0.7 -0.1 8 2.9 -0.8 9 -0.8 0.2 10 -0.7 0.2 11 -1.0 0.2 a. Estimate the linear regression of change in mean employee absence rate due to own illness on change in unemployment rate. b. Interpret the estimated slope of the regression line. thanks.
Twins Twins are often born after a pregnancy that lastsless than 9 months. On the next page is a graph from theJournal of the American Medical Association (JAMA)showing the rate of preterm twin births in the United States over the past 20 years. In this study, JAMA catego-rized mothers by the level of prenatal medical care they received: inadequate, adequate, or intensive.a) Describe the overall trend in preterm twin births. b) Describe any differences you see in this trend, depend-ing on the level of prenatal medical care the mother received.c) Should expectant mothers be advised to cut back onthe level of medical care they seek in the hope ofavoiding preterm births? Explain.a) Create a linear model and predict the number ofgallons that will be available in 2005.b) The exam then asked students to estimate the yearwhen leaded gasoline will first become unavailable,expecting them to use the model from part a to answerthe question. Explain why that method is incorrect.c) Create a model…
b) The following are the quarterly index numbers of whole sale prices: Year 1928 1929 1930 1931 1932 1933 1934 Values 125 112 136 142 118 120 122 Fit a linear trend to these data and find trend values(Y). Take the deviations of the observed values(Y) and verify that E(Y-Y^)=0.
Find out the next month after april income by using the forecasting method of the moving average method
Below are given the annual production (in '000 Rs.) of a fertiliser factory : 1998 Year : 1992 1993 1994 1995 1996 1997 Prodn. : 70 75 90 91 85 98 100 (i) Fit a straight line trend by the method of least square and tabulate the trend values.
If an asset declines in value from $5000 to $3500 over nine years, what is the mean annual growth rate in the asset's value over these nine years?
A company estimates its sales for a particular year to be Rs. 24,00,000. The seasonal indices for sales are as follows: Seasonal Index 75 Month Seasonal Index Month July August September October 102 104 January February March 80 100 98 128 137 102 April May June November 82 119 December 73 Using this information, calculate estimates of monthly sales of the company, Assume that there is no trend). (Delhi Univ., B. Com., Hons., 1979
Suppose the rate of return for a particular stock during the past two years was 10% and - 45%. Compute the geometric mean rate of return. The geometric mean rate of return is %. (Round to one decimal place as needed.)

SEE MORE QUESTIONS

Recommended textbooks for you

Glencoe Algebra 1, Student Edition, 9780079039897…

Algebra

ISBN:

9780079039897

Author:

Carter

Publisher:

McGraw Hill

Calculus For The Life Sciences

Calculus

ISBN:

9780321964038

Author:

GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.

Publisher:

Pearson Addison Wesley,

Glencoe Algebra 1, Student Edition, 9780079039897…

Algebra

ISBN:

9780079039897

Author:

Carter

Publisher:

McGraw Hill

Calculus For The Life Sciences

Calculus

ISBN:

9780321964038

Author:

GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.

Publisher:

Pearson Addison Wesley,

SEE MORE TEXTBOOKS

The following table shows the monthly sales of a product for a 2-year period. Year Jan | Feb. | Mar. | Apr. | May | June July 75 | Aug. Sept | Oct. | Nov. Dec. 1 73 65 70 70 76 68 73 70 66 70 78 71 67 68 72 74 70 73 75 68 73 68 80