Annual sugar production 2011–2017: least-squares trend line, trend values and 2020 estimate
Below are given the annual production of sugar (in thousand tons) of a factory:
| Year | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 |
| Production | 77 | 88 | 94 | 85 | 91 | 98 | 90 |
i. Fit a straight line by the method of least squares.
ii. Obtain the trend values.
iii. Plot the given figures on a graph and show the trend line.
iv. What is the monthly increase in production?
v. Estimate production of sugar for the year 2020.
Question from
Chapters
Business Statistics MGT 202
Solution
Solution not added yet.
Explore more questions
-
1.
Practice
The following table shows the profit (Rs. millions) of ABC company:
Year 2015 2016 2017 2018 2019 2020 2021 2022 2023 Profit 16 20 25 28 30 27 29 32 25 Fit a straight line trend by least square method. Calculate the trend values. Estimate the profit for the year 2024.
-
2.
Practice
The trend line equation of sales (in millions rupees) is \(Y = 50 + 2.5X\). Estimate the sales for the year 2022, when year of origin is assumed to be 2015.
-
3.
Practice
Fit a straight line trend by the method of least squares and estimate the sales for 2004 and 2005.
Years 1998 1999 2000 2001 2002 2003 Sales (in '000 Rs) 40 52 54 52 50 53 -
4.
Long question Practice
The following time series data shows the profit (million Rs) of XYZ company from the fiscal year 2015 to 2023:
Year Profit (Million Rs) 2015 15 2016 18 2017 20 2018 22 2019 25 2020 23 2021 27 2022 32 2023 30 a. Fit a straight line trend to these data.
b. Calculate the trend values and short term fluctuations.
c. Plot the actual data as well as the trend values on graph paper.
d. Estimate the profit for 2024.
e. What is the monthly increment of the profit?
-
5.
Practice
The year of origin of the following trend line equation of production (in tonnes) is 2017.
\(y = 40 + 1.5x\)
Estimate the production for the year 2033.
-
6.
Practice
The following table reveals the sales distribution of a business house from the year 2016 to 2020:
Year 2016 2017 2018 2019 2020 Sales (in 000 Rs) 50 51 60 75 100 Fit a trend line equation of given data. Calculate trend values and estimate sales of the year 2024.
Question
Open in new tabCouldn't load this question. Open it instead.