### Estimate the least squares regression line

Assignment Help Operation Management
##### Reference no: EM13104390

For the data below:

 Year Automobile Sales Year Automobile Sales 1990 116 1997 119 1991 105 1998 34 1992 29 1999 34 1993 59 2000 48 1994 108 2001 53 1995 94 2002 65 1996 27 2003 111

(a)           Determine the least squares regression line using Excel.

(b)           Determine the predicted value for 2004.

(c)           Determine the 3 month moving average.

(d)           Determine the MSE for the trend line (in a) and the 3 month moving average (in c.) Which forecasting method is better? Explain.

#### Questions Cloud

 Explain history of world civilizations : A famous publishing company, has contacted you about possibility of writing new textbook for first semester History of World Civilizations course, potentially very lucrative undertaking. Analyzing or rejection of a lot of incoming material : The quality control manager for ENTA Inc. must decide whether to accept (a1), further analyze (a2) or reject (a3) a lot of incoming material. Assume the following payoff table is available. What is the transverse speed for a point on the string : The function y(x, t) = (25.0 cm) cos(?x - 20?t), with x in meters and t in seconds, describes a wave on a taut string. What is the transverse speed for a point on the string at an instant when that point has the displacement y = +22.0 cm? Determing confidence interval estimation : Compute the 99% confidence interval for the population mean based on the sample 62, 68, 61, 64, 65, 62, and 66. Then, change the number from 66 to 16 and calculate the confidence interval. Estimate the least squares regression line : Determine the least squares regression line using Excel. Determine the MSE for the trend line (in a) and the 3 month moving average (in c.) Which forecasting method is better? Explain. What is the tangential speed of a wad of chewing gum : A wheel with radius 43.9 cm rotates 4.27 times every second. Find the period of this motion. Point estimates and confidence intervals : The Warren County Telephone Company claims in its annual report that "the typical customer spends \$70 per month on local and long-distance service. What is the total distance the car travels : A car travels north at 28.9 m/s for 14.3 min. It then travels south at 40.1 m/s for 28.5 min. a) What is the total distance the car travels? b) What is the displacement of the car? Randomly selected five pound box of nails : What is the probability that there are less than 500 nails in a randomly selected five pound box of nails?

### Write a Review

#### Elucidate how long will it take to produce the unit

The first unit took 85 hrs to produce. Depend on past experience with manufacturing similar units, Cambridge estimates that the learning rate is 93 percent. Elucidate how long will it take to produce the 5th unit.

#### Graphically decide a daily production plan that minimizes

Graphically decide a daily production plan that minimizes the cost of meeting Leary Chemical's daily demands.

#### Illustrate what involves analyzing a situation

Illustrate what involves analyzing a situation, determining goals to be pursued also deciding upon the actions which will be taken to achieve these goals.

#### Illustrate what is capacity balance

Illustrate what is capacity balance also explain why is it difficult to achieve in practice. Discuss the methods that might be available to a business to address capacity imbalance.

#### What is the resulting ucl value for the line

From the samples you determine the fraction defective is 0.05 and the standard deviation is 0.01. If the desired confidence level is 99.7 percent, what is the resulting UCL value for the line?

#### What makes the strategy formulation process unique

What makes the strategy formulation process unique from other decision that the organization makes on a daily basis

#### Describe any constsaints on the ability of businesses

Describe any constsaints on the ability of businesses to respond to external factors.

#### List the types of potential segmenting dimensions

List the types of potential segmenting dimensions and explain which you would try to apply first, second and third in a particular situation.

#### Explain impact of globalization also information technology

Compare also contrast three different types of entrepreneurs also state which you are most likely to emulate should you begin a small business. Assess impact of globalization also information technology on creation of small businesses.

#### The goal is to choose a design that maximizes the profit

The goal is to choose a design that maximizes the expected profit at a typical restaurant over a 300-day period. Designs K1, K2, and K3 cost \$100 000, \$130 000, and \$180 000 respectively.

#### Why has it been important for perry ellis international

Why has it been important for Perry Ellis International to give freedom to a new venture team in order torelaunch Original Penguin?

#### Illustrate what are ways that management can recognize

Illustrate what are ways that management can recognize the existence of fear in an organization. Illustrate what strategies might managers use to deal with also eliminate fear.

#### 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