---### MTH 301 – Quantitative Methods**Exercise:**Use a Linear Trend Line to forecast the demand for months 13 and 14 of the following time series:| Month $ t $ | Demand $ Y_t $ ||---------------|------------------|| 1 | 37 || 2 | 40 || 3 | 41 || 4 | 37 || 5 | 45 || 6 | 50 || 7 | 43 || 8 | 47 || 9 | 56 || 10 | 52 || 11 | 55 || 12 | 54 |**Instructions:**- You must show your work.- Give the equation for the linear trend line, and show all calculations.**Plot Explanation:**A graph is presented alongside the data table to visually represent the demand over 12 months. - The X-axis is labeled "Month" and ranges from 1 to 12.- The Y-axis is labeled "Demand" and ranges from 0 to 60.- Data points are plotted for each month to show the fluctuation in demand over time.- Each point represents the demand for a specific month.The graph exhibits an overall increasing trend with some fluctuations.---This transcription and plot explanation offer a detailed understanding of the exercise for students visiting an educational website.

Introduction: Consider that x is the independent variable and y is the dependent variable. The size…

Use a Linear Trend Line to forecast the demand for months 13 and 14 of the following time series: Month Demand Y, 60 1 37 50 2 40 3 41 40 4 37 45 50 7 43 8 47 10 9 56 10 52 1 2 3 4 5 6 7 8 9 10 11 12 Month 11 55 12 54 Note: You myst shouw your werk. Grive the eqyatio for the linear trend line, and show all calculationS. Demand

Use a Linear Trend Line to forecast the demand for months 13 and 14 of the following time series: Month Demand Y, 60 1 37 50 2 40 3 41 40 4 37 45 50 7 43 8 47 10 9 56 10 52 1 2 3 4 5 6 7 8 9 10 11 12 Month 11 55 12 54 Note: You myst shouw your werk. Grive the eqyatio for the linear trend line, and show all calculationS. Demand

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

Given the following data on the number of pints of ice cream sold at a local ice cream store for a 10-period time frame: Period Demand 1 230 2 220 3 200 4 270 5 300 6 300 7 330 8 340 9 360 10 300 Use a 2-period moving average to forecast demand for period 11 Group of answer choices 350 225 330 335
A small detergent company in Karachi is confident that their sales are growing significantly week by week. Treating sales for the previous eight weeks as a typical example of this increasing trend, they recorded them in PKR 1000's and examined the results. Week 1 2 3 4 5 6 Sales (in PKR) 2.59 2.55 2.63 2.68 2.74 2.83 2.86 2.99 a) Plot a scatter diagram between week and sales. b) Find the equation of regression line. c) Find the expected sales for 12 week d) Find the correlation coefficient between the two variables.
Anita Limited has shared their annual sales revenue over the last 6 financial years from 2015 to 2020. Year Sales ($ 000) 2015 4500 2016 5100 2017 4900 2018 5400 2019 5670 2020 6000 You are required to; a) Using linear trend equation forecast the sales revenue of Anita Limited for 2021. Note: See the formula sheet on the next page. P.S.: I can't attach the formula sheet in this because it has variuos symbols, such as Sigma, log, x value etc. I uploaded the formula sheet and the question as well in the chat box. Please let me know if you need any more information.
A soda company is monitoring the number of cases of soda it produces as a function of time. A manager checked the line several times a day for a week. She then graphed the combined data. Assume that we should see a linear (best straight line) relationship between time and production. What is the best estimate of the number of cases that will be produced in 1 hr on a typical day? 8. 7 1 0.5 1.5 2 2.5 Time in hours Select one: а. 1 b. 2 C. 2.5 d. 4.5 е. 7 Cases of soda produced
Month Actual demand Forecasted Demand 1 950 1000 2 1070 1000 3 1100 1000 4 960 1000 5 1090 1000 6 1050 1000 For the dataset above, compute the overall MAPE.
Obtain the regression of demand on price from the following data and estimat demand when the price is 7.5 Price Demand Price Demand 2.0 75 4.5 40 2.5 60 5.0 40 3.0 55 5.5 35 3.5 50 6.0 30 4.0 45 6.5 30
Period 1 2 3 4 5 6 7 Actual 42 41 39 43 45 F ? ? 2 2. Using the same table above, compute the weighted moving average forecast for demand for four latest period. With data using a weight of .40 for the most recent, .30 for the next recent, .20 the next, and .10 for the oldest. Assume actual demand for period 6 is 44, what is the forecast for period 7?
The table shows the percents x and numbers y (in millions) of women in the work force for selected years. T 1970 1975 1980 1985 1990 1995 2000 2005 Percent, x 43.3 46.3 51.5 54.5 57.5 58.9 59.9 59.3 Number, y 31.5 37.5 45.5 51.1 56.8 60.9 66.3 69.3 Year (a) Use the regression capabilities of a graphing utility to find the least squares regression line for the data. (Round your coefficients to two decimal places) YM (b) According to this model, approximately how many women enter the labor force for each one-point increase in the percent of women in the labor force? (Round your answer to two decimal places.) million women
For the past 10 years, you have been observing the sales of your company since you embarked on an aggressive advertising campaign. You have been recording the amounts spent on advertising and the corresponding sales as follows: Year Advert (X) Sales (Y) 2001 10 44 2002 9 40 2003 11 42 2004 12 46 2005 11 48 2006 12 52 2007 13 54 2008 13 58 2009 14 56 2010 15 60 You would like to determine whether a relationship exists between your two variables of interest and therefore decide to run a regression. Specify the estimation model you will use (the econometric form). Identify the independent and the dependent variables. Use an econometric package of your choice (EViews, SPSS, STATA etc) to estimate the model. From the regression output, report the coefficients, standard errors, t-statistics, probability and R-squared (report the results in a table). Re-write the specified model in (a) with values…
Weekly sales of copy paper at Cubicle Suppliers are in the table below. Compute a three-period moving average and a four-period moving average for weeks 5, 6, and 7. Compute each forecast. Which model is more accurate? Forecast week 8 with the more accurate method. Week Sales (cases) 1 17 2 21 3 27 4 31 5 19 6 17 7 21
Using exponential smoothing, calculate the forecasts for months 2, 3, 4, 5, and 6. Thesmoothing constant is 0.2, and the old forecast for month 1 is 245.