10q3r1 (4)Body weight Bench press148145176148154133189156181166217174210168150139137109151119172138219167142131143119151164136124149147129134219162169140149180187156198149156131220149154138212147122122133163136136 An exercise science major wants to try to use body weight to predict how much someone can bench press. He collects thedata shown below on 30 male students. Both quantities are measured in pounds.Assignment 10q3 dataa) What type of association does there appear to be between these two variables?can not be determinedno associationnegative associationpositive associationb) Compute a 95% confidence interval for the average bench press of 150 pound males. What is the lower limit? Give youranswer to two decimal places.c) Compute a 95% confidence interval for the average bench press of 150 pound males. What is the upper limit? Give youranswer to two decimal places.d) Compute a 95% prediction interval for the bench press of a 150 pound male. What is the lower limit? Give your answerto two decimal places.e) Compute a 95% prediction interval for the bench press of a 150 pound male. What is the upper limit? Give your answerto two decimal places.OO O

Question
Asked Dec 2, 2019
10q3r1 (4)
Body weight Bench press
148
145
176
148
154
133
189
156
181
166
217
174
210
168
150
139
137
109
151
119
172
138
219
167
142
131
143
119
151
164
136
124
149
147
129
134
219
162
169
140
149
180
187
156
198
149
156
131
220
149
154
138
212
147
122
122
133
163
136
136
help_outline

Image Transcriptionclose

10q3r1 (4) Body weight Bench press 148 145 176 148 154 133 189 156 181 166 217 174 210 168 150 139 137 109 151 119 172 138 219 167 142 131 143 119 151 164 136 124 149 147 129 134 219 162 169 140 149 180 187 156 198 149 156 131 220 149 154 138 212 147 122 122 133 163 136 136

fullscreen
An exercise science major wants to try to use body weight to predict how much someone can bench press. He collects the
data shown below on 30 male students. Both quantities are measured in pounds.
Assignment 10q3 data
a) What type of association does there appear to be between these two variables?
can not be determined
no association
negative association
positive association
b) Compute a 95% confidence interval for the average bench press of 150 pound males. What is the lower limit? Give your
answer to two decimal places.
c) Compute a 95% confidence interval for the average bench press of 150 pound males. What is the upper limit? Give your
answer to two decimal places.
d) Compute a 95% prediction interval for the bench press of a 150 pound male. What is the lower limit? Give your answer
to two decimal places.
e) Compute a 95% prediction interval for the bench press of a 150 pound male. What is the upper limit? Give your answer
to two decimal places.
OO O
help_outline

Image Transcriptionclose

An exercise science major wants to try to use body weight to predict how much someone can bench press. He collects the data shown below on 30 male students. Both quantities are measured in pounds. Assignment 10q3 data a) What type of association does there appear to be between these two variables? can not be determined no association negative association positive association b) Compute a 95% confidence interval for the average bench press of 150 pound males. What is the lower limit? Give your answer to two decimal places. c) Compute a 95% confidence interval for the average bench press of 150 pound males. What is the upper limit? Give your answer to two decimal places. d) Compute a 95% prediction interval for the bench press of a 150 pound male. What is the lower limit? Give your answer to two decimal places. e) Compute a 95% prediction interval for the bench press of a 150 pound male. What is the upper limit? Give your answer to two decimal places. OO O

fullscreen
check_circle

Expert Answer

Step 1

Given data

Enter the data in excel as shown below

В
А
В
1 Body Weight(x) Bench Press(y)
17
136
124
145 18
2
148
149
147
148 19
3
176
129
134
133 20
154
219
162
156 21
189
169
140
166 22
6
181
180
149
174 23
7
217
187
156
168 24
210
8
149
198
13925
150
156
131
10926
10
137
220
149
119 27
151
11
154
138
12
172
138
28
212
147
167
13
219
29
122
122
14
142
131
30
163
133
15
143
119
31
136
136
16
164
151
124
17
136
Ln
4
LC
help_outline

Image Transcriptionclose

В А В 1 Body Weight(x) Bench Press(y) 17 136 124 145 18 2 148 149 147 148 19 3 176 129 134 133 20 154 219 162 156 21 189 169 140 166 22 6 181 180 149 174 23 7 217 187 156 168 24 210 8 149 198 13925 150 156 131 10926 10 137 220 149 119 27 151 11 154 138 12 172 138 28 212 147 167 13 219 29 122 122 14 142 131 30 163 133 15 143 119 31 136 136 16 164 151 124 17 136 Ln 4 LC

fullscreen
Step 2
Steps to do linear regression in excel
• Enter the data in excel
• Go to data -> select on data analysis
• Go to regression
• Enter the following data as shown below and click ok

 

? X
Regression
Input
ок
Input Y Range
SBS1:SBS6
Cancel
Input X Range:
SAS1:SAS6
Help
Labels
Constant is Zero
Confidence Level:
95
Output options
Output Range:
SFS15:SPS30
New Worksheet Ply:
New Workbook
Residuals
Besiduals
Residual Plots
Standardized Residuals
Line Fit Plots
Normal Probability
Normal Probability Plots
help_outline

Image Transcriptionclose

? X Regression Input ок Input Y Range SBS1:SBS6 Cancel Input X Range: SAS1:SAS6 Help Labels Constant is Zero Confidence Level: 95 Output options Output Range: SFS15:SPS30 New Worksheet Ply: New Workbook Residuals Besiduals Residual Plots Standardized Residuals Line Fit Plots Normal Probability Normal Probability Plots

fullscreen
Step 3

The result obtained i...

Regression Statistics
Multiple R
0.80108
R Square
0.64174
Adjusted R Square
0.62894
Standard Error
9.75938
Observations
30
ANOVA
|Significance F
df
SS
MS
F
Regression
1 4776.99 4776.99 50.15445414 1.05174E-07
Residual
28 2666.88 95.2456
Total
29 7443.87
Coefficientandard Err tStat
P-value
Upper 95%
Lower 95%
Intercept
70.1712 10.3998 6.74736 2.51203E-07 48.86818012 91.47422442
Body Weight(x)
0.42843
0.0605 7.08198 1.05174E-07 0.304511554 0.552352816
help_outline

Image Transcriptionclose

Regression Statistics Multiple R 0.80108 R Square 0.64174 Adjusted R Square 0.62894 Standard Error 9.75938 Observations 30 ANOVA |Significance F df SS MS F Regression 1 4776.99 4776.99 50.15445414 1.05174E-07 Residual 28 2666.88 95.2456 Total 29 7443.87 Coefficientandard Err tStat P-value Upper 95% Lower 95% Intercept 70.1712 10.3998 6.74736 2.51203E-07 48.86818012 91.47422442 Body Weight(x) 0.42843 0.0605 7.08198 1.05174E-07 0.304511554 0.552352816

fullscreen

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in

Math

Statistics

Advanced Topics in Statistics

Related Statistics Q&A

Find answers to questions asked by student like you

Show more Q&A add
question_answer

Q: Kayla Greene is a team lead for an environmental group for a certain region. She is investigating wh...

A: Given data

question_answer

Q: The following table shows the selling​ prices, in thousands of​ dollars, and the square footages of ...

A: The null and alternative hypotheses are stated below:Null hypothesis: There is no significant correl...

question_answer

Q: The number of calories consumed per day for a child is normally distributed with a mean of 1544 and ...

A: The number of calories consumed per day for a child is normally distributed with a mean of 1544 and ...

question_answer

Q: The American Water Works Association reports that the per capita water use in a single-family home i...

A: a.The critical value is calculated using t-distribution with (n-1) degrees of freedom.Here, the degr...

question_answer

Q: At a Raffle, 1000 tickets are sold at $5 each. There are 20 prizes of $100, and 1 grand prize of $20...

A: Before calculating the expected net gain, the probability distribution for the expected net gain is ...

question_answer

Q: Describe how to write the null and alternative hypotheses based on a claim. Provide at least one exa...

A: Hypothesis:Hypothesis is an assumption about the parameter of the population which will be made on t...

question_answer

Q: A random sample of 75 medical doctors in Detroit showed that they worked an average of 55.1 hours/we...

A: Conditions for Two sample Independent t test: The two samples are independent to each other.Populati...

question_answer

Q: Later in the week someone at Consumer Reports disputed the conclusion in the Acme potato chip test. ...

A: Hello there! there are more than three subparts in the question. According to our policies we cannot...

question_answer

Q: Help

A: Given data Mean difference in the time spent watching the climber approach the hinderer toy versus w...