MATLAB: An Introduction with Applications
6th Edition
ISBN: 9781119256830
Author: Amos Gilat
Publisher: John Wiley & Sons Inc
expand_more
expand_more
format_list_bulleted
Question
For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84, and 83.
- Compare a three-month moving average forecast with an exponential smoothing forecast for α = 0.2. Which provides the better forecasts using MSE as the measure of model accuracy? Do not round your interim computations and round your final answers to three decimal places.
Moving |
Exponential |
|
MSE |
What is the forecast for next month? If required, round your answer to two decimal places.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- According to the CDC, cholesterol levels can be reduced by following a healthy diet, getting regular exercise, and reducing the amount of alcohol consumed on a weekly basis. One method of monitoring overall cholesterol levels is to calculate your cholesterol ratio (LDL/HDL), in general a cholesterol ratio between 3.5 and 5.0 is considered to be healthy for most adults. Suppose you are a clinical researcher testing the effects of these lifestyle changes on patient cholesterol levels. In order to determine if following these guidelines helps to reduce overall cholesterol, a total of 18 participants (N = 18) with moderate to high cholesterol ratios (i.e., 3.91 to > 5.0) were recruited for a healthy lifestyle study and their cholesterol ratio was calculated three times over a six week period: Week 0 (baseline), Week 3, and Week 6. Using the variables "Week 0", "Week 3", and "Week 6" in the data set, conduct a One-Way, Within Subjects (AKA Repeated Measures) ANOVA, at α = 0.05, to see…arrow_forwardThe following chart shows the actual sales for the last 12 months for a given company. Assume that sales are best fit by a linear trend and you can use single linear regression to set up a forecasting model. Using the sales data answer below questions (justify your answers): A.What would be the typical linear regression equation for the number of sales? B.Make the sales forecast for period 15 of next year. C. Make the sales forecast for period 17 of next year. D. What is the standard error for the data?arrow_forwardThe number of banks in a country has been dropping steadily since 1984, and the trend in recent years has been roughly linear. The annual data for the years 1999 through 2008 can be summarized as follows, where x represents the years since 1990 and y the number of banks, in thousands. n=10 Ex-235 ²-5605 Ey-77.564 Ey²=603.80424 Exy-1810.155 a. Find an equation for the least squares line. b. Use your result from part a to predict the number of banks in the year 2020. c. If this trend continues linearly, in what year will the number of banks drop below 6200? d. Find and interpret the correlation coefficient.arrow_forward
- If a forecaster wanted to choose a forecasting model that avoided having a large forecasting error in any given period, which error metric should they use when evaluating their forecasting options? CFE O AFE MAD MAPE O MSEarrow_forwardTable 3 gives the market value of a luxury sedan (in dollars) xyears after its purchase. Find an exponential regression model of the form y= ab* for this data set. Estimate the purchase price of the sedan. Estimate the value of the sedan 10 years after its purchase. Round answers to the nearest dollar. TABLE 3 Value ($) 1 23,125 19,050 3 15,625 11,875 5 9,450 6 7,125 2.arrow_forwardAn analyst must decide between two different forecasting techniques for weekly sales of roller blades: a linear trend equation and the naive approach. The linear trend equation is F+ = 122 +1.9t, and it was developed using data from periods 1 through 10. Based on data for periods 11 through 20 as shown in the table, which of these two methods has the greater accuracy if MAD and MSE are used? (Round your intermediate calculations and final answers to 2 decimal places.) t 11 12 13 14 15 16 17 18 19 20 Units Sold 143 149 152 145 155 152 154 159 159 162 Click here for the Excel Data File MAD (Naive) MAD (Linear) MSE (Naive) MSE (Linear))arrow_forward
- You collect data of average annual returns for Amazon Stock and Microsoft Stock and make the following table: (This data can be copied into Excel.) You use this data to answer the research question: are true population Amazon Returns greater than true population Microsoft Returns? What is your point estimate of the difference in Amazon Returns and Microsoft Returns? Enter your answer as a positive number. Round your answer to four decimal places.arrow_forwardSuppose the following estimated regression equation was determined to predict salary based on years of experience. Estimated Salary = 29,136.63 +2257.51(Years of Experience) What is the estimated salary for an employee with 24 years of experience? Answer Keypad Keyboard Shortcuts Tablesarrow_forwardIn running a logistic regression, a statistician decided to include decade of life (20s, 30s, 40s, 50s, 60s) as a categorical variable in the systematic component because they didn't believe the relationship between the log-odds and age was linear. Using dummy variables to create the systematic component, how many dummy variables would be needed to represented age?arrow_forward
- Plot the sales revenue figures and appropriate trend line on a graph and identify from this the choice of model for working out the seasonal component. Using the appropriate seasonal model, complete the calculations that are required to produce the required forecasts for quarters 1, 2, 3 and 4 of 2021. On the basis of your analysis explain the recommendation that you would make to ALAW Ltd regarding its future plans.arrow_forwardThe forecast for year 6 using a weighted 2-year moving average with weights of 0.350.35 and 0.650.65 (the weight of 0.650.65 is for the most recent period) is what?arrow_forwardConsider the following estimated regression model relating annual salary to years of education and work experience. Estimated Salary = 10,160.10 +3147.75(Education) + 1230.34(Experience) Suppose an employee with 8 years of education has been with the company for 20 years (note that education years are the number of years after 8th grade). According to this model, what is his estimated annual salary? Answer Tables Keypad Keyboard Shortcutsarrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons IncProbability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage LearningStatistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
- Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSONThe Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. FreemanIntroduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman
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