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?
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
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?
Step by step
Solved in 2 steps with 3 images