[See Steps] Calculate the following for each variable (except gender): MEAN MEDIAN MODE RANGE (Use the MIN MAX functions to calculate) VARIANCE STD DEV Patient


Question: Calculate the following for each variable (except gender):

MEAN

MEDIAN

MODE

RANGE (Use the MIN & MAX functions to calculate)

VARIANCE

STD DEV

Patient ID Age Gender Baseline
Triglycerides
1st Interim
Triglycerides
2nd Interim
Triglycerides
3rd Interim
Triglycerides
Final Triglycerides Baseline Weight 1st Interim Weight 2nd Interim Weight 3rd Interim Weight Final Weight
1 45 0 180 148 106 113 100 198 196 193 188 192
2 56 0 139 94 119 75 92 237 233 232 228 225
3 50 0 152 185 86 149 118 233 231 229 228 226
4 46 1 112 145 136 149 82 179 181 177 174 172
5 64 0 156 104 157 79 97 219 217 215 213 214
6 49 1 167 138 88 107 171 169 166 165 162 161
7 63 0 138 132 146 143 132 222 219 215 215 210
8 63 1 160 128 150 118 123 167 167 166 162 161
9 52 0 107 120 129 195 174 199 200 196 196 193
10 45 0 156 103 126 135 92 233 229 229 229 226
11 61 1 94 144 114 114 121 179 181 176 173 173
12 49 1 107 93 156 148 150 158 153 155 155 154
13 61 1 145 107 129 86 159 157 151 150 145 143
14 59 0 186 142 128 122 101 216 213 210 210 206
15 52 0 112 107 103 89 148 257 255 254 252 249
16 60 1 104 103 117 79 130 151 146 144 144 140
  1. Explain why it is not appropriate to calculate these values for gender.
  2. Did weight increase or decrease during the study?
  3. Did triglycerides increase or decrease from baseline to final measurement?
  4. For EACH variable:
  1. Which measure of central tendency is most representative?
  2. Is there a measure of central tendency that is not very representative? If yes, explain.

Price: $2.99
Solution: The downloadable solution consists of 5 pages
Deliverable: Word Document

log in to your account

Don't have a membership account?
REGISTER

reset password

Back to
log in

sign up

Back to
log in