Regression Analysis - Operational Management
Not what you're looking for?
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.