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: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Statistics
1.2K views

Tracie spins the four colored spinner shown below She records the total number of times...

Chemistry
1.2K views

Synthesis of potassium trioxalatoferrate (volumetric techniques and KMnO4 titration) Work the following problems: a. suppose you have as...

Physics
1.2K views

1). A car is moving along a straight line defined to be the positive x direction....

Biology
1.2K views

Some diseases are caused by too many unfolded proteins in the endoplasmic reticulum (ER). Which...

Physics
1.2K views

5 V Two blocks A and B are kept over a smooth horizontal surface as...

Physics
1.2K views

46 A block of mass 3m is connected with a string which is wound on...

Physics
1.2K views

Shown in the figure are the displacement time graph for two children going home from...

Accounting
1.2K views

i need help in paula's portraits student exercises in quickbooks. ...

Accounting
1.2K views

[22] The following is a section of a system flowchart for a payroll application: Symbol...

Finance
1.2K views

need quickly, will like!! susan sonders is the purchasing manager for the...

Finance
1.2K views

XAM FIN 4610 Tuesday, May 19 at 8.15 Suppose the spot and three-month forward rates...

Accounting
1.2K views

What happens when a company is operating in an inflationary environment? ...