Task: Descriptive Statistics and Data Visualizations

Task: Descriptive Statistics and Data Visualizations

ORDER CUSTOM, PLAGIARISM-FREE PAPERS ON Task: Descriptive Statistics and Data Visualizations

Note: You are strongly encouraged to complete the assessments in this course in the order they are presented.

Descriptive statistics play an important role in analyzing data. It numerically summarizes key characteristics of variables. Measures of central tendency (mean, median, and mode) and dispersion (variance, standard deviation, and range) characterize the probability distribution. A histogram visualizes the distribution of numerical data indicating the number of data points that lie within a range of values. For this assessment, you will perform descriptive statistics and create a histogram for selected variables in a dataset.

Asssessment Instructions

Note: Complete the assessments in this course in the order in which they are presented.

DATA ANALYSIS SOFTWARE

To complete the assessments in this course, you will need to use data analysis software to complete statistical calculations, create graphs, and tabular summaries, and share your results in a Microsoft Word document. You will use Microsoft Excel and Microsoft Excel Analysis ToolPak add-in. Be aware that not all statistical calculations, graphs, and tabular summaries can be completed in this software, so you may need to do some work outside of the software.

Microsoft Excel Data Analysis ToolPak Add-In for PC and Mac

Microsoft Excel Analysis ToolPak Activation for PC Users: The Microsoft Excel Analysis ToolPak is a specialized Excel add-in included in the standard Microsoft Office suite. If your Excel software meets the standard Capella University Computer Requirements, you will not need to purchase this software. However, you may need to activate the application before you can use it. If you do not own Microsoft Excel, Capella arranges for a significant discount for Microsoft Office for Capella learners.

The following provides an overview of the Analysis ToolPak, instructions for loading and activation and instructions on using the ToolPak to perform data analysis. Note that these instructions are for 2016 and older versions of Microsoft Excel for PC and for the 2016 version only for Mac. If you are using a different version, you may need to search Microsoft’s website for the appropriate instructions.

PREPARATION

Download the Assessment 1 Dataset [XLSX].

The dataset contains the following variables:

  • utilization (average number of patient days per month).
  • satisfaction (patient satisfaction scores percentile rank).
  • readmissions (readmission rate per month).

INSTRUCTIONS

Nursing home administration has the objectives of higher utilization, higher patient satisfaction, and lower readmissions, and they need to make a decision on whether to retain the department manager based on average performance over the past 70 months. For this assessment, create a descriptive statistics table and histogram based on the Assessment 1 Dataset. Write a narrative summary in a Word and insert the table and histogram graphic into this document. See Copy From Excel to Another Office Program for instructions. Submit both the Word document and the Excel file that shows the descriptive statistics output.

Task: Descriptive Statistics and Data Visualizations

Unformatted Attachment Preview

utilization satisfactionreadmissions 74.27057 100 0.084485 63.99188 16 0.177423 98.59192 31 0.164667 83.83318 3 0.178409 102.6872 89 0.007154 67.99378 22 0.150899 46.14154 19 0.044172 43.72361 29 0.048756 57.88714 79 0.165101 67.59221 59 0.142432 86.79082 70 0.020972 97.85154 26 0.064269 65.94915 22 0.126403 68.7699 51 0.160362 73.48808 10 0.143454 44.06588 52 0.117126 21.39799 8 0.096196 63.73128 6 0.058184 60.3591 21 0.122917 104.9315 35 0.124026 44.06642 19 0.068038 74.79688 19 0.094528 73.80654 12 0.147442 74.13603 7 0.098442 53.15719 45 0.207075 37.7386 71 0.036068 56.67985 6 0.104524 34.09113 62 0.118022 82.18294 57 0.207321 117.4468 55 0.145666 72.63796 69 0.089209 66.48575 99 0.101125 60.31853 78 0.075609 97.4345 60 0.150218 55.71568 74 0.124018 78.65189 37 0.124208 101.5713 15 0.187252 65.80222 11 0.026605 76.79661 11 0.10254 73.13039 96 0.075294 44.72086 29 0.056506 98.73114 96 0.048891 33.8434 83 0.174334 84.88798 78 0.131844 52.40842 96 0.167126 57.31398 81 0.112467 52.43385 65.57764 83.33311 43.04142 37.8057 74.8687 69.84653 65.56504 60.51123 71.25343 54.01618 51.56944 66.47474 110.626 35.71084 107.777 73.49521 96.69419 105.5554 64.83288 61.43368 69.81598 114.9896 87.70982 70 99 96 91 58 38 59 79 88 38 13 54 35 63 56 22 90 28 8 94 78 7 27 50 0.061826 0.131735 0.081496 0.099062 0.073216 0.144065 0.042271 0.030994 0.119027 0.180316 0.08865 0.106493 0.022939 0.162756 0.098004 0.078145 0.065701 0.119516 0.103598 0.015921 0.123979 0.114584 0.081302 0.10172 …

You must proofread your paper. But do not strictly rely on your computer’s spell-checker and grammar-checker; failure to do so indicates a lack of effort on your part and you can expect your grade to suffer accordingly. Papers with numerous misspelled words and grammatical mistakes will be penalized. Read over your paper – in silence and then aloud – before handing it in and make corrections as necessary. Often it is advantageous to have a friend proofread your paper for obvious errors. Handwritten corrections are preferable to uncorrected mistakes.

Use a standard 10 to 12 point (10 to 12 characters per inch) typeface. Smaller or compressed type and papers with small margins or single-spacing are hard to read. It is better to let your essay run over the recommended number of pages than to try to compress it into fewer pages.

Likewise, large type, large margins, large indentations, triple-spacing, increased leading (space between lines), increased kerning (space between letters), and any other such attempts at “padding” to increase the length of a paper are unacceptable, wasteful of trees, and will not fool your professor.

The paper must be neatly formatted, double-spaced with a one-inch margin on the top, bottom, and sides of each page. When submitting hard copy, be sure to use white paper and print out using dark ink. If it is hard to read your essay, it will also be hard to follow your argument.

ADDITIONAL INSTRUCTIONS FOR THE CLASS

Discussion Questions (DQ)

Initial responses to the DQ should address all components of the questions asked, include a minimum of one scholarly source, and be at least 250 words.
Successful responses are substantive (i.e., add something new to the discussion, engage others in the discussion, well-developed idea) and include at least one scholarly source.
One or two sentence responses, simple statements of agreement or “good post,” and responses that are off-topic will not count as substantive. Substantive responses should be at least 150 words.
I encourage you to incorporate the readings from the week (as applicable) into your responses.

Weekly Participation

Your initial responses to the mandatory DQ do not count toward participation and are graded separately.
In addition to the DQ responses, you must post at least one reply to peers (or me) on three separate days, for a total of three replies.
Participation posts do not require a scholarly source/citation (unless you cite someone else’s work).
Part of your weekly participation includes viewing the weekly announcement and attesting to watching it in the comments. These announcements are made to ensure you understand everything that is due during the week.

APA Format and Writing Quality

Familiarize yourself with APA format and practice using it correctly. It is used for most writing assignments for your degree. Visit the Writing Center in the Student Success Center, under the Resources tab in LoudCloud for APA paper templates, citation examples, tips, etc. Points will be deducted for poor use of APA format or absence of APA format (if required).
Cite all sources of information! When in doubt, cite the source. Paraphrasing also requires a citation.
I highly recommend using the APA Publication Manual, 6th edition.

Use of Direct Quotes

I discourage overutilization of direct quotes in DQs and assignments at the Masters’ level and deduct points accordingly.
As Masters’ level students, it is important that you be able to critically analyze and interpret information from journal articles and other resources. Simply restating someone else’s words does not demonstrate an understanding of the content or critical analysis of the content.
It is best to paraphrase content and cite your source.

LopesWrite Policy

For assignments that need to be submitted to LopesWrite, please be sure you have received your report and Similarity Index (SI) percentage BEFORE you do a “final submit” to me.
Once you have received your report, please review it. This report will show you grammatical, punctuation, and spelling errors that can easily be fixed. Take the extra few minutes to review instead of getting counted off for these mistakes.
Review your similarities. Did you forget to cite something? Did you not paraphrase well enough? Is your paper made up of someone else’s thoughts more than your own?
Visit the Writing Center in the Student Success Center, under the Resources tab in LoudCloud for tips on improving your paper and SI score.

Late Policy

The university’s policy on late assignments is 10% penalty PER DAY LATE. This also applies to late DQ replies.
Please communicate with me if you anticipate having to submit an assignment late. I am happy to be flexible, with advance notice. We may be able to work out an extension based on extenuating circumstances.
If you do not communicate with me before submitting an assignment late, the GCU late policy will be in effect.
I do not accept assignments that are two or more weeks late unless we have worked out an extension.
As per policy, no assignments are accepted after the last day of class. Any assignment submitted after midnight on the last day of class will not be accepted for grading.

Communication

Communication is so very important. There are multiple ways to communicate with me:
Questions to Instructor Forum: This is a great place to ask course content or assignment questions. If you have a question, there is a good chance one of your peers does as well. This is a public forum for the class.
Individual Forum: This is a private forum to ask me questions or send me messages. This will be checked at least once every 24 hours. Task: Descriptive Statistics and Data Visualizations

 Task: Descriptive Statistics and Data Visualizations