Question
This is my assignment for this week. I am excel illiterate and am unsure how to do most of this. Any help would be appreciated.
This is my assignment for this week. I am excel illiterate and am unsure how to do most of this. Any help would be appreciated.
My research project is based on a drug study. The independent variable is the drug doses, and the dependent variable is the amount of weight lost. Would I have to do three different templates for each drug dose?
Test DataSubject | 10mg dose | Subject | 20mg dose | Subject | 30mg dose |
1 | 3 | 101 | 9 | 201 | 13 |
2 | 6 | 102 | 8 | 202 | 25 |
3 | 4 | 103 | 12 | 203 | 22 |
4 | 1 | 104 | 8 | 204 | 14 |
5 | 4 | 105 | 11 | 205 | 17 |
6 | 3 | 106 | 9 | 206 | 12 |
7 | 2 | 107 | 11 | 207 | 25 |
8 | 6 | 108 | 11 | 208 | 25 |
9 | 2 | 109 | 11 | 209 | 18 |
10 | 2 | 110 | 6 | 210 | 22 |
11 | 4 | 111 | 13 | 211 | 18 |
12 | 5 | 112 | 8 | 212 | 21 |
13 | 2 | 113 | 8 | 213 | 22 |
14 | 5 | 114 | 11 | 214 | 14 |
15 | 7 | 115 | 12 | 215 | 12 |
16 | 8 | 116 | 13 | 216 | 22 |
17 | 7 | 117 | 12 | 217 | 15 |
18 | 3 | 118 | 10 | 218 | 25 |
19 | 7 | 119 | 11 | 219 | 21 |
20 | 7 | 120 | 13 | 220 | 15 |
21 | 8 | 121 | 8 | 221 | 19 |
22 | 7 | 122 | 8 | 222 | 17 |
23 | 6 | 123 | 8 | 223 | 20 |
24 | 2 | 124 | 13 | 224 | 15 |
25 | 4 | 125 | 6 | 225 | 20 |
26 | 4 | 126 | 8 | 226 | 13 |
27 | 8 | 127 | 11 | 227 | 21 |
28 | 8 | 128 | 12 | 228 | 23 |
29 | 7 | 129 | 6 | 229 | 12 |
30 | 2 | 130 | 8 | 230 | 26 |
31 | 3 | 131 | 12 | 231 | 12 |
32 | 1 | 132 | 7 | 232 | 18 |
33 | 8 | 133 | 10 | 233 | 14 |
34 | 8 | 134 | 7 | 234 | 22 |
35 | 3 | 135 | 12 | 235 | 14 |
36 | 6 | 136 | 7 | 236 | 20 |
37 | 3 | 137 | 10 | 237 | 14 |
38 | 1 | 138 | 12 | 238 | 19 |
39 | 8 | 139 | 8 | 239 | 12 |
40 | 3 | 140 | 6 | 240 | 16 |
41 | 5 | 141 | 7 | 241 | 18 |
42 | 5 | 142 | 11 | 242 | 20 |
43 | 5 | 143 | 6 | 243 | 22 |
44 | 3 | 144 | 7 | 244 | 18 |
45 | 4 | 145 | 7 | 245 | 16 |
46 | 1 | 146 | 11 | 246 | 21 |
47 | 5 | 147 | 8 | 247 | 26 |
48 | 8 | 148 | 9 | 248 | 15 |
49 | 6 | 149 | 6 | 249 | 12 |
50 | 8 | 150 | 6 | 250 | 15 |
51 | 1 | 151 | 11 | 251 | 18 |
52 | 7 | 152 | 13 | 252 | 13 |
53 | 2 | 153 | 13 | 253 | 23 |
54 | 3 | 154 | 7 | 254 | 13 |
55 | 7 | 155 | 10 | 255 | 23 |
56 | 3 | 156 | 6 | 256 | 25 |
57 | 5 | 157 | 13 | 257 | 26 |
58 | 5 | 158 | 12 | 258 | 14 |
59 | 5 | 159 | 13 | 259 | 18 |
60 | 8 | 160 | 11 | 260 | 21 |
61 | 7 | 161 | 7 | 261 | 25 |
62 | 6 | 162 | 6 | 262 | 25 |
63 | 4 | 163 | 12 | 263 | 15 |
64 | 8 | 164 | 6 | 264 | 24 |
65 | 5 | 165 | 12 | 265 | 14 |
66 | 8 | 166 | 7 | 266 | 21 |
67 | 3 | 167 | 12 | 267 | 12 |
68 | 6 | 168 | 7 | 268 | 12 |
69 | 7 | 169 | 11 | 269 | 14 |
70 | 7 | 170 | 8 | 270 | 12 |
71 | 5 | 171 | 7 | 271 | 13 |
72 | 6 | 172 | 11 | 272 | 22 |
73 | 7 | 173 | 13 | 273 | 21 |
74 | 8 | 174 | 9 | 274 | 16 |
75 | 2 | 175 | 6 | 275 | 15 |
76 | 7 | 176 | 12 | 276 | 21 |
77 | 4 | 177 | 8 | 277 | 16 |
78 | 2 | 178 | 11 | 278 | 14 |
79 | 6 | 179 | 7 | 279 | 21 |
80 | 3 | 180 | 12 | 280 | 22 |
81 | 2 | 181 | 7 | 281 | 14 |
82 | 6 | 182 | 7 | 282 | 13 |
83 | 5 | 183 | 11 | 283 | 16 |
84 | 5 | 184 | 8 | 284 | 25 |
85 | 8 | 185 | 12 | 285 | 16 |
86 | 4 | 186 | 9 | 286 | 14 |
87 | 8 | 187 | 13 | 287 | 21 |
88 | 1 | 188 | 6 | 288 | 21 |
89 | 7 | 189 | 13 | 289 | 19 |
90 | 4 | 190 | 9 | 290 | 18 |
91 | 6 | 191 | 11 | 291 | 26 |
92 | 4 | 192 | 11 | 292 | 16 |
93 | 6 | 193 | 7 | 293 | 23 |
94 | 8 | 194 | 9 | 294 | 15 |
95 | 6 | 195 | 8 | 295 | 24 |
96 | 7 | 196 | 9 | 296 | 22 |
97 | 2 | 197 | 12 | 297 | 24 |
98 | 5 | 198 | 9 | 298 | 16 |
99 | 2 | 199 | 13 | 299 | 15 |
100 | 2 | 200 | 9 | 300 | 20 |
CreateaMicrosoftExcelspreadsheet with the two variables from your learning team's dataset.
Analyzethe data with MicrosoftExcelor other statistical tool(s), including:
- Descriptive stats for each numeric variable
- Histogram for each numeric variable
- Bar chart for each attribute (non numeric) variable
- Scatter plot if the data contains two numeric variables
Determinethe appropriate descriptive statistics.
- For normally distributed data use the mean and standard deviation.
- For significantly skewed data use the median and interquartile range.
UsetheIndividual Methodology Findings Templateto complete the descriptive statistics. UsetheDescriptive Statistics and Interpretation Exampleto develop an interpretation of the descriptive statistics.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started