Business at Tina's Floral Shop can be viewed as falling into three distinct seasons: (1) Christmas (November andDecember); (2) Mother's Day (late April to May); and (3) all other times. Time Series Analysis and Forecasting of Averageweekly sales ($) during the past four years are shown below:t123456789101112131415InterceptSalesQuarterly Sales Data for Tina's Floral ShopYearYear 1Year 2Year 3Year 4Year 5Quarter1231231231Sales (1000s) (Y₂)1769.01925.0789.01889.02098.0990.02140.02294.01009.02156.02378.01086.023123Coefficients1448.50153934.39781177Show Transcribed TextCMA(3)1494.331534.331592.001659.001742.671808.001814.331819.671847.671873.33Forecasts -->a) Find the missing St* It. (Show Calculation)b) Find the missing St. (Show Calculation)c) Complete the Forecast for Year 5. (Show Calculation)St ItStDeasonalized(Y₁/S₂)1500.401513.781446.101602.181649.831814.491815.071803.961849.321828.641870.021990.44Trend Forecast1482.901517.301551.691586.091620.491654.891689.291723.681758.081792.481826.881861.28Forecast1748.371929.47846.621870.042060.69902.921991.702191.92959.222113.372323.141015.53

Given the data as t Year Quarter Sales (1000s) (Yt) CMA(3) St*It St Deasonalized (Yt/St) Trend…

Answered: Business at Tina's Floral Shop can be…

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 12PPS

See similar textbooks

Similar questions

Table 6 shows the year and the number ofpeople unemployed in a particular city for several years. Determine whether the trend appears linear. If so, and assuming the trend continues, in what year will the number of unemployed reach 5 people?
Forecasting Methods: Perform Trend Series Analysis (sales projection for the year 10, 12 and 17) Make based on the sales data below:Year 1: 24,333; Year 2: 33,524; Year 3: 26,778; Year 4: 30,567; Year 5: 27,564; Year 6: 24,555; Year 7: 21,777 and Year 8: 25,669.
Consumption of monthly electric power in million of kwh for street lighting in a big city during 2013 - 17 is given below: Year Jan Feb, Mar. Apr. May June July Aug. Sept. Oct. Nov. Dec. 2013 318 281 278 250 231 216 223 245 269 302 325 347 2014 342 309 299 268 249 236 242 262 288 321 342 364 2015 367 328 320 287 269 251 259 284 309 345 367 394 2016 392 349 342 311 290 273 282 305 328 364 389 417 2017 420 378 370 334 314 296 305 330 356 396 422 452 Find out the seasonal variation by the method of monthly averages.
Consider the following time series: Quarter Year 1 Year 2 Year 3 1 69 66 60 2 44 36 46 60 62 55 4 79 82 73 3.
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…
Describe the three major categories of data (time-series, cross-sectional, and panel).
B4. A company has collected and smoothened its historcal yearly sales data of a product from 2015 up to 2021. The following table shows the sales and moving average figures. Year Sales Three-year moving average Five-ycar moving average (S thousands) 2015 2016 326.0 324.0 E 367.4 2017 344.0 2018 383.0 371.0 E 2019 389.0 2020 398.0 D. 2021 428.0 Calculate the missing values of 4, B, C, D, E and F(Correct to I decimal place).
Cryptocurrencies have rapidly become an important alternative to traditional currencies for many types of transactions. Etherium, one of the most prominent cryptocurrencies, has rapidly appreciated in value. Daily Etherium trading information for the first 332 days of 2021. It includes the following variables: Date Day – Day of the year, used to assess trend over time Volume (US $) – Daily trading volume Opening Price (US $) – Opening price for daily trading Price Change (US $) – Daily change in price from opening to close 1. Determine the sample correlation coefficient, r, between Volume and Price Change. Test the alternative hypothesis that Volume has a linear relationship to Price Change. Specifically, what are the test statistic and the p-value for that test statistic? For α = .05, what do you conclude about the relationship between the variables? (reminder: the T.DIST.2T function requires input of a positive test statistic)
Annualized percentage return on investment (as compared to the Standard & Poor's 500 Index) for 10 randomly selected stock screeners are reproduced in the table. Complete parts a through c.
The number of cases of merlot wine sold by the Connor Owen winery in an eight-year period is as follows: YEAR CASES OFMERLOT WINE 2013 376 2014 518 2015 416 2016 474 2017 286 2018 374 2019 427 2020 394 Using 5-year simple moving average model to estimate the sales of 2021
The following table is the quarterly seasonal indexes for the sales data of the Trending Trading Company from 2007 to 2010. Uncentered Centered 4 Quarter Moving Average 4 Quarter Moving Total 2x4 Quarter Moving Total Period 2007 Q1 Q2 Q3 Q4 2008 Q1 Y 182 180 232 200 191 196 239 204 195 206 248 213 198 203 794 803 819 826 830 834 844 853 862 865 862 884 892 Q2 Q3 Q4 2009 Q1 Q2 Q3 Q4 2010 Q1 Q2 Q3 270 Q4 221 The adjusted seasonal index for the second quarter is: 1597 1622 1645 1656 1664 1678 1697 1715 1727 1727 1746 1776 199.625 202.750 205.625 207.000 208.000 209.750 212.125 214.375 215.875 215.875 218.250 222.000 Seasonal Ratio 116.2179 98.6436 92.8875 94.6860 114.9038 97.2586 91.9269 96.0933 114.8813 98.6682 90.7216 91.4414 EO
Top of Form a)Plot the monthly sales data. b)Forecast January sales using each of the following: i)Naive method. ii)A 3-month moving average. iii)A 6-month weighted average using .1, .1, .1, .2, .2, and .3, with the heaviest weights applied to the most recent months. iv)Exponential smoothing using an α = .3 and a September forecast of 18.

SEE MORE QUESTIONS

Recommended textbooks for you

Glencoe Algebra 1, Student Edition, 9780079039897…

Algebra

ISBN:

9780079039897

Author:

Carter

Publisher:

McGraw Hill

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

Algebra

ISBN:

9781285463247

Author:

David Poole

Publisher:

Cengage Learning

Glencoe Algebra 1, Student Edition, 9780079039897…

Algebra

ISBN:

9780079039897

Author:

Carter

Publisher:

McGraw Hill

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

Algebra

ISBN:

9781285463247

Author:

David Poole

Publisher:

Cengage Learning

College Algebra

Algebra

ISBN:

9781938168383

Author:

Jay Abramson

Publisher:

OpenStax

SEE MORE TEXTBOOKS