Please hit a like if you are satisfied with the answer.
You are projecting future sales and have constructed a linear model using historical sales data for...
Using the model, predict sales for the fourth quarter of year 2015 You are projecting future sales and have constructed a linear model using historical sales data for each of the four quarters between years 2011 and 2014. Answer questions 24-28 using the information below Regression Statistics Obs Quarter Year Sales Sales 1 2011 71 Multiple R 0.995 7 2011 49 R Square 0.990 90 58 3 2011 Adjusted R Square 0.986 80 4 2011 78 Standard Error 1.561 70...
Assume you are analyzing a time series of 12 observations. Using a 3-period moving average, you successfully calculate the Mean Absolute Error (MAE), Mean Square Error (MSE), and Mean Absolute Percentage Error (MAPE) for each forecasted time period. You then sum the error calculations for each time period for each of the three error calculation techniques respectively. You end up with: MAE 53.5, MSE 547.25, and MAPE 44.15%. To complete your error calculation and compare the accuracy of the 3-period...
Year Quarter Sales (in Billions) 2009 1 2.62 2009 2 2.33 2009 3 2.4 2009 4 2.42 2010 1 2.72 2010 2 2.53 2010 3 2.61 2010 4 2.84 2011 1 2.95 2011 2 2.79 2011 3 2.93 2011 4 3.03 2012 1 3.44 2012 2 3.2 2012 3 3.3 2012 4 3.36 2013 1 3.79 2013 2 3.56 2013 3 3.74 2013 4 3.8 2014 1 4.24 2014 2 3.87 2014 3 4.15 2014 4 4.18 2015 1 4.8...
Find the required linear model using least-squares regression. The following table shows the number of operating federal credit unions in a certain country for several years. Year 2011 2012 2013 2014 2015 Number of federal credit 4488 unions 4316 4150 3976 3809 (a) Find a linear model for these data with x = 11 corresponding to the year 2011. (b) Assuming the trend continues, estimate the number of federal credit unions in the year 2018. (a) The linear model for...
A country import data shows the following. Using the data Calculate the straight line trend model using the least square method and predict the total import for 2017 and 2018 Calculate a three year moving average for the data and show the same on separate column year import in billions $ 2007 21 2008 18 2009 16 2010 24 2011 23 2012 24 2013 39 2014 28 2015 12 2016 34
Quarter Year 2008 sales 1 2 3 4 160 180 190 70 Quarter Year 2009 sales 200 210 260 230 Quarter Year 2009 sales 210 240 290 260 what is the seasonal factor for the quarter2 Of 2011? O A. 0.945 O B. 1.1 ° C. 0.867 OD. 0.975 The following data show the quarterly sales of a major auto manufacturer for the years 2012 through 2014. Quarter year 2012 sales 12 34 500 380 290 170 Quarter year 2013...
Using the data in the following table, 2. estimate the: a. Average return and volatility for each stock. b. Covariance between the stocks. c. Correlation between these two stocks, a. Estimate the average return and volatility for each stock. The average return of stock A is _______ %. (Round to two decimal places.)Year201020112012201320142015Stock A-3%16%7%-3%4%6%Stock B16%19%28%-1%-11%25%
7-20. Historical Returns: Expected and Required Rates of Return You have observed the following returns over time: Year 2011 2012 2013 2014 2015 Stock X Stock Y Market 14% 13% 12% 19 7 10 - 16 -5 -12 3 s11 20 11 15 - Assume that the risk-free rate is 4%, the market risk premium is 5%, the beta for Stock X is 1.50, and the beta for Stock Y is 0.46: a. What are the required rates of return...
Analyze: There is considerable debate within your firm concerning the effect of advertising on sales. The marketing department believes advertising has a large positive effect; others are not so sure. For instance, the production and technical staffs believe the quality of the product itself largely determines sales. To clarify the debate, you have gathered the attached data for the last 24 quarters. Also refer to an Introduction to Regression in MS-Excel as needed. a. Does advertising affect unit sales? Base...
Suppose we have the following annual sales data for an automobile dealership: Year Sales Trend 2009 121 1 2010 187 2 2011 165 3 2012 134 4 2013 155 5 2014 167 6 2015 200 7 2016 206 8 2017 221 9 2018 231 10 We want to forecast sales for 2019 and 2020 using either a simple trend model or a quadratic trend model. Use a within sample forecasting technique...