Amex PLC has gathered following information on the sales of face mask from April 2020 to September 2020. Month Sales ($) April l 17,000 18,000 19,500 22,000 May June July August 21,000 September 23,000 You are required to; a. Using linear trend equation forecast the sales of face masks for October 2020. b. Calculate the forecasted sales difference if you use 3-period weighted moving average designed with the following weights: July 0.2, August 0.3 and September 0.5.
Q: 7. Freight car loadings over a 12-year period at a busy port are as follows: Week Number Week Number…
A: Given data: Sample size n = 18 Week is independent variable. Number is dependent variable. Formula…
Q: 1. Age of person (in years) Weight (in kg) a. 15 16 17 11 12 13 14 42 40 38 35 45 51 48 b. Trend…
A: Steps of create scatter Plot; 1. Enter the data in excel then, go to insert --- scatter plot ----…
Q: Find average of quarterly trend values for the given years from the data given below: Year Quarters…
A:
Q: mex PLC has gathered following information on the sales of face mask from April 2020 to September…
A: a).The equation of trend line is given as- μt=a+bt Let us assign the month April, May, June, July,…
Q: A pharmacist has been monitoring sales of a certain over-the-counter pain reliever. Daily sales…
A: (a). Demand Forecast values for the days 9 through 16 using trend-adjusted exponential smoothing:…
Q: Example 5. Calculate 5-yearly and 7-yearly moving average of the data given below to obtain trend…
A:
Q: Example 2: Construct a 4-yearly centered moving average from the following dat. 1992 Year 1991 1993…
A:
Q: Community Federal Bank in Dothan, Alabama, recently increased its fees to customers who use…
A: The given table shows the number of automatic teller transactions by week.
Q: Sales for last 10 weeks are shown in the table below. Plot the data and visually check to see…
A: Given data is :
Q: 1. Age of person (in years) Weight (in kg) aj 16 17 11 12 13 14 15 40 42 38 35 45 51 48 b. Trend…
A: Scatterplot is used to represent the two numerical variable. It helps to determine the association…
Q: A manager uses a trend equation plus quarterly relatives to predict demand. Quarter relatives are…
A: Given information: The data represents the values of demand for the periods 1 to 9.
Q: From the following data fit a trend line and determine the trend values b the method of semi…
A:
Q: Find the average of quarterly trend values for the given years from the data given below: Year…
A: introduction Form the data give in the table we have to find the average of quarterly trend…
Q: Amex PLC has gathered following information on the sales of face mask from April 2020 toSeptember…
A: Let the April be denoted by 1, May by 2 and so on. Then, the given data: Month, x Sales, ut 1…
Q: Determine the equation of the trend line for the data shown below on Canadian balance of payments…
A:
Q: The median home value in Maine and New Hampshire (adjusted for inflation) are shown below. Maine New…
A: a) % increase in Maine=Increase in home valueInitial home value×100=98700-2940029400×100=235.71% %…
Q: * For the following table: () Fit a straight line trend by the method of least squares. (ii)…
A:
Q: 100% 89.6% 90% 84.1% Seat belt use rate 80% 70% 60% 50% 43.6% 38.5% 40% Percent of unrestrained…
A:
Q: mex PLC has gathered following information on the sales of face mask from April 2020 to eptember…
A: Let months following April be denoted by 1, 2, 3 and so on. And
Q: Example 18.12 Fit a straight line trend by the method of least square to the following data : Year…
A: Given, Production( in tonnes) for 6 years from 1991 to 1996
Q: Perform a Trend and Seasonal analysis with the following data. Include the trend formula and the…
A: Hello. Since you have asked multiple questions, we will solve the first question for you. If you…
Q: 100% 89.6% 90% 84.1% Seat belt use rate 80% 70% 60% 50% 43.6% 38.5% 40% Percent of unrestrained…
A: The given graph depicting the trend of seat belt use rate and percentage of unrestrained vehicle…
Q: Amex PLC has gathered following information on the sales of face mask from April 2020 to September…
A:
Q: Amex PLC has gathered following information on the sales of face mask from April 2020 to September…
A: Linear trend equation forecast method entails finding the linear equation that fits the given data…
Q: Fit a linear trend curve by the least-squares method to the following data and then estimate levels…
A:
Q: 18. Fit a straight line trend for the following data. 1997 1996 1998 1999 2000 Year: Per capita: 25…
A:
Q: Also Fit a trend line to the following data by the method of semi averages. draw the curve for both…
A:
Q: Try to fit any two moving averages models to the following data and discuss its performance. YEAR…
A: Moving average: It is a technique to get an overall idea of the trends in a data set; it is an…
Q: Use quantitativeforecast methods for the data shown below Period Observation 1 24 2 34 3 36…
A: Using excel, select the table, Then go to Insert> Scatter as given below, The time series plot:…
Q: Feb. Mar. Apr. May June July Sept. Aug 8.2 Oct. Store 1 Store 2 6.3 6.5 7.0 6.7 7.6 7.9 7.7 8.4 8.2…
A: Given data :
Q: Amex PLC has gathered following information on the sales of face mask from April 2020 to September…
A:
Q: Example 3: Using three-year moving averages, determine the trend. Production (1000 tonnes)…
A:
Q: method to answer the following questions. Year Quarter Sales 1 160 180 3 190 4 170 2 200 210 3 260 4…
A:
Q: Perdisco Limited has shared their annual sales revenue over the last 6 financial years from 2010 to…
A: linear trend equation forecast , we will use linear regression model The following data for the X…
Q: Below are given the annual production figures (in thousand tonnes) Fertiliser factory: Year 2011…
A:
Q: 9. a. Obtain the linear trend equation for the following data on new checking accounts at Fair…
A:
Q: Obtain the straight line trend equation and tabulate against each year trend and short term…
A:
Q: 1. Give below is the data on production of a company (in lakhs). Year: 1983 1984 1985 1986 1987 1988…
A:
Q: Amex PLC has gathered following information on the sales of tace mask fPom Api September 2020. Month…
A: Let months following April be denoted by 1, 2, 3 and so on. And
Q: Final Grade in
A:
Q: Q3 A manufacturer has plotted product sales over the past four weeks. Use a linear trend line to…
A:
Q: An analyst must decide between two different forecasting techniques for weekly sales of roller…
A:
Q: Month Sales ('000s) January 2$ 37 February March 42 %$4 39 April $4 29 May 49 June July 24 40 39…
A: The question is based on time series Given data :
Q: A time series plot of the time period (quarterly) verses quarterly sales (in $1,000s) is shown…
A:
Q: A pharmacist has been monitoring sales of a certain over-the-counter pain reliever. Daily sales…
A: (a). Demand Forecast values for the days 9 through 16 using trend-adjusted exponential smoothing:…
Q: From the following data fit a trend line and obtain the trend values for the different years using…
A:
Q: The analysis of Earnings Per Share (EPS) is as follows: 2015: $5.70 2016: $3.30 2017: $6.21 2018:…
A: Given: The provided data is: Year Earning Per Share (EPS) (in $) 2015 5.70 2016 3.30 2017…
Q: ALAW Ltd has experienced a growth in its product markets over the last three years and is concerned…
A: ALAW Ltd has experienced a growth in its product markets over the last three years and is concerned…
Step by step
Solved in 4 steps
- Amex PLC has gathered following information on the sales of face mask from April 2020 toSeptember 2020.Month Sales ($)April 17,000May 18,000June 19,500July 22,000August 21,000September 23,000You are required to;a. Using linear trend equation forecast the sales of face masks for October 2020.Amex PLC has gathered following information on the sales of face mask from April 2020 toSeptember 2020. Month Sales ($)April 17,000May 18,000June 19,500July 22,000August 21,000September 23,000 You are required to;a. Using linear trend equation forecast the sales of face masks for October 2020 b. Calculate the forecasted sales difference if you use 3-period weighted moving averagedesigned with the following weights: July 0.2, August 0.3 and September 0.5. (2Amex PLC has gathered following information on the sales of face mask from April 2020 toSeptember 2020. Month Sales ($) April 17,000 May 18,000 June 19,500 July 22,000 Augus 21,000September 23,000You are required to;a. Using linear trend equation forecast the sales of face masks for October 2020.b. Calculate the forecasted sales difference if you use 3-period weighted moving averagedesigned with the following weights: July 0.2, August 0.3 and September 0.5. Note: You need to show all the steps in your calculation. No excel files will be graded.
- A pharmacist has been monitoring sales of a certain over-the-counter pain reliever. Daily sales duringthe last 15 days wereDay: 1 2 3 4 5 6 7 8 9Number sold: 36 38 42 44 48 49 50 49 52Day: 10 11 12 13 14 15Number sold: 48 52 55 54 56 57a. Which method would you suggest using to predict future sales—a linear trend equation or trendadjustedexponential smoothing? Why?b. If you learn that on some days the store ran out of the specific pain reliever, would that knowledgecause you any concern? Explain.c. Assume that the data refer to demand rather than sales. Using trend-adjusted smoothing with aninitial forecast of 50 for week 8, an initial trend estimate of 2, and .3, develop forecastsfor days 9 through 16. What is the MSE for the eight forecasts for which there are actual data?Suppose a firm has had the following historic sales figures. Year: 2016 2017 2018 2019 2020 Sales $2,570,000 $3,750,000 $4,380,000 $5,010,000 $5,520,000 What would be the forecast for next year’s sales using regression to estimate a trend?The president of State University wants to forecast student enrollments for this Year academic year based on the following historical data: 5 years ago 4 years ago 3 years ago 2 years ago Last year Enrollments 15.000 16.000 18.000 20.000 21.000 a- What is the forecast for this year using a 3-year weighted moving average where the weights are halved in a descending order from newest to oldest ? b. What is the forecast for this year using the trend line for these data? c. using the MAD find which forecasting technique may be appropriate for this quetion
- Amex PLC has gathered following information on the sales of face mask from April 2020 to September 2020. Month Sales ($) April 17,000 May 18,000 June 19,500 July 22,000 August 21,000 September 23,000 You are required to;a. Using linear trend equation forecast the sales of face masks for October 2020.b. Calculate the forecasted sales difference if you use 3-period weighted moving average designed with the following weights: July 0.2, August 0.3 and September 0.5. Note: You need to show all the steps in your calculation. No excel files will be graded.Amex PLC has gathered following information on the sales of face mask from April 2020 to September 2020. You are required to; Using linear trend equation forecast the sales of face masks for October 2020. Calculate the forecasted sales difference if you use 3-period weighted moving average designed with the following weights: July 0.2, August 0.3 and September 0.5. Month Sales ($) April 17,000 May 18,000 June 19,500 July 22,000 August 21,000 September 23,000The sales records of a major auto manufacturer over the past years from 2005 to 2019 are shown below. Number of Cars Sold Year (In thousands of Units) 2005 195 2006 200 2007 250 2008 270 2009 320 2010 380 2011 440 2012 460 2013 500 2014 500 2015 550 2016 570 2017 600 2018 650 2019 700 Develop moving average with k=4 and compute its MSE Develop exponential model with α = 0.4 and compute its MSE Develop a linear trend model and compute its MSE Based on the MSE computed fore ach model , which model fits well to the data Based on the answer of question (4) forecast the number of cars sold for year 2020.
- Question 4 The below data represent the advertising expenditure and sales of Little Liu Ltd from year 2008 to 2017. Table: Advertising Expenditure vs. Sales from 2008 to 2017 Year Advert. Expenditure Sales (x, £000) (y, £000) 2008 8 30 2009 12 40 2010 11 29 2011 5 29 2012 14 43 2013 3 17 2014 6 20 2015 8 30 2016 4 22 2017 9 40 Total 80 300 Figure: Scatter Diagram of Advertising Expenditure and Sales with Trend line a) What is the statistical relationship shown in the Figure and list out 3 characteristics of this relationship? b) Work out the values of parameters of the relationship shown in the Figure (i.e. work out the equation of the relationship) c) Explain the relationship and make recommendation to Little Liu Ltd based on the information given.Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table: YEAR DEMAND FOR FERTILIZER (1,000S OF BAGS) 1 4 2 6 3 4 4 5 5 10 6 8 7 7 8 9 9 12 10 14 11 15 a) Develop a trend line for the demand for fertilizer using any computer software? b) For these three forecasts, 3-year moving average, a weighted moving average, and a trend line, which one would you use? Explain your answer?Question 4 The below data represent the advertising expenditure and sales of Little Liu Ltd from year 2008 to 2017. Table: Advertising Expenditure vs. Sales from 2008 to 2017 Year Advert. Expenditure Sales (x, £000) (y, £000) 2008 8 30 2009 12 40 2010 11 29 2011 5 29 2012 14 43 2013 3 17 2014 6 20 2015 8 30 2016 4 22 2017 9 40 Total 80 300 Figure: Scatter Diagram of Advertising Expenditure and Sales with Trend line (attached as image) a)What is the statistical relationship shown in the Figure and list out 3 characteristics of this relationship? b) Work out the values of parameters of the relationship shown in the Figure (i.e. work out the equation of the relationship). c)Explain the relationship and make recommendation to Little Liu Ltd based on the information given.