1. Use regression analysis to estimate the line of best fit -use the manual method with the formulas shown below. Month Demand Weighted Moving average forecast ErrorAbsolute errorSquare of error1145.5160371113.035 =99-113.035=-14.035100.13 =194.5-100.13=94.37141.99 =206-141.99364.01184.015 =135.5-184.015=-48.515 =abs(-48.515)=48.515 =(-48.515)^2=235168.795 =152.5-168.795=-16.295 =abs(-16.295)=16.295 =(-16.295)^2=265155.985 =246-155.985=90.015196.36 =259-196.36=62.64236.605 =181.5-236.605=-55.105 =abs(-55.105)=55.105 =(-55.105)^2=303218.04 =194-218.04=-24.04499=abs(-14.035)=14.035 =(-14.035)^2=1965194.5=abs(94.37)=94.37=(94.37)^2=8905.206=abs(64.01)=64.01=(64.01)^2=4097.7135.58152.5=abs(90.015)=90.015 =(90.015)^2=810:=abs(62.64)=62.64924610259=(62.64)^2=3923.11181.512194=abs(-24.04)=24.04=(-24.0413200.925weight for the most recent period would be=3/(3+2+1)=0.50weight for the second most recent period would be=2/(3+2+1)=0.33weight for the most third most recent period would be=1/(3+2+1)=0.17MAD =52.114MSE =3495.5714MAPE =0.27087=27.087% y= a+ bxwhere:nE xy – ExEyb =nE x² – (Ex}a = ÿ – bx

Answered: Image /qna-images/answer/a204b192-5759-4289-b494-653488e0f7d8.jpg

Answered: Use regression analysis to estimate the…

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

Q5/ Use Linear Regression to fit the following data: 1 2 4 5 6. Y 4 9 10 10 8
I couldn't include the options for the graphs because it only allows me to add two pictures.
A high R2 is all that is needed to determine if a regression is a good model of a causal process. A. True B. False
You performed a regression analysis of a set of bibariate data (two variables) and found that the coefficient od determination was .99 for a quadratic model and .88 for cubic model Explain which model you would use and why
How does R treat those observations with missing values? In other words, what role do the observations with missing values play in the regression? No command is needed for this question. You must need to provide an answer or take a guess.
The owner of a movie theater company used multiple regression analysis to predict gross revenue (y) as a function of television advertising (x,) and newspaper advertising (x,). The estimated regression equation was ý = 82.3 + 2.29x, + 1.90x2. The computer solution, based on a sample of eight weeks, provided SST = 25.1 and SSR = 23.415. (a) Compute and interpret R? and R 2. (Round your answers to three decimal places.) The proportion of the variability in the dependent variable that can be explained by the estimated multiple regression equation is 653 x . Adjusting for the number of independent variables in the model, the proportion of the variability in the dependent variable that can be explained by the estimated multiple regression equation is (b) When television advertising was the only independent variable, R2 = 0.653 and R,2 = 0.595. Do you prefer the multiple regression results? Explain. Multiple regression analysis (is preferred since both R2 and R.2 show an increased v v…
Please tell it is true or false
A study was conducted in California to investigate the relationship between house size (x in square feet) and house price (y in thousands of dollars). The least-square regression line is given below y= 263.5 + 0.174x R2 = 0.728 a) Interpret the slope of the given regression line b) find the predicted house price for a house size of 120 square feet c) if the actual house price was $449.5 thousand dollars for a house size of 1200 square feet, calculate the residual of the home d) find the correlation coefficient. Round to 3 decimal places
Solvent cement is used to join PVC joints. Researchers are interested in predicting the amount of time needed for the joint to set (measured in hours) as it is related to the temperature measured in degrees F for 4 to 8-inch diameter pieces. A random sample of PVC joints was taken and a linear regression model was found. Use the following output and the fact that R2 = 0.965 to answer the following questions. 1. Find the equation of the regression line. 2. Interpret the slope in the words of the problem. 3. Find the Coefficient of Determination and interpret in the words of the problem
The table shows the number of goals allowed and the total points earned (2 polnts for a win, and 1 point for an overtme or shootout loss) by 14 lce hockey teams over the course of a season The equation of the regression line is (a) Find the coefficient of determination,, and interpret the result (b) Find the standard error of the estimate, and interpret the resut Goals Allowed, x Points, y -0.560x 218.067 Use he data to answer the folowing questions 217 213 221 229 260 262 277 205 216 20s 217 208 257 246 66 70 105 105 0 83 47106 103 97 9182 91 88 Inco (a) r-O (Round to three decimal places as noeded.)
The trip rate (y) and the corresponding household sizes (x) from a sample are shown in Table Q2. Apply the regression method to find the trip rate for a household size of 10. Table Q2
The table lists the average monthly cost to workers for family health insurance for various years. Year, x Average Monthly Cost to Workers for Family Health Insurance $298 a) Use a graphing calculator to fit a regression line to the data. b) Predict the average monthly cost to workers for family health insurance in 2020, and compare the value with $493.3, which is obtained using the points (1,340) and (4,386). c) Find the correlation coefficient for the regression line, and determine whether the line fits the data closely. 2009, 0 2010, 1 2011, 2 340 348 2012, 3 367 2013, 4 2014, 5 386 406 a) The linear equation of the regression line that best models the data is y =x+. (Round to the nearest hundredth as needed.) b) The average monthly cost to workers for family health insurance in 2020 is predicted to be $ (Round to the nearest cent as needed.) Compare the above obtained value with $493.3 This value is $ $493.3 c) The correlation coefficient is (Round to the nearest thousandth as…

SEE MORE QUESTIONS

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