Regression analysis to estimate the line of best fit

Assignment Help Operation Management
Reference no: EM13219244

Data collected on the gasoline sales over the past 12 weeks are shown in the following table.

Week

Sales (1000s of gallons)

1

17

2

21

3

19

4

23

5

18

6

16

7

20

8

18

9

22

10

20

11

15

12

22

a) Using a weight of 1/2 for the most recent observation, 1/3 for the second most recent,and 1⁄6 for third most recent, compute a three-week weighted moving average for the time series. Compute the MAD, MSE and MPE for this method.

b) Use exponential smoothing with a smoothing constant of 0.1 to forecast the gasoline sales . Assume that last period's forecast for year 1 is 15,000 gallons to begin the procedure. Which method do you think is best?. Is this an improvement over the weighted average- use all measures above i.e MAD,MSE, MAPE

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

y=a+bx

where:

 b= n∑xy-∑x∑y

       n∑x2 -(∑X)2

a=y-bx

Reference no: EM13219244

Questions Cloud

Inadequate instructions have on level of anger : f a researcher wanted to study the effects that inadequate instructions have on level of anger/frustration, how would the researcher want to operationally define the IV and the DV?
Explain the term structure of interest rates : One method used to obtain an estimate of the term structure of interest rates is called bootstrapping. Suppose you have a one-year zero coupon bond with a rate of r1 and a two-year bond with an annual coupon payment of C
Brain-cognition phenomenon and three-box model of learning : Brain-cognition phenomenon and the Three-Box Model of Learning
Explain how gender norms shifted : explain how gender norms shifted following world war II: what was the new view of men,and how did it differ from the previous view? what was the new vision fo women, and how did it difer from the reality?
Regression analysis to estimate the line of best fit : Compute a three-week weighted moving average for the time series. Compute the MAD, MSE and MPE for this method - regression analysis to estimate the line of best fit
History of bipolar disorder and schizophrenia : iscuss the history of bipolar disorder & schizophrenia and their effects on people.
Compute the expected rate of return : Demonstrate to your colleagues how you would calculate the expected rate of return,r-hat, also called r-hat, and Beta on a self-designed portfolio of four common stocks selected from the NASDAQ or NYSE stock exchanges. Assume the weighting of the ..
What would be the short name generated by windows : If I created a file name Budget Analysis 2005.html, what would be the short name generated by Windows?
What is the value of the smallest resistor : The voltage drops across three resistors in series are measured 10V, 15V, and 25V. If the largest resistor is 47 ohms, what is the value of the smallest resistor?

Reviews

Write a Review

Operation Management Questions & Answers

  The company explains that although this proportion

A company is criticized because only 16 of 46 executives at a local branch are women. The company explains that although this proportion is lower than it might wish

  High-level causal-loop diagram

Develop a high-level causal-loop diagram (with main stock-flow chains for the wildshrimp catch and aquaculture production activities) depicting the key variables and feedback (balancing and reinforcing) loops that most likely are creating the system ..

  Determining productivity

One of the students from Op Management class starts a company that produces baseball bats. He/she is the owner and the only employer in the company.

  Discuss the primary purposes of holding inventory

The key points in Chapter 12 tell us that good inventory management is important for successful organizations. The key issues are when to order and how much to order.

  Explain several ways in which operations management can lead

Explain several ways in which operations management can lead to greater competitive advantage also profitability. Include at least two real-world examples.

  Would it be the same if the award was published

Would it be the same if the award was published on the Internet, but the revocation in the newspaper? Explain

  Discuss possible components to an expatriate career package

Discuss possible components to an expatriate career package which would make this move more attractive. Explain principles of non male efficiency, beneficence, autonomy also justice. Use examples for each.

  Considering the purchase of two alternative cars

A student is considering the purchase of two alternative cars. Car A initial costs $1,500 more than Car B, but uses 0.05 gallons per mile, versus 0.07 gallons per mile for Car B

  What style of leadership are you prepared to use

What style of leadership are you prepared to use in the givin stiation? Do you have a time frame? How will you difine success?

  Illustrate what is the optimum number of containers support

The material is obtained from a nearby supplier also has a 12-hour cycle time. An efficiency factor of 0.15 has been assigned to this cell. Illustrate what is the optimum number of containers to support this operation.

  Describe how they differ from every other

Consider also discuss describe how the phenomena of pro social behaviour also pure altruism relate to every other also describe how they differ from every other.

  Recommendation for brandon production

Brandon Production is a small firm focused on the assembly and sale of custom computers. The firm is facing stiff competition from low-priced alternatives, and is looking at various solutions to remain competitive and profitable.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd