Creating a meaningful statistical data analysis for a dataset
keneth 1
qualityimprovementpresentation.xlsxInstructions
| Instructions: |
| Please evaluate, display, and interpret the attached dataset (tab=Data) |
| Your results and discussions should be created and entered on additional worksheets within this Excel file. |
| Notes: |
| Please use descriptive and inferential statistics as well as generally accepted continuous quality improvement (CQI) tools, i.e., charts, tables, and graphs, for evaluation purposes. |
| Please display and interpret the data using easy to understand format(s) |
| Please tell a story that the data presents to exective leadership |
Data
| Sample Dataset | |
| WeekOfYear | MembersSeenInOffice |
| 1 | 212 |
| 2 | 200 |
| 3 | 195 |
| 4 | 169 |
| 5 | 195 |
| 6 | 229 |
| 7 | 182 |
| 8 | 195 |
| 9 | 179 |
| 10 | 174 |
| 11 | 216 |
| 12 | 186 |
| 13 | 184 |
| 14 | 221 |
| 15 | 196 |
| 16 | 199 |
| 17 | 205 |
| 18 | 210 |
| 19 | 213 |
| 20 | 186 |
| 21 | 210 |
| 22 | 225 |
| 23 | 180 |
| 24 | 197 |
| 25 | 199 |
| 26 | 212 |
| 27 | 221 |
| 28 | 226 |
| 29 | 201 |
| 30 | 212 |
| 31 | 213 |
| 32 | 213 |
| 33 | 208 |
| 34 | 189 |
| 35 | 208 |
| 36 | 184 |
| 37 | 179 |
| 38 | 181 |
| 39 | 196 |
| 40 | 188 |
| 41 | 198 |
| 42 | 200 |
| 43 | 185 |
| 44 | 201 |
| 45 | 217 |
| 46 | 203 |
| 47 | 202 |
| 48 | 195 |
| 49 | 225 |
| 50 | 178 |
| 51 | 190 |
| 52 | 199 |
