In Excel create a 4 period moving average with additive trend in excel using the below excel data. Optimize the model for the value of x that minimizes the MSE. Calculate the MSE for the model and next years prediction. What is the MSE for this model? (use 2 decimal places). Below is the excel data and the moving average that excel gave me. Just need to optimize the model for x and minimize MSE?

In Excel create a 4 period moving average with additive trend in excel using the below excel data. Optimize the model for the value of x that minimizes the MSE. Calculate the MSE for the model and next years prediction. What is the MSE for this model? (use 2 decimal places). Below is the excel data and the moving average that excel gave me. Just need to optimize the model for x and minimize MSE?

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

Summarize the definitions for linear correlation, quadratic correlations and exponential correlations. Provide an example graph of each of the types of correlation along with your summarized definitions.
Make this statistical data an equation.
Interpret the OLS coefficients (intercept and slope coefficients). When doing it, make sure to discuss the sign of the coefficient, its magnitude and ceteris-paribus interpretations, as well as statistical significance of the coefficients. First, discuss the approximate marginal effects. Next, calculate and discuss the exact marginal effects.
Explain trend projection with regression?
Develop a scatterplot and explore the correlation between customer age and net sales by each type of customer (regular/promotion). Use the horizontal axis for the customer age to graph. Find the linear regression line that models the data by each type of customer. Round the rate of changes (slopes) to two decimal places and interpret them in terms of the relation between the change in age and the change in net sales. What can you conclude? Hint: Rate of Change = Vertical Change / Horizontal Change = Change in y / Change in x
You generate a scatter plot using excel. Excel plot the trend line and report the equation y=-49.78x+24.08 and the r^2=0.3969 what is the correlation coefficient for this data set?
We conduct a regression of size on hhinc, owner, hhsize1, hhsize2, and hhsize3. Wedo not include the constant. The regression output is reported in Table 3. Would youconclude that the home size increases with the household size? Interpret the signand magnitude of the estimated coefficients of hhsize1, hhsize2, and hhsize3
This activity demonstrates how to create graphics to enhance the presentation of quantitative data Scenario The sales manager for a small manufacturer is interested in marketing the company's rain coat line in a new area of the country. As a first step to establishing a marketing plan she has asked you to produce some graphs showing the market share of the products sold over the past several years in the region. Analysis After some research, you acquire the approximate sales for each of the competing products presently in the region under consideration (See the data given below). The question now is to show how best to organize the data to take advantage of a graphical analysis. Pie charts give a quick overview of the market share "slices” each competitor presently enjoys. So you decide to use a pie chart to graph the most recent year's sales data for the region. This will give a good indication of just who the market leaders are and how crowded it is at the top. Next, you decide to…
Using the data in the Excel spreadsheet "auto.xlsx", estimate a regression to answer the following question. How much does a 1 inch increase in LENGTH corresponds to a _________________ dollars increase in PRICE. Use negative values if it results in a decreased price. Round your answers to two decimals.
A trendline is given to depict enrollment at a local college where x is the year and y represents enrollment. Y=178.09x-353194 Use the rrendline ro estimate the enrollment for 2009. Round to the nearest whole number.
60% 12:18 PM + MathHW414b.. / Activinspire - Studio Untitied Untitied CLASSFLOW CONNECT DEVICES Page 430 of 1,040 B Which of the following functions has a greater slope and y-intercept? Function 1: Y = 11x - (-13) Function 2: 90 80 70 60 50 40 30 20 10 6. You're using this app in Workspace.
An economist at Nedbank ran a study of the relationship between FTSE/JSE All Shares index return (JALSH) and consumer price index (CPI) from 2006 to 2017, the data collected is shown in the Table 1 below. FTSE/JSE All Shares index return (JALSH) and consumer price index (CPI) from 2006 to 2017. Year JALSH (Y) CPI (X) 2006 0.41 4.7 2007 0.19 7.1 2008 -0.23 11.5 2009 0.32 7.1 2010 0.19 4.3 2011 0.03 5.0 2012 0.27 5.6 2013 0.21 5.7 2014 0.11 6.1 2015 0.05 4.6 2016 0.00 6.4 2017 0.21 5.3 The estimated regression…