Develop and provide the linear regression equation

Assignment Help Advanced Statistics
Reference no: EM13334272

Holding goods in inventory is costly because inventoried goods are susceptible to breakage and other forms of physical damage. Typically, the amount of damage (in dollars) increases with the level of inventory (expressed in dollars), but some of the damage is unrelated to the amount of inventory. The following data show a company's inventory damage experience.

 Period Inventory Level (Millions of Dollars) Damage (Thousands of Dollars) Average Age of Inventory (Days) 1 \$11 \$80 31 2 \$15 \$90 45 3 \$13 \$70 98 4 \$10 \$60 15 5 \$7 \$50 25 6 \$9 \$70 31 7 \$13 \$80 82

You are interested in developing a forecast for the Damage for period 9.

a) You believe that there is a cause-and-effect relationship between damage and the inventory level. You believe that the damage is a function of the inventory level.

Develop and provide the linear regression equation for the damage given the inventory level using the appropriate independent and dependent variables.

b) How good is the relationship you found in a)? Based on the considerations used during class related to the strength of the relationship, would you recommend using this relationship? Explain your reasoning.

c) If the forecasted inventory level for period 9 is \$15,000,000, what is the forecasted damage for Period 9?

d) Your boss believes that there might be a cause-and-effect relationship between damage and the average age of the inventory. He wonders if the damage level might be influenced by the average age of the inventory. Based on the information provided, what would you tell him? Explain your answer. If you do agree with your boss, what would you forecast the damage level for inventory with an average age of 60 days?

Previous Q& A

Explain born-haber cycle to calculate the lattice energy

Use the Born-Haber cycle to calculate the lattice energy of LiCl(s) given the following data: ?H(sublimation) Li = 155.2 kJ/mol; I1 (Li) = 520 kJ/mol; Bond energy (Cl Cl) = 242.8 kJ/mol; EA (Cl) = 348 kJ/mol; ?Hf (LiCl(s)) = -408.8 kJ/mol. A

How does human resource planning relate to organizational

1. How does human resource planning relate to organizational ?

Based econometric model on the data

Please state what data from either a company, from the internet, or from some other source which contains at least 3 independent variables and 1 dependent variable. This can be cross sectional (recommended) or time series (not recommended). Produce a..

Calculate the crankshafts angular acceleration

The crankshaft in a race car goes from rest to 3480 rpm in 2.7s. What is the crankshaft's angular acceleration

Explain what is the solubility of znco3

What is the solubility of ZnCO3 at 25 degrees C in a buffer solution with a pH value of 10.33

Perfectly competitive market with the demand function

Consider the perfectly competitive market with the demand function Q(p)=1-p. Every firm has the cost function C(Q)=1/128 + Q^2/2. What are the long run equilibrium price, quantity of a single firm and the industry output? How many firms are in the ma..

Determine how many total revolutions has the drill turned

A dentist's drill accelerates from rest at 640rad/s2for 2.30s and then runs at constant angular velocity for 6.50s. Through how many total revolutions has the drill turned

Given that the company''s required return

Given that the company's required return (WACC) is 10%

What the value of the proximity to customers score

The factor rating method that we learned during the class, which site should Dynaco use based on the above information?

Compute the average power of the elevator motor

A 612 kg elevator starts from rest and moves upward for 4.00 s with constant acceleration until it reaches its cruising speed, 1.84 m/s. What is the average power of the elevator motor during this period

Similar Q& A

Determine the maximum flow

Determine the maximum flow (in hundreds of gallons of water per minute) from node 1 to node 5. Remember that the arc has both capacity and reverse capacity.

Unscientific sampling

A Milwaukee television station, WITI-TV, conducted a telephone call-in survey asking whether viewers liked the new newspaper, the Journal Sentinel.

Develop a forecasting model

Develop a forecasting model justifying its selection over other techniques, and project the expected number of cases to be ordered in 2014. Provide a summary of the cell phone industry outlook using Internet resources as part of Paul’s response.

Difference between average age of nfc and afc players

Is there a significant difference between the average age of NFC players and AFC players? (by "significant" we mean statistically significant)

Application of statistical process controls

For Linear Programming, you are to make up (or collect actual data) so as to be able to apply a complete linear programming optimization. Make sure to show the data to be used, show the linear program you create, and the solutio..

Statisticians working with clinical researchers

The problems for this assignment are typical of those encountered by statisticians working with clinical researchers. So if you'll humor me, I have written this assignment as though it is a day in the life of a project statistician.  Here is your age..

Managerial and financial accounting

What type of information does managerial accounting provide? What type of information does financial accounting provide?

Question regarding component cost of capital

A bond that has a \$1,000 par value (face value) and a contract or coupon interest rate of 11 percent. A new issue would have a floatation cost of 5 percent of the \$1,125 market value.

Rationale and probability distribution

Describe the rationale for utilizing probability concepts. Is there more than one type of probability? If so, describe the different types of probability.

Detailed explanation of break even

Jason processes and bottles jams. His fixed costs are 250 per month and the variable cost per jar is 1.20. He sells the jam to local grocery stores for 3.20 each. How man jars must he sell per year to break even and what will be his profit if he s..

Compute average before and average after in regulated areas

The dependent variable is hygiene score in a restaurant in a quarter and grade cards introduction has been shown to improve average grades in mandatory counties and voluntary counties.

Strategic management plan for suv company

Can you help me with the development of a 4 year strategic management plan with quantifiable goals and measures? Please provide environmental scanning of current conditions in the area of expansion including economy, competition, political stabili..