Solved by Expert Tutors
Armspan and height measurements (in centimetres) were collected for eight people, with the following results: Armspan, x (cm) | Height, y (cm) 172.7...
Solved by Expert Tutors
Question

Question:

3. Armspan and height measurements (in centimetres) were collected for eight
people, with the following results:
Armspan, x (cm) | Height, y (cm)
172.7
175.3
158.1
157.5
165.1
165.1
176.5
177.8
172.7
170.2
175.3
170.2
157.5
160.0
153.0
157.5
(a) Use the Regression tool from the Analysis Toolpak in Microsoft Excel to
perform a regression analysis on the above data. Type the data above
into a blank worksheet and follow the procedure described in Example 3
from Unit 7.5 (using a confidence level of 95%). Include the Excel output
(as well as the Line Fit Plot) in your assignment submission.
(b) What is the sample regression line for this data?
(c) Test whether the slope of the line is significantly different from zero at
the 5% level.
(d) If a person has an armspan of 158.3 cm, what would you predict the
person's height to be?

risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Doneacinia pulvi

g

ipsum dolor sit amet, consectetur adi

m

itur laoreet. Nam risus

m

s

trices ac magna. Fu

iscing elit. Nam lacinia

t

itur laoreet. Nam risus ante,

x

Donec aliquet. Lorem ipsum dolor sit a

Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec

ff

icitur laoree

ctum vitae odio. Donec alique

a. Fusce dui

r

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents