MGMT 2050 Lecture 7: MGMT2050-October24

82 views2 pages
28 Nov 2016
Department
Course
Professor

Document Summary

Using alpha = 1 equals a line of naive approach. Type 2 number in excel and excel will recognize difference and fill in cells for you when you drag it down. Due to violation if residual plot is a parabola, a better model could be used. Remove labels of x axis columns, highlight first 2 columns, hold command, and then highlight revenue column. Estimated value of y (y hat) = 20. 44 + 1. 4812t. 1. 4812 means for each additional unit in time (quarters) our sales or revenue will go up by. 1. 4812 millions of dollars (trend movement we captured). After using regression to predict, highlight 3 columns leaving year and produce line chart. When we don"t have actual data, we use the forecasted data instead. Technique with linear regression (coefficients) and technique with moving average (k value). Make an error column for regression (r) and error column for moving average (ma)

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers
Class+
$8 USD/m
Billed $96 USD annually
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
30 Verified Answers

Related Documents