q11 Determine the equation of the trend line for the data shown below on Canadian balance of payments for exports of wheat over a five-year period provided by Statistics Canada. Using the trend line equation, forecast the value for the year 2021.Export-Balance of Payments(Unadjusted)–Wheat ($ millions)Year2015646.42016546.42017570.02018592.42019831.2(Do not round the intermediate values. Round your answers to 2 decimal places, e.g. 1.75.)+ŷ (2022) =($millions)

Answered: Image /qna-images/answer/6fe6c479-faa0-419b-9f30-e9d8facb80f0.jpg

Answered: Determine the equation of the trend…

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018

18th Edition

ISBN:9780079039897

Author:Carter

Publisher:Carter

Chapter4: Equations Of Linear Functions

Section4.5: Correlation And Causation

Problem 3CYU

See similar textbooks

Similar questions

A). Favors Distribution Company purchases small imported trinkets in bulk, packages them, and sells them to retail stores. The managers are conducting an inventory control study of all their items. The following data are for one such item, which is not seasonal. Use a trend projection to estimate the relationship between time and sales (state the equation). Calculate forecasts for the first four months of the next year. 1 2 3 4 5 6 7 8 9 10 11 12 Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Sales 51 55 54 57 50 68 66 59 67 69 75 77
In Colorado, sales of medical marijuana began in November 2012; however, the Department of Revenue did not report tax collection data until February of 2014. The accompanying data file includes monthly revenue from medical and retail marijuana tax and fee collections as posted in the Colorado state accounting system. Use the linear trend model (no seasonality) to forecast the tax revenue for November and December of 2018. Date Revenue February/14 3,519,756 March/14 4,092,575 April/14 4,980,992 May/14 5,273,355 June/14 5,715,707 July/14 6,522,085 August/14 7,407,450 September/14 7,741,167 October/14 7,232,870 November/14 7,642,800 December/14 7,465,568 January/15 8,558,141 February/15 8,802,295 March/15 9,099,395 April/15 9,979,643 May/15 10,617,311 June/15 11,326,452 July/15 10,856,584 August/15 12,811,437 September/15 13,181,758 October/15 11,656,736 November/15 11,290,012 December/15 12,231,410 January/16 13,247,434 February/16…
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
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?
Amex PLC has gathered following information on the sales of face mask from April 2020 to September 2020. 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. Month Sales ($) April 17,000 May 18,000 June 19,500 July 22,000 August 21,000 September 23,000
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,000
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.

Recommended textbooks for you

Glencoe Algebra 1, Student Edition, 9780079039897…

Algebra

ISBN:

9780079039897

Author:

Carter

Publisher:

McGraw Hill

Big Ideas Math A Bridge To Success Algebra 1: Stu…

Algebra

ISBN:

9781680331141

Author:

HOUGHTON MIFFLIN HARCOURT

Publisher:

Houghton Mifflin Harcourt

Glencoe Algebra 1, Student Edition, 9780079039897…

Algebra

ISBN:

9780079039897

Author:

Carter

Publisher:

McGraw Hill

Big Ideas Math A Bridge To Success Algebra 1: Stu…

Algebra

ISBN:

9781680331141

Author:

HOUGHTON MIFFLIN HARCOURT

Publisher:

Houghton Mifflin Harcourt

SEE MORE TEXTBOOKS