Sales of Orange computer have grown steadily during the past 5 years: Year Sales 1 450 2 295 3 518 4 563 5 584 6 ? My sales manager had predicted, before the business started, that year 1’s sales would be 410 computers. What are required: Develop forecasts for years 2 through 6 by using exponential smoothing with a weight of alpha = 0.30 Develop forecasts for the sales of Orange computers by using smoothing constants of 0.6 and 0.9 Help me to propose the most accurate forecast in smoothing constant, based on forecast at no.2 above. Help me to critically evaluate the effect that the smoothing constant have on the forecast for Orange computers.

Sales of Orange computer have grown steadily during the past 5 years: Year Sales 1 450 2 295 3 518 4 563 5 584 6 ? My sales manager had predicted, before the business started, that year 1’s sales would be 410 computers. What are required: Develop forecasts for years 2 through 6 by using exponential smoothing with a weight of alpha = 0.30 Develop forecasts for the sales of Orange computers by using smoothing constants of 0.6 and 0.9 Help me to propose the most accurate forecast in smoothing constant, based on forecast at no.2 above. Help me to critically evaluate the effect that the smoothing constant have on the forecast for Orange computers.

A First Course in Probability (10th Edition)

10th Edition

ISBN:9780134753119

Author:Sheldon Ross

Publisher:Sheldon Ross

Chapter1: Combinatorial Analysis

Section: Chapter Questions

Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...

See similar textbooks

Similar questions

answer 6
Which of the following is/are TRUE about binomial probability distribution? I The experience consists of n repeated trials. II. There are many possible outcomes. III. The repeated trials are dependent. IV. The probability of success is constant. a. II Only b. IV only c. II and III d. I and IV
Eloise needs to finish a 516-page report on international trade so she can present it at the big conference this weekend. She's been tracking her page count at the end of each business day to see if she's on track. Use Excel to fit a trendline to Eloise's data to create a model of her productivity. According to your model, will Eloise be able to finish her report by the end of the day next Friday? Assume she works only on weekdays. Day Pages Monday 425 Tuesday 431 Wednesday 449 Thursday 464 Friday 471 A: Use Excel to fit a trendline to Eloise's data. What are the slope and intercept for this line? The slope is The intercept is B: Use your model (trendline) to answer the question. Will Eloise finish her report by the end of next friday? Yes
Table 3 gives the market value of a luxury sedan (in dollars) xyears after its purchase. Find an exponential regression model of the form y= ab* for this data set. Estimate the purchase price of the sedan. Estimate the value of the sedan 10 years after its purchase. Round answers to the nearest dollar. TABLE 3 Value ($) 1 23,125 19,050 3 15,625 11,875 5 9,450 6 7,125 2.
The following table gives the regression results of consumption behaviour between female and male. Consumption (C), in RM Model 1 Model 2 Constant 0.7515 0.6587 (0.024) (0.037) Y 0.8603 0.5442 (0.0301) (0.2881) Gen 0.2001 (0.0004) Y*Gen 0.3105 (0.0076) Adjusted R 0.78 0.78 No. of Observations 47 47 Note: Y=income (RM) Gen= Gender ( It is equal to 1 if person is female; 0 is for male) Figures in the parentheses are p- values a) Identify which are the qualitative, quantitative and interaction variable. Refer to Model 1: b) Write the regression equations for female and male. Draw the regression lines for female and male on the same diagram. What can you c) say? d) Interpret all the estimated slope coefficients. e) Conduct an appropriate test to determine whether variable gender is statistically significant at 5%. Should this variable be dropped from this regression model.
3. A study of beer consumption using the annual data from 1980 -2001 produced the following regression: Y = 0.41 +0.052.X₁; −0.047X2; +0.032X3; −0.018X4i (0.027) (0.011) (0.009) (0.008) (0.009) R² = 0.94 F = 66.58 DW statistic=1.32, figures in the brackets are standard errors Where: Y₁ = Annual aggregate beer consumption in year t (billion pints) X₁₁ = Real disposable income income in year t ($ billions at 2001 prices) X2i = Price of beer in year t (index number with 2001 = 100) X31 Price of wine and sprits in year t (index number with 2001 = 100) = X4₁ = Price of cigarettes in year t (index number 2001 = 100) (a) What is the effect of a change in the price of beer on beer consumption? Does it have the correct sign? Explain. (b) Comment on the signs of the other three coefficients. Are they as expected? (c) Tests the significance of the coefficients on each of the variables Xit i = 1, 2, 3, 4. What assumptions have you made in carrying out these tests? (d) What conclusion do you draw…
An analyst must decide between two different forecasting techniques for weekly sales of roller blades: a linear trend equation and the naive approach. The linear trend equation is F+ = 122 +1.9t, and it was developed using data from periods 1 through 10. Based on data for periods 11 through 20 as shown in the table, which of these two methods has the greater accuracy if MAD and MSE are used? (Round your intermediate calculations and final answers to 2 decimal places.) t 11 12 13 14 15 16 17 18 19 20 Units Sold 143 149 152 145 155 152 154 159 159 162 Click here for the Excel Data File MAD (Naive) MAD (Linear) MSE (Naive) MSE (Linear))
3. Suppose that the following import function for Turkey is estimated for Turkey between 1980-2015. Import, a, + a,GDP; + ażER¸ + ut In order to measure the impact of 2001 crisis the regression is estimated based on the whole and two subsamples and the following RSS are obtained. Time period: 1980-2000 , RSS1= 69 Time period: 2001-2015, RSS2 =35 Time period: 1980-2015 , RSS = 160 Carry out the Chow test whether the regressions for the two periods are different at 5% significance level. (35 P)
lakhs) of a certain commodity for the year On the basis of quarterly sales (in 2008-12, the following calculations were made : Trend: Y = 20 + 0.5 t with origin at 1st quarter of 2008. where 1 = time unit = one quarter and y = quarterly sales ( Seasonal variations: Quarter I II III IV Seasonal Index 80 90 120 110 Estimate the quarterly sale for the year 1979 using multiplicative model.
Consider the following estimated regression model relating annual salary to years of education and work experience. Estimated Salary = 10,160.10 +3147.75(Education) + 1230.34(Experience) Suppose an employee with 8 years of education has been with the company for 20 years (note that education years are the number of years after 8th grade). According to this model, what is his estimated annual salary? Answer Tables Keypad Keyboard Shortcuts
An economist at Nedbank ran a study of the relationship between FTSE/JSE All Shares index return (JALSH) and consumer price index (CPI) from 2006 to 2017, the data collected is shown in the Table 1 below. FTSE/JSE All Shares index return (JALSH) and consumer price index (CPI) from 2006 to 2017. Year JALSH (Y) CPI (X) 2006 0.41 4.7 2007 0.19 7.1 2008 -0.23 11.5 2009 0.32 7.1 2010 0.19 4.3 2011 0.03 5.0 2012 0.27 5.6 2013 0.21 5.7 2014 0.11 6.1 2015 0.05 4.6 2016 0.00 6.4 2017 0.21 5.3 The estimated regression…