Can someone show the steps on how to find the question 1 in

Holt Mcdougal Larson Pre-algebra: Student Edition 2012
1st Edition
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Chapter1: Variables, Expressions, And Integers
Section: Chapter Questions
Problem 17CR
icon
Related questions
Question

Can someone show the steps on how to find the question 1 in Microsoft Excel

のッ
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: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).
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Recommended textbooks for you
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Algebra: Structure And Method, Book 1
Algebra: Structure And Method, Book 1
Algebra
ISBN:
9780395977224
Author:
Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:
McDougal Littell
Elementary Algebra
Elementary Algebra
Algebra
ISBN:
9780998625713
Author:
Lynn Marecek, MaryAnne Anthony-Smith
Publisher:
OpenStax - Rice University