Homework Help is Here – Start Your Trial Now!
Math
Statistics
Use regression analysis to estimate the line of best fit -use the manual method with the formulas shown below.

Use regression analysis to estimate the line of best fit -use the manual method with the formulas shown below.

Elementary Linear Algebra (MindTap Course List)
Elementary Linear Algebra (MindTap Course List)
8th Edition
ISBN:9781305658004
Author:Ron Larson
Publisher:Ron Larson
Chapter2: Matrices
Section2.2: Properties Of Matrrix Operations
Problem 14E: Solve for X in the Equation, given A=-2-1103-4 and B=0320-4-1 a X=3A2B b 2X=2AB c 2X+3A=B d...
See similar textbooks
icon
Related questions
Question

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 Error Absolute error Square of error 1 145.5 160 3 71 113.035 =99-113.035=-14.035 100.13 =194.5-100.13=94.37 141.99 =206-141.99364.01 184.015 =135.5-184.015=-48.515 =abs(-48.515)=48.515 =(-48.515)^2=235 168.795 =152.5-168.795=-16.295 =abs(-16.295)=16.295 =(-16.295)^2=265 155.985 =246-155.985=90.015 196.36 =259-196.36=62.64 236.605 =181.5-236.605=-55.105 =abs(-55.105)=55.105 =(-55.105)^2=303 218.04 =194-218.04=-24.04 4 99 =abs(-14.035)=14.035 =(-14.035)^2=196 5 194.5 =abs(94.37)=94.37 =(94.37)^2=8905. 206 =abs(64.01)=64.01 =(64.01)^2=4097. 7 135.5 8 152.5 =abs(90.015)=90.015 =(90.015)^2=810: =abs(62.64)=62.64 9 246 10 259 =(62.64)^2=3923. 11 181.5 12 194 =abs(-24.04)=24.04 =(-24.04 13 200.925 weight for the most recent period would be=3/(3+2+1)=0.50 weight for the second most recent period would be=2/(3+2+1)=0.33 weight for the most third most recent period would be=1/(3+2+1)=0.17 MAD =52.114 MSE =3495.5714 MAPE =0.27087=27.087%
Transcribed Image Text:Month Demand Weighted Moving average forecast Error Absolute error Square of error 1 145.5 160 3 71 113.035 =99-113.035=-14.035 100.13 =194.5-100.13=94.37 141.99 =206-141.99364.01 184.015 =135.5-184.015=-48.515 =abs(-48.515)=48.515 =(-48.515)^2=235 168.795 =152.5-168.795=-16.295 =abs(-16.295)=16.295 =(-16.295)^2=265 155.985 =246-155.985=90.015 196.36 =259-196.36=62.64 236.605 =181.5-236.605=-55.105 =abs(-55.105)=55.105 =(-55.105)^2=303 218.04 =194-218.04=-24.04 4 99 =abs(-14.035)=14.035 =(-14.035)^2=196 5 194.5 =abs(94.37)=94.37 =(94.37)^2=8905. 206 =abs(64.01)=64.01 =(64.01)^2=4097. 7 135.5 8 152.5 =abs(90.015)=90.015 =(90.015)^2=810: =abs(62.64)=62.64 9 246 10 259 =(62.64)^2=3923. 11 181.5 12 194 =abs(-24.04)=24.04 =(-24.04 13 200.925 weight for the most recent period would be=3/(3+2+1)=0.50 weight for the second most recent period would be=2/(3+2+1)=0.33 weight for the most third most recent period would be=1/(3+2+1)=0.17 MAD =52.114 MSE =3495.5714 MAPE =0.27087=27.087%
y= a+ bx where: nE xy – ExEy b = nE x² – (Ex} a = ÿ – bx
Transcribed Image Text:y= a+ bx where: nE xy – ExEy b = nE x² – (Ex} a = ÿ – bx
Expert Solution
steps

Step by step

Solved in 2 steps with 3 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Elementary Linear Algebra (MindTap Course List)
Elementary Linear Algebra (MindTap Course List)
Algebra
ISBN:
9781305658004
Author:
Ron Larson
Publisher:
Cengage Learning
Algebra and Trigonometry (MindTap Course List)
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:
9781305071742
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning
College Algebra
College Algebra
Algebra
ISBN:
9781305115545
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning
Mathematics For Machine Technology
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
Elementary Geometry for College Students
Elementary Geometry for College Students
Geometry
ISBN:
9781285195698
Author:
Daniel C. Alexander, Geralyn M. Koeberlein
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS