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 ii. The a and b value Corelation coefficient and correlation determination

A First Course in Probability (10th Edition)
10th Edition
ISBN:9780134753119
Author:Sheldon Ross
Publisher:Sheldon Ross
Chapter1: Combinatorial Analysis
Section: Chapter Questions
Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...
icon
Related questions
Question

Can someone show the steps on how to find the answer for question 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 2 steps with 1 images

Blurred answer