Question

The heights (in inches) and weights (in pounds) of 25 baseball players are given below. Use Excel to find the best fit linear regression equation, where height is the explanatory variable. Round the slope and intercept to two decimal places.

Height Weight

71 186

72 211

73 220

70 165

72 180

72 195

70 175

74 202

78 240

71 170

74 180

73 185

76 257

77 215

76 287

77 220

73 200

76 223

76 200

70 220

75 215

71 195

77 194

75 195

75 225

Answer #1

We can directly use here Excel for regression,

Step1) Enter data in Excel.

Step 2) Data >>data analysis >>Regression >> select x and y values separately >>ok

Therefore, regression equation is,

y=6.53x-275.47

i.e. Weight = 6.53*Height -275.47

Use Excel to find the following: Compare the height, weight (in
inches), and age for Eagles versus Patriots, using t tests. Provide
the conclusions based on the t tests.
Gaps between numbers under age are no value
77 each
Eagles:
Age
35
28
23
23
29
23
24
31
28
24
24
24
26
31
23
26
25
25
31
29
33
30
22
28
23
24
29
23
24
26
32
26
24
23
29
24
23
30
24...

The data below represents height in inches/weight in pounds.
Clearly identify the dependent and independent variables as well as
the domain and range. Choose any two points from the data using
different independent variables and use those two points to
determine the rate of change (slope). Then, using the dependent
data value of -500 as your initial value, write an equation for the
linear function model. Predict what you expect at a height of
75".
inches/pounds
60" - 105, 110...

1.2 The table below shows the height and weight
for a sample of 10 people.
Height (in)
Weight (lbs)
73
223
72
217
74
214
69
202
67
205
68
201
70
205
71
205
73
220
70
219
a) Calculate the sample variance of height.
b) Calculate the sample variance of weight.
c) Calculate the sample covariance of height and
weight.
d) Calculate the sample correlation between height and
weight.

The weights of 52 randomly selected NFL football players are
presented below. The sample mean is 248.38 and the sample standard
deviation is 46.68. A 92% confidence interval for the mean weight
of football players will be conducted by answering the questions
below.
305
265
287
285
290
235
300
230
195
236
244
194
190
307
218
315
265
210
194
216
255
300
315
190
185
183
313
246
212
201
308
270
241
242
306
237
315...

Student
What is your height in inches?
What is your weight
in pounds?
What is your
cumulative Grade Point Average (GPA) at FTCC or your primary
college?
How many hours do you
sleep each night?
1
67
100
4
7
2
62
105
4
5
3
72
120
4
8
4
61
125
4
7
5
56
105
3.7
6
6
61
120
4
7
7
65
172
3.8
7
8
72
235
3.22
5
9
63
135
4
6...

-Can you use this data for the following questions? The
population standard deviation for heights for 3 inches. We can
assume this is the standard deviation for the population for WCCC
men.
65, 65, 70, 70, 70, 70, 70, 70, 70, 70, 71, 71,71,71,71,71, 66,
67, 67, 67, 67, 67, 67,67, 68, 68, 68, 69, 69, 69, 69, 69, 69, 72,
72, 72, 73, 73, 74, 74, 74, 74, 76, 76, 76, 77, 78
-In Spring 2020, we sampled _____...

A.J. Murray
200
Francisco Rodriguez
185
Juan Padilla
200
Royce Clayton
185
Aaron Cook
205
Freddie Bynum
180
Juan Perez
170
Ryan Doumit
200
Adrian Beltre
220
Geoff Blum
200
Juan Salas
190
Ryan Garko
225
Alex Gonzalez
202
Guillermo Quiroz
202
Justin Morneau
228
Ryan Howard
230
Ben Johnson
200
Heath Bell
244
Kendry Morales
220
Ryan Madson
190
Bengie Molina
220
Hideki Okajima
194
Kenny Lofton
180
Ryan Theriot
175
Bobby Jenks
270
J.C. Romero
198
Kevin Thompson...

Pat.#
Before
After
1
195
125
To the left is 2 datasets measured for
a sample of 107 patients with the high cholesterol level before and
after taking medication. Obtain the following for both sets:
2
208
164
3
254
152
1- the mean, mode and median
4
226
144
5
290
212
2- the variance and standard
deviation
6
239
171
7
216
164
3- First, second and third
quartiles
8
286
200
9
243
190
10
217
130...

1.
Assume that male and female births are equally likely and that
the birth of any child does not affect the probability of the
gender of any other children. Find the probability of exactly nine
boys in ten births. Round the answer to the nearest thousandth.
A.
D. 0.176
B.
B. 0.0918
C.
A. 0.800
D.
C. 0.080
Find the area of the indicated region under the standard normal
curve.
A.
A. 0.3438
B.
C. 1.3090
C.
B. 0.6562
D.
D. 0.3090
The cholesterol levels (in milligrams per...

The accompanying frequency table shows the heights? (in inches)
of 130 members of a choir. a right parenthesis Find the median and
IQR. b right parenthesis Find the sample mean and sample standard
deviation. c right parenthesis Display these data with a histogram.
d right parenthesis Write a few sentences describing the
distribution of heights. frequency table of heights of choir
members. ?
Height Count
60 1
61 6
62 10
63 6
64 3
65 20
66 19
67...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 50 seconds ago

asked 3 minutes ago

asked 10 minutes ago

asked 36 minutes ago

asked 38 minutes ago

asked 51 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 2 hours ago