QNT 561 Week 4 and 5 Individual Assignment

profilestudystudent
week_4_sample_ans.xlsx
Home>Mathematics homework help>QNT 561 Week 4 and 5 Individual Assignment

descriptive stats

age weight
Mean 39.9512195122 Mean 174.243902439
Standard Error 2.3718242489 Standard Error 7.4557867923
Median 39 Median 182
Mode 26 Mode 212
Standard Deviation 15.1870853351 Standard Deviation 47.740329119
Sample Variance 230.6475609756 Sample Variance 2279.1390243903
Kurtosis -0.7306563753 Kurtosis -1.0005541578
Skewness 0.4460254042 Skewness -0.4167078511
Range 58 Range 168
Minimum 18 Minimum 79
Maximum 76 Maximum 247
Sum 1638 Sum 7144
Count 41 Count 41
Largest(1) 76 Largest(1) 247
Smallest(1) 18 Smallest(1) 79
Confidence Level(95.0%) 4.7936356196 Confidence Level(95.0%) 15.0687072013

weight histogram

Bin Frequency
79 1
107 3
135 6
163 5
191 7
219 13
More 6

Body weight Histogram

Frequency 79 107 135 163 191 219 More 1 3 6 5 7 13 6

Body Weight in Lbs

Frequency

Age histogram

5 Frequency 5 Frequency
10 0 25 6
15 0 50 6
20 3 30 5
25 6 35 5
30 5 20 3
35 5 40 3
40 3 45 3
45 3 55 3
50 6 60 3
55 3 65 2
60 3 70 1
65 2 80 1
70 1 10 0
75 0 15 0
80 1 75 0
More 0 More 0

Age Histogram

Frequency 25 50 30 35 20 40 45 55 60 65 70 80 10 15 75 More 6 6 5 5 3 3 3 3 3 2 1 1 0 0 0 0

Age

Frequency

Regression output

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.5222664239
R Square 0.2727622175
Adjusted R Square 0.2541150949
Standard Error 41.2307578743
Observations 41
ANOVA
df SS MS F Significance F
Regression 1 24866.5205750408 24866.5205750408 14.6275767578 0.0004608975
Residual 39 66299.0404005689 1699.9753948864
Total 40 91165.5609756097
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 108.6545833311 18.3183521463 5.9314605628 0.0000006448 71.6022187749 145.7069478874 71.6022187749 145.7069478874
age 1.6417350937 0.4292565086 3.8246015162 0.0004608975 0.7734818513 2.509988336 0.7734818513 2.509988336
RESIDUAL OUTPUT
Observation Predicted weight Residuals Standard Residuals
1 151.3396957664 -32.3396957664 -0.7943507399
2 161.1901063284 -40.1901063284 -0.9871781394
3 139.8475501108 -41.8475501108 -1.0278894592
4 138.2058150171 -51.2058150171 -1.2577538557
5 146.4144904854 -36.4144904854 -0.8944387624
6 154.6231659538 11.3768340462 0.2794459356
7 154.6231659538 12.3768340462 0.3040086509
8 149.6979606728 5.3020393272 0.1302324825
9 197.3082783891 22.6917216109 0.5573702975
10 161.1901063284 -53.1901063284 -1.3064934383
11 202.23348367 9.76651633 0.23989216
12 215.3673644194 15.6326355806 0.3839799771
13 139.8475501108 -41.8475501108 -1.0278894592
14 148.0562255791 -11.0562255791 -0.2715709211
15 162.8318414221 35.1681585779 0.8638254666
16 189.0996029207 57.9003970793 1.422190969
17 197.3082783891 -8.3082783891 -0.2040738767
18 207.158688951 -30.158688951 -0.7407792904
19 172.6822519841 -27.6822519841 -0.6799512742
20 218.6508346067 -5.6508346067 -0.1387998416
21 185.8161327334 26.1838672666 0.643146877
22 175.9657221714 -96.9657221714 -2.3817414271
23 190.7413380144 50.2586619856 1.2344892055
24 189.0996029207 22.9003970793 0.5624959336
25 233.4264504497 -114.4264504497 -2.8106243247
26 151.3396957664 -34.3396957664 -0.8434761704
27 149.6979606728 46.3020393272 1.1373038096
28 195.6665432954 21.3334567046 0.5240076233
29 187.4578678271 25.5421321729 0.6273841206
30 212.083894232 -45.083894232 -1.1073828584
31 174.3239870777 23.6760129223 0.5815471647
32 175.9657221714 35.0342778286 0.8605369919
33 179.2491923587 -3.2491923587 -0.0798089868
34 184.1743976397 34.8256023603 0.8554113558
35 166.1153116094 15.8846883906 0.3901710785
36 169.3987817967 52.6012182033 1.2920287469
37 205.5169538574 39.4830461426 0.9698108214
38 144.7727553918 15.2272446082 0.374022474
39 157.9066361411 -6.9066361411 -0.1696457372
40 148.0562255791 50.9437744209 1.2513174272
41 159.5483712348 50.4516287652 1.2392289936

age Residual Plot

26 32 19 18 23 28 28 25 41 50 49 76 24 31 -32.339695766426445 -40.190106328417869 -41.847550110769788 -51.205815017104555 -36.414490485430747 11.376834046243061 12.376834046243061 5.3020393272387878 22.6917216109469 -53.190106328417869 9.7665163299512017 15.632635580629312 -41.847550110769788 -11.05622557909598 35.16815857791687 57.900397079273091 -8.3082783890531005 -30.158688951044496 -27.682251984074526 -5.650834606701153 26.183867266603556 -96.965722171404991 50.258661985607858 22.900397079273091 -114.4264504496883 -34.339695766426445 46.302039327238788 21.333456704612161 25.542132172938352 -45.083894232040223 23.676012922260213 35.034277828595009 -3.2491923587354847 34.825602360268817 15.884688390586405 52.601218203255939 39.483046142620708 15.227244608234486 -6.9066361410874038 50.94377442090402 50.451628765247364

age

Residuals

age Line Fit Plot

weight 26 32 19 18 23 28 28 25 41 50 49 76 24 31 119 121 98 87 110 166 167 155 79 241 212 119 199 210 Predicted weight 26 32 19 18 23 28 28 25 41 50 49 76 24 31 151.33969576642644 161.19010632841787 139.84755011076979 138.20581501710456 146.41449048543075 154.62316595375694 154.62316595375694 149.69796067276121 197.3082783890531 161.19010632841787 202.2334836700488 215.36736441937069 139.84755011076979 148.05622557909598 162.83184142208313 189.09960292072691 197.3082783890531 207.1586889510445 172.68225198407453 218.65083460670115 185.81613273339644 175.96572217140499 190.74133801439214 189.09960292072691 233.4264504496883 151.33969576642644 149.69796067276121 195.66654329538784 187.45786782706165 212.08389423204022 174.32398707773979 175.96572217140499 179.24919235873548 184.17439763973118 166.1153116094136 169.39878179674406 205.51695385737929 144.77275539176551 157.9066361410874 148.05622557909598 159.54837123475264

age

weight

scatter diagram

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.5222664239
R Square 0.2727622175
Adjusted R Square 0.2541150949
Standard Error 41.2307578743
Observations 41
ANOVA
df SS MS F Significance F
Regression 1 24866.5205750408 24866.5205750408 14.6275767578 0.0004608975
Residual 39 66299.0404005689 1699.9753948864
Total 40 91165.5609756097
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 108.6545833311 18.3183521463 5.9314605628 0.0000006448 71.6022187749 145.7069478874 71.6022187749 145.7069478874
age 1.6417350937 0.4292565086 3.8246015162 0.0004608975 0.7734818513 2.509988336 0.7734818513 2.509988336
RESIDUAL OUTPUT
Observation Predicted weight Residuals
1 151.3396957664 -32.3396957664
2 161.1901063284 -40.1901063284
3 139.8475501108 -41.8475501108
4 138.2058150171 -51.2058150171
5 146.4144904854 -36.4144904854
6 154.6231659538 11.3768340462
7 154.6231659538 12.3768340462
8 149.6979606728 5.3020393272
9 197.3082783891 22.6917216109
10 161.1901063284 -53.1901063284
11 202.23348367 9.76651633
12 215.3673644194 15.6326355806
13 139.8475501108 -41.8475501108
14 148.0562255791 -11.0562255791
15 162.8318414221 35.1681585779
16 189.0996029207 57.9003970793
17 197.3082783891 -8.3082783891
18 207.158688951 -30.158688951
19 172.6822519841 -27.6822519841
20 218.6508346067 -5.6508346067
21 185.8161327334 26.1838672666
22 175.9657221714 -96.9657221714
23 190.7413380144 50.2586619856
24 189.0996029207 22.9003970793
25 233.4264504497 -114.4264504497
26 151.3396957664 -34.3396957664
27 149.6979606728 46.3020393272
28 195.6665432954 21.3334567046
29 187.4578678271 25.5421321729
30 212.083894232 -45.083894232
31 174.3239870777 23.6760129223
32 175.9657221714 35.0342778286
33 179.2491923587 -3.2491923587
34 184.1743976397 34.8256023603
35 166.1153116094 15.8846883906
36 169.3987817967 52.6012182033
37 205.5169538574 39.4830461426
38 144.7727553918 15.2272446082
39 157.9066361411 -6.9066361411
40 148.0562255791 50.9437744209
41 159.5483712348 50.4516287652

scatterplot body weight versus body age

weight 26 32 19 18 23 28 28 25 41 50 49 76 24 31 119 121 98 87 110 166 167 155 79 241 212 119 199 210 Predicted weight 26 32 19 18 23 28 28 25 41 50 49 76 24 31 151.33969576642644 161.19010632841787 139.84755011076979 138.20581501710456 146.41449048543075 154.62316595375694 154.62316595375694 149.69796067276121 197.3082783890531 161.19010632841787 202.2334836700488 215.36736441937069 139.84755011076979 148.05622557909598 162.83184142208313 189.09960292072691 197.3082783890531 207.1586889510445 172.68225198407453 218.65083460670115 185.81613273 339644 175.96572217140499 190.74133801439214 189.09960292072691 233.4264504496883 151.33969576642644 149.69796067276121 195.66654329538784 187.45786782706165 212.08389423204022 174.32398707773979 175.96572217140499 179.24919235873548 184.17439763973118 166.1153116094136 169.39878179674406 205.51695385737929 144.77275539176551 157.9066361410874 148.05622557909598 159.54837123475264

age

weight

percentile ages

Point Column1 Rank Percent
25 76 1 100.00%
20 67 2 97.50%
12 65 3 95.00%
30 63 4 92.50%
18 60 5 90.00%
37 59 6 87.50%
11 57 7 85.00%
9 54 8 80.00%
17 54 8 80.00%
28 53 10 77.50%
23 50 11 75.00%
16 49 12 70.00%
24 49 12 70.00%
29 48 14 67.50%
21 47 15 65.00%
34 46 16 62.50%
33 43 17 60.00%
22 41 18 55.00%
32 41 18 55.00%
31 40 20 52.50%
19 39 21 50.00%
36 37 22 47.50%
35 35 23 45.00%
15 33 24 42.50%
2 32 25 37.50%
10 32 25 37.50%
41 31 27 35.00%
39 30 28 32.50%
6 28 29 27.50%
7 28 29 27.50%
1 26 31 22.50%
26 26 31 22.50%
8 25 33 17.50%
27 25 33 17.50%
14 24 35 12.50%
40 24 35 12.50%
5 23 37 10.00%
38 22 38 7.50%
3 19 39 2.50%
13 19 39 2.50%
4 18 41 0.00%

percentile weights

Point weights Rank Percent
16 247 1 100.00%
37 245 2 97.50%
23 241 3 95.00%
12 231 4 92.50%
36 222 5 90.00%
9 220 6 87.50%
34 219 7 85.00%
28 217 8 82.50%
20 213 9 77.50%
29 213 9 77.50%
11 212 11 70.00%
21 212 11 70.00%
24 212 11 70.00%
32 211 14 67.50%
41 210 15 65.00%
40 199 16 62.50%
15 198 17 57.50%
31 198 17 57.50%
27 196 19 55.00%
17 189 20 52.50%
35 182 21 50.00%
18 177 22 47.50%
33 176 23 45.00%
7 167 24 40.00%
30 167 24 40.00%
6 166 26 37.50%
38 160 27 35.00%
8 155 28 32.50%
39 151 29 30.00%
19 145 30 27.50%
14 137 31 25.00%
2 121 32 22.50%
1 119 33 17.50%
25 119 33 17.50%
26 117 35 15.00%
5 110 36 12.50%
10 108 37 10.00%
3 98 38 5.00%
13 98 38 5.00%
4 87 40 2.50%
22 79 41 0.00%

Raw data

age weight age weight age weight
26 119 54 220 26 117
32 121 32 108 25 196
19 98 57 212 53 217
18 87 65 231 48 213
23 110 19 98 63 167
28 166 24 137 40 198
28 167 33 198 41 211
25 155 49 247 43 176
41 79 54 189 46 219
50 241 60 177 35 182
49 212 39 145 37 222
76 119 67 213 59 245
24 199 47 212 22 160
31 210 30 151