I use excel. I do not know what data anlysis toolpak to use, however, to find the answer, t stat, df, P, etc. I also don't know how to word Ho and Ha. Thanks!   The data shown below are the initial weights and gains in weight (in grams) of female rats on a high protein diet from 24 to 84 days of age. The point of interest in these data is whether the gain in weight is related to (dependent on) the initial weight. If so, then feeding experiments on female rats can be made more precise by adjusting for differences in initial weights of the rats. Statistically test this with a regression analysis.   Rat Number Initial Weight (gms) Weight Gain (gms) 1 50 128 2 64 159 3 76 158 4 64 119 5 74 133 6 60 112 7 69 96 8 68 126 9 56 132 10 48 118 11 57 107 12 59 106 13 46 82 14 45 103 15 65 104   What is the equation for the multiple regression? What is the best estimate of the amount of variance in Y which is due to its regression on the independent variables?

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

I use excel. I do not know what data anlysis toolpak to use, however, to find the answer, t stat, df, P, etc. I also don't know how to word Ho and Ha. Thanks!

 

The data shown below are the initial weights and gains in weight (in grams) of female rats on a high protein diet from 24 to 84 days of age. The point of interest in these data is whether the gain in weight is related to (dependent on) the initial weight. If so, then feeding experiments on female rats can be made more precise by adjusting for differences in initial weights of the rats. Statistically test this with a regression analysis.

 

Rat Number Initial Weight (gms) Weight Gain (gms)
1 50 128
2 64 159
3 76 158
4 64 119
5 74 133
6 60 112
7 69 96
8 68 126
9 56 132
10 48 118
11 57 107
12 59 106
13 46 82
14 45 103
15 65 104

 

What is the equation for the multiple regression?

What is the best estimate of the amount of variance in Y which is due to its regression on the independent variables?

 
Expert Solution
steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman