Find the moving average of the time series of quarterly production (in tons) of coffee in an Indian State as given below. After that, come...

Find the moving average of the time series of quarterly production (in tons) of coffee in an Indian State as given below. After that, come up with a trend line to approximate the production in future.
Production (in Tons)

So, T = 9.9673-0.1135 ? Quarter
number Notes:
Any number of years moving average can be used. Quarterly moving average has been chosen in this case.
Since it is not centred, centering is done as shown.
The trend can also be obtained from the time series as required here.
The summation for quarter numbers and the actual production are obtained. The additional values of
summation of x2 (quarter number squared) and summation of xy (production ? quarter number) are
obtained from the additional columns indicated.
The values of a and b of the trend line equation can then be obtained as
shown. Though not required;
It was possible to obtain deseasonalised data before obtaining the tend line. This means a better
forecasting equation is obtained (moving average and trend equation would have been used)
Seasonal factor S is obtained by averaging the error variation A/T for each quarter as per the second table.
Since the summation of the average is not equal to 4 (seasonal aspect) it has to be corrected by the factor
4/3.941.
The deseasonalised data is then obtained. Notice the way here a multiplicative model was chosen because
of the way the seasonal aspect keeps on changing.
Determination of S

---

raphael answered the question on January 11, 2019 at 04:50

Exams With Marking Schemes

• Grade 1
• Grade 2
• Grade 3
• Grade 4
• Grade 5
• Grade 6
• Grade 7
• Grade 8
• Grade 9
• PP1
• PP2
• Playgroup
• Form 1
• Form 2
• Form 3
• Form 4

Related Questions

• Briefly but clearly, explain the difference, if any, between regression analysis and correlation analysis. (Solved)
  

  Briefly but clearly, explain the difference, if any, between regression analysis and correlation analysis.

  Date posted: January 10, 2019 .    Answers (1)

• Kenya Graduate School (KGS) offers a variety of graduate courses. However, its main emphasis has been on information science (IS) courses. Due to the laboratory equipment... (Solved)
  

  Kenya Graduate School (KGS) offers a variety of graduate courses. However, its main emphasis has been on
  information science (IS) courses. Due to the laboratory equipment requirements for IS courses, KGS has to
  estimate in advance the expected students enrolments. Over the last 5 years, the students enrolments, by
  quarter, has been:
  
  Required:
  a) Determine the estimates, by quarter, for year 1996. Justify the method you use.
  b) If linear multiple regression were to be used in order to determine the predicting equation, what other
  variables would be included?
  c) How would the expected enrolments be compared to the actual enrolments?
  

  Date posted: January 10, 2019 .    Answers (1)

• In recent years environmentalists and health professionals have been concerned about the ill effects onthe environment of the widespread use of insecticides. If human beings... (Solved)
  

  In recent years environmentalists and health professionals have been concerned about the ill effects on
  the environment of the widespread use of insecticides. If human beings are to cope with the problem
  and make decisions about how to deal with it, they must understand the effect of insecticides on humans
  and other animals. In the kind of study often done to promote such understanding, two professors at
  University of Nairobi investigated the effect of a commonly used insecticide on sheep. Among other
  statistical analyses, they derived the following linear regression equation (n = 16):
  
  This equation describes the relationship between the activity of a certain enzyme in the
  sheep's brain (Y)and the time (in hours) after the sheep has been exposed to the insecticide (X).
  Required:
  i) Suppose 30 hours have elapsed since a sheep has been exposed to the insecticide, what is the
  predicted value of Y?
  ii) How would you describe the relationship between the two variables?
  iii) The professors computed a coefficient of determination (r²) of 0.86 from the data. What
  conclusion can be drawn about the true relationship between the two variables?
  iv) What assumption are necessary to solve part (iii) above?

  Date posted: January 1, 2019 .    Answers (1)

• Does a high correlation mean that one variable causes another variable to vary? (Solved)
  

  Does a high correlation mean that one variable causes another variable to vary?

  Date posted: January 1, 2019 .    Answers (1)

• Does finding a no linear relationship between two variables mean no relationship? (Solved)
  

  Does finding a no linear relationship between two variables mean no relationship?

  Date posted: January 1, 2019 .    Answers (1)

• The following regression equation was calculated for class of 24 CPA II students. Required: a) Calculate the t ratio and the 95% confidence interval for each regression... (Solved)
  

  The following regression equation was calculated for class of 24 CPA II students.
  
  Standard error (0.0190) (0.034) (0.018)
  Where y=students score on a theory examination
  x1 = Students rank (from the bottom) in high
  school x2 = Students verbal aptitude score
  x3 =A measure of students character
  Required:
  a) Calculate the t ratio and the 95% confidence interval for each regression coefficient.
  b) What assumptions did you make in (a) above? How reasonable are they?
  c) Which regressor gives the strongest evidence of being statistically discernible?
  d) In writing up a final regression equation, should one keep the first regressor in the equation, or drop if?
  Why?

  Date posted: January 1, 2019 .    Answers (1)

• The following data have been collected relating to returns which would have been earned from an investment of an equal sum of money in the shares... (Solved)
  

  The following data have been collected relating to returns which would have been earned from an investment
  of an equal sum of money in the shares of E.T. plc and a group of market shares:
  
  
  You are required to:
  a) Plot the original data on a graph, calculate the least squares regression of y on x and draw the regression
  line on the graph;
  b) Test the significance of the slope of the line at the 5% level;
  c) Discuss the outcomes of (a) and (b) in the context of a comparison of the two investments

  Date posted: December 14, 2018 .    Answers (1)

• Unlisted plc hopes to achieve a Stock Market quotation for its shares. A profit forecast is necessary and, in order to achieve such a forecast,... (Solved)
  

  Unlisted plc hopes to achieve a Stock Market quotation for its shares. A profit forecast is necessary and, in order to achieve such a forecast, the company has experimented with a number of approaches. The following are details from a linear regression on the last 11 years profit figures:
  x = years (expressed 1 to 11)
  y = annual profit figures
  
  You are required:
  a) To obtain the simple least squares regression line of Y on X;
  b) To use the line to estimate profit in each of the next two years;
  c) To calculate the coefficient of determination for the line and to explain its meaning;
  d) To calculate the standard error of the regression line and to use this to obtain the 95% confidence
  interval for the line;
  e) On the basis of the information given on your answer (a) to (d) to determine whether it is likely that the regression line will be a good estimator of profit.

  Date posted: December 14, 2018 .    Answers (1)

• Because of economic conditions, a firm reports that 30 per cent of its accounts receivable from other business firms are overdue. The firm's policy is that... (Solved)
  

  Because of economic conditions, a firm reports that 30 per cent of its accounts receivable from other
  business firms are overdue. The firm's policy is that if an accountant takes a random sample of five such accounts and finds that exactly 20 per cent of the accounts are overdue 10 per cent of the time, then a warning letter should be written to the particular firm.
  Required:
  Should the warning letter be written?

  Date posted: December 14, 2018 .    Answers (1)

• Mia Shillings Department Stores has compiled the following data concerning its daily sales. The sales of each day of the week are normally distributed with the... (Solved)
  

  Mia Shillings Department Stores has compiled the following data concerning its daily sales. The sales of
  each day of the week are normally distributed with the following parameters.
  
  Required:
  Which day of the week has the lowest probability that the store will sell between Sh.110,000 and
  Sh.150,000 worth of goods?

  Date posted: December 14, 2018 .    Answers (1)

• What do confidence limits measure? (Solved)
  

  What do confidence limits measure?

  Date posted: December 14, 2018 .    Answers (1)

• Under what conditions can the normal distribution be used as an approximation to the binomial distribution? (Solved)
  

  Under what conditions can the normal distribution be used as an approximation to the binomial distribution?

  Date posted: December 14, 2018 .    Answers (1)

• Give some examples of the type of data that form a normal distribution (Solved)
  

  Give some examples of the type of data that form a normal distribution.

  Date posted: December 14, 2018 .    Answers (1)

• A manager is convinced that a new type of machine does not affect production at the company's major shop floor. In order to test this, 12... (Solved)
  

  A manager is convinced that a new type of machine does not affect production at the
  company's major shop floor. In order to test this, 12 samples of this week's hourly output is
  taken and the average production per hour is measured as 1158 with a standard deviation of 71. The
  output per hour averaged 1196 before the machine was introduced.
  Required:
  Test the manager's conviction

  Date posted: December 14, 2018 .    Answers (1)

• Prior to an advertising campaign, 35 per cent of a sample of 400 housewives used a certain product. After the campaign, 40 per cent of a... (Solved)
  

  Prior to an advertising campaign, 35 per cent of a sample of 400 housewives used a certain product.
  After the campaign, 40 per cent of a second sample of 400 housewives used the same product.
  Required:
  Did the campaign increase sales?

  Date posted: December 14, 2018 .    Answers (1)

• Two researchers in marketing, Catherine Mbugua and George Otieno, reviewed the theory of product life cycle with respect to a specific product. They conducted a research... (Solved)
  

  Two researchers in marketing, Catherine Mbugua and George Otieno, reviewed the theory of product
  life cycle with respect to a specific product. They conducted a research project to determine the
  applicability of the theory to popular music records. As part of the study, they collected extensive
  information on a sample of 12 music records judged on the basis of certain well-defined criteria to be successes and a sample of 10 music records to be failures. They collected data on each music record for
  a period of 16 weeks from the date the record was released to the market. One item of information they
  collected on each music record was radio airplay. Measurement of this variable yielded the following
  means and standard deviations for the two samples of music records.
  
  
  ii) What assumptions are we making in order to use the pooled estimate of the common population
  variance?

  Date posted: December 14, 2018 .    Answers (1)

• If a Type II error is costly but a Type I error is not, why should you set the level of significance $\alpha$ at 0.10,... (Solved)
  

  If a Type II error is costly but a Type I error is not, why should you set the level of significance $\alpha$ at 0.10, 0.20 or even higher?

  Date posted: December 14, 2018 .    Answers (1)

• What is wrong with the following hypotheses? (Solved)
  

  What is wrong with the following hypotheses?
  

  Date posted: December 14, 2018 .    Answers (1)

• What is a one-sided confidence interval? When is it necessary? (Solved)
  

  What is a one-sided confidence interval? When is it necessary?

  Date posted: December 14, 2018 .    Answers (1)

• The General Manager of a large hotel in Bombay wishes to know whether or not the personal services provided to its customers are uniform throughout the... (Solved)
  

  The General Manager of a large hotel in Bombay wishes to know whether or not the personal services
  provided to its customers are uniform throughout the hotel industry. Whether the clients in the less
  expensive rooms get the same service as that of clients of more expensive rooms. The data collected from the comment cards is tabulated below:
  
  Were the customers treated differently according to their room charges? Test the hypothesis at 0.05 level of significance.

  Date posted: December 14, 2018 .    Answers (1)