Time series – Page 3 – NBC Institute

QTB – Nov 2014 – L1 – SB – Q4 – Forecasting

Analyze sales data using the Least Squares Method and forecast future sales based on the trend.

Question

The sales of PQR Nigeria Plc. in thousands of Naira are listed in the table below for each quarter for years 2005 – 2008.

Sales of PQR in N’000s

Year	Quarter 1	Quarter 2	Quarter 3	Quarter 4
2005	22	35	82	37
2006	24	46	81	44
2007	25	40	87	49
2008	29	42	100	55

Required:

a. Calculate the trend in the above data using the Least Squares Method. (12 Marks)
b. Estimate the sales for each quarter using the trend line. (4 Marks)
c. Calculate the percentage variation for each quarter’s actual sales from the estimate obtained in (b) above. (4 Marks)

(Total: 20 Marks)

Answer

Find Related Questions by Tags, levels, etc.

Tags: Least Squares, Sales Forecasting, Time series, Trend Estimation
Level: Level 1

Topic: Forecasting
Series: NOV 2014

QTB – May 2017 – L1 – SA – Q18 – Statistics

This question calculates the centered moving average for a specific year in a time series of cocoa production.

Question

A ten-year record of cocoa production in a certain farm is tabulated as follows:

Year	2003	2004	2005	2006	2007	2008	2009	2010	2011	2012
Production (tonnes)	42	52	41	48	64	67	77	66	73	89

Based on a 4-year moving total, the centered moving average for the year 2007 is:
A. 79.5
B. 69.5
C. 59.5
D. 49.5
E. 39.5

Answer

Find Related Questions by Tags, levels, etc.

Tags: Business Statistics, Moving Average, Time series
Level: Level 1

Topic: Statistics
Series: MAY 2017

QTB – May 2017 – L1 – SA – Q14 – Statistics

This question involves identifying the estimable components of a time series.

Question

The TWO components of a Time Series which are usually estimable are:
A. Trend and Cyclic variation
B. Seasonal variation and Trend
C. Random movements and Trend
D. Seasonal variation and Random movements
E. Cyclic variation and Seasonal variation

Answer

Find Related Questions by Tags, levels, etc.

Tags: Forecasting, Seasonal Variation, Time series, Trend
Level: Level 1

Topic: Statistics
Series: MAY 2017

QTB – May 2016 – L1 – SB – Q6a – Data Collection Analysis

This question involves calculating moving averages and centered moving averages for quarterly sales data.

Question

The quarterly sales figures of company ABC Plc. for 3 years are as recorded below:

Year	Quarter 1	Quarter 2	Quarter 3	Quarter 4
Year 1	30	34	37	41
Year 2	45	49	54	57
Year 3	59	66	70	74

Required:
i. Calculate:

The moving averages.
(9 marks)

ii. The centered moving average for Quarter 3, Year 1.
(1 mark)

Answer

Find Related Questions by Tags, levels, etc.

Tags: Moving Averages, Seasonal Adjustment, Time series
Level: Level 1

Topic: Data Collection Analysis
Series: MAY 2016

QTB – May 2016 – L1 – SA – Q17 – Statistics

Calculating the trend stock for a future month based on historical stock figures.

Question

A company takes stock for 5 months in each year. The stock figures of materials for the most recent three years are as tabulated below:

Determine the trend stock for month 6.

A. 84

B. 85

C. 86

D. 87

E. 88

Answer

Find Related Questions by Tags, levels, etc.

Tags: Forecasting, Time series, Trend Analysis
Level: Level 1

Topic: Statistics
Series: MAY 2016

QTB – May 2015 – L1 – SA – Q19 – Statistics

Identifying the components separated during the deseasonalisation of business data.

Question

Deseasonalisation of business data is a process of separating two components of a time series which are:

A. Trend and cyclical variation
B. Irregular and cyclical variation
C. Trend and seasonal variation
D. Cyclical and seasonal variation
E. Seasonal and irregular variations

Answer

Find Related Questions by Tags, levels, etc.

Tags: Deseasonalisation, Statistical Analysis, Time series
Level: Level 1

Topic: Statistics
Series: MAY 2015

QTB – May 2015 – L1 – SA – Q14 – Statistics

Identifying types of variations present in time series data.

Question

Which of the following represents the types of variations in time series analysis?

A. Trend and cyclical variation
B. Irregular and cyclical variation
C. Trend and seasonal variation
D. Cyclical and seasonal variation
E. Seasonal and irregular variations

Answer

Find Related Questions by Tags, levels, etc.

Tags: Time series, Trend Analysis, Variations
Level: Level 1

Topic: Statistics
Series: MAY 2015

QTB – May 2015 – L1 – SA – Q12 – Statistics

Identifying the correct term for the amount of time activities can be delayed in project management.

Question

The amount of time during which a path of activities could be delayed without affecting the overall project duration is called:

A. Independent float
B. Total float
C. Free float
D. Excess time float
E. Average time float

Answer

Find Related Questions by Tags, levels, etc.

Tags: Analysis, Statistical Methods, Time series
Level: Level 1

Topic: Statistics
Series: MAY 2015

QTB – May 2015 – L1 – SA – Q11 – Statistics

Identifying methods used to measure trends in time series data.

Question

The following methods are used to measure the trend of a time series EXCEPT:

A. Semi-average
B. Moving average
C. Free-hand
D. Deseasonalisation
E. Least squares

Answer

Find Related Questions by Tags, levels, etc.

Tags: Statistical Methods, Time series, Trend Analysis
Level: Level 1

Topic: Statistics
Series: MAY 2015

BMF – May 2018 – L1 – SA – Q19 – Basics of Business Finance and Financial Markets

Identifies methods for measuring trends in time series.

Question

Which of the following methods CANNOT be utilized for trend measurement in time series data?
A. Free hand method
B. Semi-average method
C. Moving average method
D. Least squares method
E. Spearman’s ranking method

Answer

Find Related Questions by Tags, levels, etc.

Tags: Statistical Methods, Time series, Trend Measurement
Level: Level 1

Topic: Basics of Business Finance and Financial Markets
Series: MAY 2018

QT – Nov 2015 – L1 – Q1a – Forecasting

State the four factors commonly found in time series data.

Question

State the four (4) factors which may be present in a Time Series Data. (4 Marks)

Answer

Find Related Questions by Tags, levels, etc.

Tags: Cyclical, Factors, Forecasting, Random, Seasonal, Time series, Trend
Level: Level 1

Topic: Forecasting
Series: NOV 2015

Question Tag: Time series

Filter by Professional Bodies

Filter by Subject

Filter by Series

Filter by Topics

Filter by Levels

QTB – Nov 2014 – L1 – SB – Q4 – Forecasting

Analyze sales data using the Least Squares Method and forecast future sales based on the trend.

QTB – May 2017 – L1 – SA – Q18 – Statistics

This question calculates the centered moving average for a specific year in a time series of cocoa production.

QTB – May 2017 – L1 – SA – Q14 – Statistics

This question involves identifying the estimable components of a time series.

QTB – May 2016 – L1 – SB – Q6a – Data Collection Analysis

This question involves calculating moving averages and centered moving averages for quarterly sales data.

QTB – May 2016 – L1 – SA – Q17 – Statistics

Calculating the trend stock for a future month based on historical stock figures.

QTB – May 2015 – L1 – SA – Q19 – Statistics

Identifying the components separated during the deseasonalisation of business data.

QTB – May 2015 – L1 – SA – Q14 – Statistics

Identifying types of variations present in time series data.

QTB – May 2015 – L1 – SA – Q12 – Statistics

Identifying the correct term for the amount of time activities can be delayed in project management.

QTB – May 2015 – L1 – SA – Q11 – Statistics

Identifying methods used to measure trends in time series data.

BMF – May 2018 – L1 – SA – Q19 – Basics of Business Finance and Financial Markets

Identifies methods for measuring trends in time series.

QT – Nov 2015 – L1 – Q1a – Forecasting

State the four factors commonly found in time series data.

Our offerings

Contact Info

Customer

Get In Touch

Question Tag: Time series

Filter by Professional Bodies

Filter by Subject

Filter by Series

Filter by Topics

Filter by Levels

QTB – Nov 2014 – L1 – SB – Q4 – Forecasting

Analyze sales data using the Least Squares Method and forecast future sales based on the trend.

You're reporting an error for "QTB – Nov 2014 – L1 – SB – Q4 – Forecasting"

QTB – May 2017 – L1 – SA – Q18 – Statistics

This question calculates the centered moving average for a specific year in a time series of cocoa production.

You're reporting an error for "QTB – May 2017 – L1 – SA – Q18 – Statistics"

QTB – May 2017 – L1 – SA – Q14 – Statistics

This question involves identifying the estimable components of a time series.

You're reporting an error for "QTB – May 2017 – L1 – SA – Q14 – Statistics"

QTB – May 2016 – L1 – SB – Q6a – Data Collection Analysis

This question involves calculating moving averages and centered moving averages for quarterly sales data.

You're reporting an error for "QTB – May 2016 – L1 – SB – Q6a – Data Collection Analysis"

QTB – May 2016 – L1 – SA – Q17 – Statistics

Calculating the trend stock for a future month based on historical stock figures.

You're reporting an error for "QTB – May 2016 – L1 – SA – Q17 – Statistics"

QTB – May 2015 – L1 – SA – Q19 – Statistics

Identifying the components separated during the deseasonalisation of business data.

You're reporting an error for "QTB – May 2015 – L1 – SA – Q19 – Statistics"

QTB – May 2015 – L1 – SA – Q14 – Statistics

Identifying types of variations present in time series data.

You're reporting an error for "QTB – May 2015 – L1 – SA – Q14 – Statistics"

QTB – May 2015 – L1 – SA – Q12 – Statistics

Identifying the correct term for the amount of time activities can be delayed in project management.

You're reporting an error for "QTB – May 2015 – L1 – SA – Q12 – Statistics"

QTB – May 2015 – L1 – SA – Q11 – Statistics

Identifying methods used to measure trends in time series data.

You're reporting an error for "QTB – May 2015 – L1 – SA – Q11 – Statistics"

BMF – May 2018 – L1 – SA – Q19 – Basics of Business Finance and Financial Markets

Identifies methods for measuring trends in time series.

You're reporting an error for "BMF – May 2018 – L1 – SA – Q19 – Basics of Business Finance and Financial Markets"

QT – Nov 2015 – L1 – Q1a – Forecasting

State the four factors commonly found in time series data.

You're reporting an error for "QT – Nov 2015 – L1 – Q1a – Forecasting"

Our offerings

Contact Info

Customer

Get In Touch

admin