Purchase Solution

Regression Analysis - Operational Management

Not what you're looking for?

Ask Custom Question

This is a problem #13, chapter 9 - Regression Analysis, from the textbook by Cliff Ragsdale, "Spreadsheet Modeling and Decision Analysis".
This problem requires the use of Excel and the add-in, called Solver. The course is Excel-based and Solver is the optimization application used for all problems. Scatter plot of the data needs to be prepared.

Oriented Strand Board (OSB) is manufactured by gluing woodchips together to form panels. Several panels are then bonded together to form a board. One of the factors influencing the strength of the final board is the amount of glue used in the production process. An OSB manufacturer conducted a test to determine the breaking point of a board based on the amount of glue used in the production process. In each test, a board was manufactured using a given amount of glue. Weight was then applied to determine the point at which the board would fail (or break). This test was performed 27 times using various amounts of glue. The data obtained from this testing may be found in the file Dat9-13.xls on your data disk.
a. Prepare a scatter plot of this data
b. What type of regression function would you use to fit this data?
c. Estimate the parameters of the regression function. What is the estimated regression function?
d. Interpret the value of the R statistic
e. Suppose the company wants to manufacture board that will withstand up to 110 lbs. of pressure per square inch. How much glue should they use?

Purchase this Solution

Solution Summary

The solution provides step by step method for the calculation of Regression Analysis in Operational Management . Formula for the calculation and Interpretations of the results are also included.

Purchase this Solution


Free BrainMass Quizzes
Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.