htLO4 7. a. Develop a linear trend equation for the followingdata on demand for white bread loaves at a bakery(use of Excel's Trendline, with display equation onchart option, is recommended), and use it to forecastdemand on day 16.Day12345Loaves Day200621472118228923510Loaves232248250253267Day1112131415Loaves281275280288310b. The variations around the linear trend line seem tohave above- and below-the-line runs. Therefore, usetrend-adjusted exponential smoothing with a = 0.3and ß = 0.2 to model the bread demand. Use the firstfour days to estimate the initial smoothed series (usethe average of the first four days) and smoothed trend(use the increase from day 1 to day 4 divided by 3).Start forecasting day 5. What is the forecast forday 16?

Given the data asDayLoaves120022143211422852356232724882509253102671128112275132801428815310

Answered: 7. a. Develop a linear trend equation…

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

An economist want to determine the relation between one’s FICO score, x, and the interest rate of a 36-month auto loan, y. The given data represent the interest rate (in percent) a bank would offer on a 36-month auto load for various FICO scores. Credit Score;x Interest Rate (percent);y 545 18.982 595 17.967 640 12.218 675 8.612 705 6.68 750 5.15 Find the least-squares regression line treating the FICO score as the explanatory variable and the interest rate as the response variable. Predict the interest rate a person would pay if their FICO score were the median score of 723.
Use the following sales data: Week Sales 1 30 2 35 3 56 4 85 5 95 6 45 7 65 8 74 9 73 10 39 Use naive method, a three-period moving average and exponential smoothing with an a=0.35 for forecast sales Compare the forecasts using MSE and MAD. Explain which one is the best. Make a forecast for weeks 11 and week 12 by using the optimal method.
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).
3. The police department is assessing its staffing requirements. The department expects that the number of serious crimes committed, C, on average each week is proportional to the number of officers, P, on special street patrol. Data for the past year has been collected and some of it is shown below: P 4 7 9 11 15 17 с 14 11 10 9 7 5 a) Neatly sketch a scatter plot of the data on graph provided below. Which variable is the independent variable that should be plotted on the horizontal axis? Notice that the data seem to fall in a linear pattern. Draw the best-fit line through the data. Label your axes, indicate the scale, and title your graph. Why has only the first quadrant been provided for the graph? b) Look at your best-fit line and identify two good coordinate points that sit right on this best-fit line:
A company has the following monthly sales for the past year. Plot the data points on a line graph and describe the results. Month Sales 1 145 2 146 3 145 4 150 5 148 6 150 7 156 8 160 9 158 10 153 11 152 12 154
For the data set, perform exponential smoothing with alpha = 0.1 to determine the forecast for week 20. week Sales (1000s of gallons) 1 17 2 21 3 19 4 23 5 18 6 16 7 20 8 18 9 22 10 20 11 15 12 22 13 31 14 34 15 31 16 33 17 28 18 32 19 30
The following time series shows the sales of supermarket chain over the last six months. Month Sales ($ 000) August 2021 250 Sep 2021 280 Oct 2021 295 Nov 2021 320 Dec 2021 380 Jan 2022 360 Develop a linear trend equation that can be used to forecast sales in Feb 2022. Forecast the sales in Feb 2021 using a three-period weighted moving average designed with the following weights: Nov 2021 weight 0.6, Dec 2021 weight 0.3 and Jan 2022 weight 0.1. Which method (A or B) is the best? Explain why.
1. A researcher is interested in knowing if there is a relationship between the years presented in the table below and the average number of people in a family receiving welfare benefits. Year Average Family Size 1969 4.0 1973 3.6 1975 3.2 1979 3.0 1983 3.0 1988 3.0 1991 2.9 a. What are your conclusions and observations about the relationship between the two variables b.What is the value of the intercept a? c. What is the value of the slope b? d. Write the linear regression equation
The following table shows the values of the age and the job satisfaction of ice cream shop employees Employee Age Job Satisfaction16 918 920 722 824 426 528 626 524 722 8 d. Sketch a scatterplot of this data by hand (do NOT use/submit any plots created by a program).e. Does there appear to be a linear relationship between the two variables? f. Calculate the slope for this data.
The below data represent the advertising expenditure and sales of Little Liu Ltd from year 2008 to 2017. Table: Advertising Expenditure vs. Sales from 2008 to 2017 Year Advert. Expenditure Sales (x, £000) (y, £000) 2008 8 30 2009 12 40 2010 11 29 2011 5 29 2012 14 43 2013 3 17 2014 6 20 2015 8 30 2016 4 22 2017 9 40 Total 80 300 Figure: Scatter Diagram of Advertising Expenditure and Sales with Trend line ( See picture) What is the statistical relationship shown in the Figure and list out 3 characteristics of this relationship? 2. Work out the values of parameters of the relationship shown in the Figure (i.e. work out the equation of the relationship). 3.Explain the relationship and make recommendations to Little Liu Ltd based on the information given.

Recommended textbooks for you

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

Elementary Statistics: Picturing the World (7th E…

Statistics

ISBN:

9780134683416

Author:

Ron Larson, Betsy Farber

Publisher:

PEARSON

The Basic Practice of Statistics

Statistics

ISBN:

9781319042578

Author:

David S. Moore, William I. Notz, Michael A. Fligner

Publisher:

W. H. Freeman

Introduction to the Practice of Statistics

Statistics

ISBN:

9781319013387

Author:

David S. Moore, George P. McCabe, Bruce A. Craig

Publisher:

W. H. Freeman

SEE MORE TEXTBOOKS