Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. basic math
  3. determine the best fit linear regression equation

Determine the Best Fit Linear Regression Equation Using Technology - Excel Question The table shows the age in...

Free

60.1K

Verified Solution

Question

Basic Math

Determine the Best Fit Linear Regression Equation UsingTechnology - Excel

Question

The table shows the age in years and the number of hours sleptper day by 24 infants who were less than 1 year old. Use Excel tofind the best fit linear regression equation, where age is theexplanatory variable. Round the slope and intercept to one decimalplace.

Age

Hours

0.03

16.5

0.05

15.2

0.06

16.2

0.08

15.0

0.11

16.0

0.19

16.0

0.21

15.0

0.26

14.5

0.34

14.6

HelpCopy to ClipboardDownload CSV

Provide your answer below:

Answer & Explanation Solved by verified expert
4.1 Ratings (783 Votes)

To do regression analysis in Excel first goto data menu and then DataAnalysis under which you have to select regression.

Now select dependent variable in Y and independent in X.

The dependent variable is hours of sleep and independent variable is age.

Regression Statistics
Multiple R 0.677634
R Square 0.459188
Adjusted R Square 0.381929
Standard Error 0.580535
Observations 9
ANOVA
df SS MS F Significance F
Regression 1 2.00308 2.00308 5.943499 0.044895
Residual 7 2.359142 0.33702
Total 8 4.362222
Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
Intercept 16.13266 0.342254 47.13647 5.06E-10 15.32336 16.94197
Age -4.65712 1.910278 -2.43793 0.044895 -9.17421 -0.14003

the p-value in ANOVA table is less than 0.05 hence the model is significant.

The regression equation is Hours of sleep = 16.1 - 4.7*Age.
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

A 1 liter solution contains 0.436 M hypochlorous acid and 0.581 M sodium hypochlorite. Addition of 0.109 moles...

Chemistry
Q

Name 10 changes that an elderly person must endure (may be physical, mental, social, etc). Give a...

Psychology
Q

What are some implementation plans on rural areas for having lack of healthcare. Please be very...

General Management
Q

height of its n the mpact illed 8 Three blocks are initially placed as shown...

Physics
Q

point s possible The data on the right represent the number of live multiple delivery...

Statistics
Q

Let f x 5x 11x 2 Using the definition of derivative f x lim h...

Calculus
Q

Determine whether y varies directly with x.y = 2x + 2 Choose...2y = -7xy =...

Algebra
Q

Problem 12-25 (LO 12-1) [The following information applies to the questions displayed below.]...

Accounting
Q

Prior to installing a JIT system, Buckner Company, a producer of automobile parts, used maintenance...

Accounting
Q

Three Rivers Inc. provides cable TV and Internet service to the local community. The activities...

Accounting
Q

7questions Use the dlagram below to...

Accounting
Q

You are a stock analyst and your friend has approached you with a hot tip....

Finance