A product engineer wants to optimize the cutting of strips of wood, which are used to make plywood. To cut the wood strips, the log is held in place by chucks which are inserted at each end. The log is then spun while a saw blade cuts off a thin layer of wood. The engineer measures the torque that can be applied to the chucks before they spin out of the log, under different conditions of log diameter, log temperature, and chuck penetration. Worksheet column Diameter Description The log diameter: 4.5 and 7.5 Factor The chuck penetration: 1.00, Factor 1.50, 2.25, and 3.25 The log temperature: 60, 120,150 The torque that can applied Response before the chuck spins out Variable type Distance Temperature Factor Torque

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

Can someone show the steps on how to find the answer for question 1,2,3 using Microsoft Excel

Topic: Plywood Manufacturing
A product engineer wants to optimize the cutting of strips of wood, which are used to make
plywood. To cut the wood strips, the log is held in place by chucks which are inserted at each
end. The log is then spun while a saw blade cuts off a thin layer of wood. The engineer
measures the torque that can be applied to the chucks before they spin out of the log, under
different conditions of log diameter, log temperature, and chuck penetration.
Description
The log diameter: 4.5 and 7.5 Factor
The chuck penetration: 1.00, Factor
1.50, 2.25, and 3.25
The log temperature: 60, Factor
120,150
The torque that can applied Response
before the chuck spins out
Worksheet column
Variable type
Diameter
Distance
Temperature
Torque
1. A study of Preston et al. examined a sample of 120 log diameter to make a plywood. Is
there a significance difference in mean of torque force (newton/meter) for log diameter
4.5 and 7.5? Let a= 0.05. What is the p-value? Compute and interpret thep-value.
2. The sample of 120 chuck penetration, 1.00, 1.50, 2.25 and 3.25 distance are entered
into statistical software package. Analysis of variance is used to investigate of there is a
difference in the mean torque force of the four-chuck penetration. What do you condude?
Use the .01 significance level.
3. In this exercise, you will obtain some practice doing a simple linear regression using
Minitab software. This data set has n =120 observation of the log temperature (x) and
torque force (y).
a) Find:
i.
The linear regression model, y = a +bx
The a and b value
ii.
i.
Correlation coefficient and correlation determination.
iv.
Scatter plot with overlay of fitted line.
b) Write one paragraph interpretation of your linear regression model from your
finding in (a).
Transcribed Image Text:Topic: Plywood Manufacturing A product engineer wants to optimize the cutting of strips of wood, which are used to make plywood. To cut the wood strips, the log is held in place by chucks which are inserted at each end. The log is then spun while a saw blade cuts off a thin layer of wood. The engineer measures the torque that can be applied to the chucks before they spin out of the log, under different conditions of log diameter, log temperature, and chuck penetration. Description The log diameter: 4.5 and 7.5 Factor The chuck penetration: 1.00, Factor 1.50, 2.25, and 3.25 The log temperature: 60, Factor 120,150 The torque that can applied Response before the chuck spins out Worksheet column Variable type Diameter Distance Temperature Torque 1. A study of Preston et al. examined a sample of 120 log diameter to make a plywood. Is there a significance difference in mean of torque force (newton/meter) for log diameter 4.5 and 7.5? Let a= 0.05. What is the p-value? Compute and interpret thep-value. 2. The sample of 120 chuck penetration, 1.00, 1.50, 2.25 and 3.25 distance are entered into statistical software package. Analysis of variance is used to investigate of there is a difference in the mean torque force of the four-chuck penetration. What do you condude? Use the .01 significance level. 3. In this exercise, you will obtain some practice doing a simple linear regression using Minitab software. This data set has n =120 observation of the log temperature (x) and torque force (y). a) Find: i. The linear regression model, y = a +bx The a and b value ii. i. Correlation coefficient and correlation determination. iv. Scatter plot with overlay of fitted line. b) Write one paragraph interpretation of your linear regression model from your finding in (a).
のッ
Transcribed Image Text:のッ
Expert Solution
steps

Step by step

Solved in 4 steps with 9 images

Blurred answer
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman