Needs help. For the heights and weights in the spreedsheets, find the mean and s

Question

Needs help. For the heights and weights in the spreedsheets, find the mean and standard deviation. 2 1 FEMALE AGE HT WT WAIST PULSE SYS DIAS CHOL BMI LEG ELBOW WRIST ARM 76 104 61 264 19.6 41.6 295 17 64.3 114.867.2 2739 32 664 149.3 82.5729964 181 23.8 42.86.75.5 26.3 299225. 62.3L-107.8 667 88| 102 65| 267.-19.6, 390.-5.7-.-4.6-26.3 3745 55 62.3 160.1 93.0 4486 27 59.6 127.182.6 4488 29 63.6 123.1 75.468 101 66 62 21.4 43.2 6.0 4.9 26.4 4878-25, 59.8 111.7 73.6 4880 12 63.3156.381.4 4881 41 679 218.8 99.468 123 72 531 33.5 43.8 78 5.8 38.6 483532 61.4-110.2, 67.7 689361 13020.6 37.3 6.3 5.0 26.5 4842 31 66.7 188.3 100.780 89 56175 29.9 42.3 6.6 5.2 34 60 114 76 384 29.1 40.26.2 72. 94581 98252 362 64 104 4189 27.5 41.06.8 76 112 62 44 17.7 39.1 8680 19 63.1 136.1 85.0 8681 23 66.7 182.4 85.7 12348 40 66.8 238.4126.0 72 116 62112 28.9 48.6 96 181 102 462 37.7 33.2 17 14651 23 64.7 108.8745 72 98 6162 18.3 434 6.2 5.2 24.7 16767 27 65.1 119.0745 17765 45 61.9 161.994.0 68 100 53 98 19.8 41.5 6.35.3 72 127 74 447 29.8 40.0 6.8 20 19377 41 64.3 174.192.8 64 107 67 125 29.7 38.26.8 19378 56 63.4 181.2105.5 19382 22 60.7124.375.5 20278 57 63.4 255.9126.5 80 116 71 318 31.7 38.2 6.9 5.4 64 97 64 325 23.8 38.2 5.9 5.0 80 155 85 600 44.9 41.0 24 21626 24 62.6 106.7 70.076 106 59 237 19.2 38.1 25 32233 37 60.6149.998. 2633104 59 63.5 163.1104.77 076 110 70 173 28.7 38.0 7.0 5.1 34.3 76 105 69 309 28.5 36.0 6.7 5.1 33106 40 58.6 94.3 67.8 80 118 82 94 19.3 32.1 5.4 2833334 45 602 159.799.3 104 133 83 280 31.0 31.164 52 33335 52 676 162.891.1 34779 31 63.4 130.0 74.5 35035 32 64.1 179995.5 76 107 67596 30.9 39.2 6.2 35272 23 62.7 1478 79.5 72 95 59 301 26.5 39.0 35273 23 61.3 112.9 69.1 2 108 72 223 21.2 36.6 5.9 4.7 35505 47 58.2 1956 105.5 88 114 79 293 40.6 270 35506 36 63.2 1242 88 11375 254 25.1 39.4 60 113 66 123 22.8 40.259 5.1 27.0 6.3 4.9 31.0 78.8 85.7 80 104 73 146 21.9 38.5 5.6 4.7 25.5 60 125 73 149 26.0 39.964 52 309 3635507 34 60.5135.0 35984 37 650 1414 92.8 72 124 85 149 23.5 37.5 35988 18 61.8 1239 72.788 92 46 920 22.8 39.7 36115 29 68.0 135.5 75.988 119 81 271 20.7 39.0 6.3 4.9 27.8 4036502 48 67.0 1304 68.6 124 93 64 207 20.5 41.6 60 38089 16 57.0 100768.7 108 642 21.9 33.8564.6 26.4

Explanation / Answer

Given data is

      

Using Excel function

Mean=AVERAGE(heightvalues,weight values)

        =104.7075

Standard deviation=STDEV(heightvalues,weight values)

                           =49.4724

Height weight 64.3 114.8 66.4 149.3 62.3 107.8 62.3 160.1 59.6 127.1 63.6 123.1 59.8 111.7 63.3 156.3 67.9 218.8 61.4 110.2 66.7 188.3 64.8 105.4 63.1 136.1 66.7 182.4 66.8 238.4 64.7 108.8 65.1 119 61.9 161.9 64.3 174.1 63.4 181.2 60.7 124.3 63.4 255.9 62.6 106.7 60.6 149.9 63.5 163.1 58.6 94.3 60.2 159.7 67.6 162.8 63.4 130 64.1 179.9 62.7 147.8 61.3 112.9 58.2 195.6 63.2 124.2 60.5 135 65 141.4 61.8 123.9 68 135.5 67 130.4 57 100.7

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.