20 21 20 19 40 15 30 16 60 14 40 17 Use Microsoft Excel to generate regression output for this problem and use the information in the output to answer the following questions. a. Develop the estimated regression equation that relates line speed to the number of defective parts found. b. What is the number of defective parts found when the line speed is 45 fe per minute? c. Compute the coefficient of determination. Did the estimated regression equation provide a good fit to the data? 84°F

Functions and Change: A Modeling Approach to College Algebra (MindTap Course List)
6th Edition
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Bruce Crauder, Benny Evans, Alan Noell
Chapter5: A Survey Of Other Common Functions
Section5.3: Modeling Data With Power Functions
Problem 6E: Urban Travel Times Population of cities and driving times are related, as shown in the accompanying...
icon
Related questions
icon
Concept explainers
Question
100%
1. In a manufacturing process the assembly line speed (feet per minute) was
thought to affect the number of defective parts found during the impaction
process. To test this theory, managers devised a situation in which the
same batch of parts was inspected visually at a variety of line speeds. They
collected the following data.
Line Speed (x)
Number of
Defective Parts
Found (y)
20
21
20
19
40
15
30
16
60
14
40
17
Use Microsoft Excel to generate regression output for this problem and
use the information in the output to answer the following questions.
Transcribed Image Text:1. In a manufacturing process the assembly line speed (feet per minute) was thought to affect the number of defective parts found during the impaction process. To test this theory, managers devised a situation in which the same batch of parts was inspected visually at a variety of line speeds. They collected the following data. Line Speed (x) Number of Defective Parts Found (y) 20 21 20 19 40 15 30 16 60 14 40 17 Use Microsoft Excel to generate regression output for this problem and use the information in the output to answer the following questions.
Found (y)
20
21
20
19
40
15
30
16
60
14
40
17
Use Microsoft Excel to generate regression output for this problem and
use the information in the output to answer the following questions.
a. Develop the estimated regression equation that relates line speed to the
number of defective parts found.
b. What is the number of defective parts found when the line speed is 45 feet
per minute?
C. Compute the coefficient of determination. Did the estimated regression
equation provide a good fit to the data?
84 F
Transcribed Image Text:Found (y) 20 21 20 19 40 15 30 16 60 14 40 17 Use Microsoft Excel to generate regression output for this problem and use the information in the output to answer the following questions. a. Develop the estimated regression equation that relates line speed to the number of defective parts found. b. What is the number of defective parts found when the line speed is 45 feet per minute? C. Compute the coefficient of determination. Did the estimated regression equation provide a good fit to the data? 84 F
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Correlation, Regression, and Association
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Functions and Change: A Modeling Approach to Coll…
Functions and Change: A Modeling Approach to Coll…
Algebra
ISBN:
9781337111348
Author:
Bruce Crauder, Benny Evans, Alan Noell
Publisher:
Cengage Learning
Linear Algebra: A Modern Introduction
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill