The following table shows the quarterly sales of "Undercover Umbrellas" over a period of two years. Sales are shown at quarterly intervals throughout the year. Year Quarter Sales (£ million) 4-point moving average (£ million) 2019 1 8.4 2019 2 2.3 4.8 2019 3 1.6 2019 4 6.9 2020 1 8.8 2020 2 2.7

Calculus For The Life Sciences
2nd Edition
ISBN:9780321964038
Author:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Chapter7: Integration
Section7.CR: Chapter 7 Review
Problem 88CR
icon
Related questions
Question

23

The following table shows the quarterly sales of "Undercover Umbrellas" over a period of two years. Sales are shown at quarterly intervals throughout the year.
Year
Quarter
Sales (£ million)
4-point moving average
(£ million)
2019
1
8.4
2019
2
2.3
4.8
2019
3
1.6
2019
4
6.9
2020
1
8.8
2020
2
2.7
2020
3
2.4
2020
4
Not available
The first 4-point moving averages has been calculated (see table above).
i) Calculate the next three 4-point moving averages:
Second 4-point moving average:
million pounds
Third 4-point moving average:
million pounds
Fourth 4-point moving average:
million pounds
ii) A trendline was used to predict the next 4-point moving average and obtained a value of 5.3 million pounds
th
Use this value to predict the sales for the 4" quarter of 2020.
th
million pounds
The predicted sales for the 4 quarter of 2020 are:
Transcribed Image Text:The following table shows the quarterly sales of "Undercover Umbrellas" over a period of two years. Sales are shown at quarterly intervals throughout the year. Year Quarter Sales (£ million) 4-point moving average (£ million) 2019 1 8.4 2019 2 2.3 4.8 2019 3 1.6 2019 4 6.9 2020 1 8.8 2020 2 2.7 2020 3 2.4 2020 4 Not available The first 4-point moving averages has been calculated (see table above). i) Calculate the next three 4-point moving averages: Second 4-point moving average: million pounds Third 4-point moving average: million pounds Fourth 4-point moving average: million pounds ii) A trendline was used to predict the next 4-point moving average and obtained a value of 5.3 million pounds th Use this value to predict the sales for the 4" quarter of 2020. th million pounds The predicted sales for the 4 quarter of 2020 are:
Expert Solution
steps

Step by step

Solved in 4 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Calculus For The Life Sciences
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
Linear Algebra: A Modern Introduction
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning