1. Bearing manufacturer called BRM manufactures bearings with outside diameters ranging from 17.91 to 18.09 mm. Each diameter and number of bearings manufactured per each diameter are given in attached Excel sheet. According to the given data a. Plot the graph of bearing diameter (x-axis) vs count or number of it (y-axis) b. Plot trendline and show the equation as well as R2 value on the graph. c. Using the equation of the trendline re-calculate the bearing counts one more time and compare your values with the real manufactured data.
1. Bearing manufacturer called BRM manufactures bearings with outside diameters ranging from 17.91 to 18.09 mm. Each diameter and number of bearings manufactured per each diameter are given in attached Excel sheet. According to the given data a. Plot the graph of bearing diameter (x-axis) vs count or number of it (y-axis) b. Plot trendline and show the equation as well as R2 value on the graph. c. Using the equation of the trendline re-calculate the bearing counts one more time and compare your values with the real manufactured data.
Holt Mcdougal Larson Pre-algebra: Student Edition 2012
1st Edition
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Chapter11: Data Analysis And Probability
Section11.1: Stem-and-leaf Plots And Histograms
Problem 1E
Related questions
Question
Please solve and answer the question correctly please. Thank you!!
Transcribed Image Text:1. Bearing manufacturer called BRM manufactures bearings with outside diameters
ranging from 17.91 to 18.09 mm. Each diameter and number of bearings manufactured
per each diameter are given in attached Excel sheet. According to the given data
a. Plot the graph of bearing diameter (x-axis) vs count or number of it (y-axis)
b. Plot trendline and show the equation as well as R² value on the graph.
c. Using the equation of the trendline re-calculate the bearing counts one more
time and compare your values with the real manufactured data.
Transcribed Image Text:Bearing diameter
17.91
17.92
17.93
17.94
17.95
17.96
17.97
17.98
17.99
18
18.01
18.02
18.03
18.04
18.05
18.06
18.07
18.08
18.09
Count
3
7
8
19
21
24
26
27
25
23
22
18
15
12
8
4
2
290
unit price
lower limit
upper limit
10
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step 1: State the given information.
VIEWStep 2: Plot the graph of bearing diameter(x-axis) Vs count of it (y-axis)
VIEWStep 3: Plot the tread line on the graph and show the equation as well as R^2 on the graph.
VIEWStep 4: Re-calculate the count of bearings using the tread line equation.
VIEWSolution
VIEW
Step by step
Solved in 5 steps with 5 images
Recommended textbooks for you
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill