Nurse 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Hospital Private VA University Private University Private University Private University Private Private University VA University Private Private Private University Private VA VA VA Private VA VA Private Private VA VA Private VA Private University VA University Private University VA Private VA Work 74 72 75 89 69 85 89 88 88 84 90 72 82 90 64 85 71 71 70 71 90 73 72 65 94 84 71 72 84 82 90 88 74 78 85 74 76 82 77 63 Pay 47 76 53 66 47 56 80 36 55 42 62 59 37 56 43 57 25 36 38 49 27 56 60 42 60 28 45 37 60 49 76 49 70 52 89 59 51 60 60 48 Promotion 63 37 92 62 16 64 64 47 52 66 66 79 54 23 61 67 74 55 54 58 67 55 45 68 52 62 68 86 29 91 70 42 51 72 46 82 54 56 75 78 41 42 43 44 45 46 47 48 49 50 VA University VA Private University University University VA VA Private 86 77 86 87 79 84 87 84 95 72 72 90 37 51 59 53 66 74 66 57 72 51 59 57 41 63 49 37 52 40 DO NOT POST HERE! SUBMIT IN ASSIGNMENT AREA. Exercise 1 (National Health Care Association). The raw data have been included the file here (attached) Read the instructions CAREFULLY! Also, have empathy toward your reader and your audience (management decision makers). Those who do well on this assignment are usually not because they are in good math but are good writers. As yourself, is there anything in my writing, analysis that could confuse the reader? If so fix it. Also, a common mistake is to write like you are in a stat class explaining basic concepts. No, write like you are a professional writing to make your analysis understandable by management. Your purpose is to take all this data and to make sense of it not for the math person but for the manager or decision maker. Be clear in your writing. Be as simple in your writing as possible but do use the proper terms in the book not fuzzy words like \"average\" (don't use it) but such as mean, median, mode or whatever term. Why this assignment? This is not a math class but a course to teach you not only to use the various stat tools but to use them correctly and then to communicate effectively the results that you obtain from tools not from the perspective of a mathematician but that of a professional manager or researcher. Writing clearly and accurately about the data you have analyzed is a skill that takes practice. Do pretend this is a professional report and not a math assignment. Make it easy and clear for the reader!! The Grading Rubric: See the grading rubric in assignments. Exercise #1: National Healthcare Association Use the attached Excel file to do the analysis. You will submit in the assignment area a Word document that is your management report to the CEO (me in this case) and the Excel file with your calculations. Your Word file should be a well-written analysis of the questions below. Do label clearly per the provided template at the end of this document! Your Word should document should have the format that is at the end of the document. Replace my name with your name, and delete all red text which are just instructions, DO bring in the appropriate descriptive (graphical and numeric) statistics to illustrate and back up your answer (do not skimp on these!). Poor papers just assume that somehow the reader can read the writers mind or somehow the writer's conclusions are self-evident. Do not just say refer to the Excel file! From my experience, you should be able to do the assignment in three to four pages or less but a paragraph will probably be insufficient. Use the numbers! Background The National Health Care Association faces a projected shortage of nurses in the health care profession. To learn the current degree of job satisfaction among nurses, the association sponsored a study of hospital nurses throughout the country. As part of this study, a sample of 50 nurses indicated their degree of satisfaction with their work, their pay and their opportunities for promotion. Each of the three aspects of satisfaction was measured on a scale from 0 to 100, with larger values for higher degrees of satisfaction. The data collected also showed the type of hospital employing the nurses. The types of hospital were private (P), Veterans Administration (VA), and University (U) (see the data in the Excel spreadsheet). Hint: think about the fact you have three different types of hospitals. Assignment Questions/tasks (Use Managerial Report template below): 1. Descriptive statistics. You will use both numeric and graphic (at least three) descriptive statistics as discussed in the red text in the template below (delete all red text in your submission). 2. On the basis of the entire data set and the three job satisfaction variables, what aspect of the job is most satisfying for the nurses? What appears to be the least satisfying? In what area(s), if any, do you feel improvements should be made? Discuss and provide appropriate descriptive statistics. 3. On the basis of descriptive measures of variability what measures of job satisfaction appears to generate the greatest difference of opinion among the nurses? Explain and illustrate appropriately. 4. What can be learned about the types of hospitals? Does any particular type of hospital seem to have better levels of job satisfaction that the other types? Do your results suggest any recommendations for learning about and/or improving job satisfaction? Discuss and provide appropriate descriptive statistics from part1. 5. What additional descriptive statistics (besides mean, median, mode, histograms, etc. that you used in this report) and insights can you use to learn about and possibly improve job satisfaction? Explain why these additional descriptive stats might help you gain additional insight. For example, if you picked quartiles (numeric descriptive stats) and line graph (graphic descriptive stats) that you didn't use in your report explain how these particular ones might provide a little more insight (quartiles and line graphs) just an example of the many additional ones). Hints on improving your assignment: You are using statistics as a communications tool. You need to bring in the highlights of your results into the body of your report. You did need effectively communicate your results by leaving including important descriptive methods in the narrative but without "throwing everything in but the kitchen sink". Include the appropriate graphical and tabular method and bring in some of the important data in your report and keep your Excel for the raw data and calculations. DO NOT state your conclusions without backing up with summaries and graphical methods in your narrative Word document-management will not like it! Remember this is a communications and management document. Do use the proper terms use the book as a template and use professional terms: for example, if don't say average but mean, medium, or mode. Use this template on the next page. National Health Care Association Analysis by Tony Kendall 1. Descriptive Statistics a. Descriptive stats: Numeric In 1a. use as many descriptive stats as possible (remember to delete this and all red text)! These include the ones you've learned in the textbook including mean, median, mode, standard deviation, and range. The best way is to create tables such as one of a summary for all nurses and then another table broken out by categories. As you notice below I have done two Labels, first Table 1 and also a useful Heading, Descriptive Statistics by Category. Make it a point to clearly label both numeric and graphical descriptive statistics. In the example below I got you started by be sure to add more than mean, median, mode for your descriptive stats. I would also suggest a summary table or if you can do it add it to the table below. I will not be more specific because part of this assignment is to use descriptive stats. Table 1: \"your description of table or figure, etc\" Job Satisfaction with: Work Pay Mean Median Mode Numeric Stat 4 Numeric Stat 6 Number Stat etc. b. Descriptive stats: Graphic Promotion At the very least you need at least two histograms and perhaps one bar chart. Histograms are for quantitative data and bar charts for qualitative (categorical data). Do not make the mistake of mixing the two! You should have at least 3 other types of descriptive graphic charts besides histograms. As with 1a, avoid losing points and confusing the reader by making sure you label such as Figure 1: Histogram of Job Satisfaction for Work. Make the charts and text big enough so the reader can, well read your chart. It's back to respect the reader and have empathy towards him or her. c. Descriptive stats: Summary Just briefly explain both your types of your descriptive stats (1a, 1b) in a paragraph and a brief summary of your results. What were the measure units, explain what the numbers are measuring, for example are these percents, percentiles or what. How did you conduct the survey, the scope, what, where, when or you collected the data (if the case tells you). Just a summary of the basic results as you will explain them in detail in other sections. 2. On the basis of the entire data set and the three job satisfaction variables, what aspect of the job is most satisfying for the nurses? What appears to be the least satisfying? In what area(s), if any, do you feel improvements should be made? Discuss and provide appropriate descriptive statistics. For each question do include the question itself as I've done above. You answer the questions above by referring to your descriptive stats you have included in part 1. If you are missing a descriptive stat needed to answer part 2 then go back to part 1a or 1b and add the appropriate descriptive stat (graph or numeric). When you answer the question don't be vague or have no empathy toward the reader and just expect him to forge for the data herself...that's your job to make it easy. For example, the wrong way: \"Pay was the aspect of the job that was the most satisfying for the nurses.\" Still wrong: \"\"Pay was the aspect of the job the most satisfying for the nurses at 75.\" Make it a goal in this course that whenever you use a number you state the units such as $, inches, pounds, cubic meters, etc. Here is a better way (clear citing technique) \"As seen in Table 2 and figure 1, pay was the aspect of the job that was the most satisfying for the nurses with a rating score 75 (75 out of 100).\" You would not have to put \"(75 out of 100) if you explain the nature of the data in 1c. You can modify the above as appropriate but don't make the reader try to guess or work to find the data that you have based your conclusions. 3. On the basis of descriptive measures of variability what measures of job satisfaction appears to generate the greatest difference of opinion among the nurses? Explain and illustrate appropriately by citing part 1. As with part 2, answer the question above and bring in descriptive stats from part 1 as appropriate and use clear citing techniques as discussed previously. 4. What can be learned about the types of hospitals? Does any particular type of hospital seem to have better levels of job satisfaction that the other types? Do your results suggest any recommendations for learning about and/or improving job satisfaction? Discuss and provide appropriate descriptive statistics from part1. As with parts 2 and 3, answer the question above and bring in descriptive stats from part 1 as appropriate and use clear citing techniques as discussed previously. DO NOT POST HERE! SUBMIT IN ASSIGNMENT AREA. Exercise 1 (National Health Care Association). The raw data have been included the file here (attached) Read the instructions CAREFULLY! Also, have empathy toward your reader and your audience (management decision makers). Those who do well on this assignment are usually not because they are in good math but are good writers. As yourself, is there anything in my writing, analysis that could confuse the reader? If so fix it. Also, a common mistake is to write like you are in a stat class explaining basic concepts. No, write like you are a professional writing to make your analysis understandable by management. Your purpose is to take all this data and to make sense of it not for the math person but for the manager or decision maker. Be clear in your writing. Be as simple in your writing as possible but do use the proper terms in the book not fuzzy words like \"average\" (don't use it) but such as mean, median, mode or whatever term. Why this assignment? This is not a math class but a course to teach you not only to use the various stat tools but to use them correctly and then to communicate effectively the results that you obtain from tools not from the perspective of a mathematician but that of a professional manager or researcher. Writing clearly and accurately about the data you have analyzed is a skill that takes practice. Do pretend this is a professional report and not a math assignment. Make it easy and clear for the reader!! The Grading Rubric: See the grading rubric in assignments. Exercise #1: National Healthcare Association Use the attached Excel file to do the analysis. You will submit in the assignment area a Word document that is your management report to the CEO (me in this case) and the Excel file with your calculations. Your Word file should be a well-written analysis of the questions below. Do label clearly per the provided template at the end of this document! Your Word should document should have the format that is at the end of the document. Replace my name with your name, and delete all red text which are just instructions, DO bring in the appropriate descriptive (graphical and numeric) statistics to illustrate and back up your answer (do not skimp on these!). Poor papers just assume that somehow the reader can read the writers mind or somehow the writer's conclusions are self-evident. Do not just say refer to the Excel file! From my experience, you should be able to do the assignment in three to four pages or less but a paragraph will probably be insufficient. Use the numbers! Background The National Health Care Association faces a projected shortage of nurses in the health care profession. To learn the current degree of job satisfaction among nurses, the association sponsored a study of hospital nurses throughout the country. As part of this study, a sample of 50 nurses indicated their degree of satisfaction with their work, their pay and their opportunities for promotion. Each of the three aspects of satisfaction was measured on a scale from 0 to 100, with larger values for higher degrees of satisfaction. The data collected also showed the type of hospital employing the nurses. The types of hospital were private (P), Veterans Administration (VA), and University (U) (see the data in the Excel spreadsheet). Hint: think about the fact you have three different types of hospitals. Assignment Questions/tasks (Use Managerial Report template below): 1. Descriptive statistics. You will use both numeric and graphic (at least three) descriptive statistics as discussed in the red text in the template below (delete all red text in your submission). Refer to these illustrations as you answer the following questions. 2. On the basis of the entire data set and the three job satisfaction variables, what aspect of the job is most satisfying for the nurses? What appears to be the least satisfying? In what area(s), if any, do you feel improvements should be made? Discuss and provide appropriate descriptive statistics. 3. On the basis of descriptive measures of variability what measures of job satisfaction appears to generate the greatest difference of opinion among the nurses? Explain and illustrate appropriately. 4. What can be learned about the types of hospitals? Does any particular type of hospital seem to have better levels of job satisfaction that the other types? Do your results suggest any recommendations for learning about and/or improving job satisfaction? Discuss and provide appropriate descriptive statistics from part1. 5. What additional descriptive statistics (besides mean, median, mode, histograms, etc. that you used in this report) and insights can you use to learn about and possibly improve job satisfaction? Explain why these additional descriptive stats might help you gain additional insight. For example, if you picked quartiles (numeric descriptive stats) and line graph (graphic descriptive stats) that you didn't use in your report explain how these particular ones might provide a little more insight (quartiles and line graphs) just an example of the many additional ones). Hints on improving your assignment: You are using statistics as a communications tool. You need to bring in the highlights of your results into the body of your report. You did need effectively communicate your results by leaving including important descriptive methods in the narrative but without "throwing everything in but the kitchen sink". Include the appropriate graphical and tabular method and bring in some of the important data in your report and keep your Excel for the raw data and calculations. DO NOT state your conclusions without backing up with summaries and graphical methods in your narrative Word document-management will not like it! Remember this is a communications and management document. Do use the proper terms use the book as a template and use professional terms: for example, if don't say average but mean, medium, or mode. Use this template on the next page. National Health Care Association Analysis by Tony Kendall 1. Descriptive Statistics a. Descriptive stats: Numeric In 1a. use as many descriptive stats as possible (remember to delete this and all red text)! These include the ones you've learned in the textbook including mean, median, mode, standard deviation, and range. The best way is to create tables such as one of a summary for all nurses and then another table broken out by categories. As you notice below I have done two Labels, first Table 1 and also a useful Heading, Descriptive Statistics by Category. Make it a point to clearly label both numeric and graphical descriptive statistics. In the example below I got you started by be sure to add more than mean, median, mode for your descriptive stats. I would also suggest a summary table or if you can do it add it to the table below. I will not be more specific because part of this assignment is to use descriptive stats. Table\t1:\t\"your\tdescription\tof\ttable\tor\tfigure,\tetc\" Job\tSatisfaction\twith: Work Pay Promotion Mean Median Mode Numeric\tStat\t4 Numeric\tStat\t6 Number\tStat\tetc. b. Descriptive stats: Graphic At the very least you need at least two histograms and perhaps one bar chart. Histograms are for quantitative data and bar charts for qualitative (categorical data). Do not make the mistake of mixing the two! You should have at least 3 other types of descriptive graphic charts besides histograms. As with 1a, avoid losing points and confusing the reader by making sure you label such as Figure 1: Histogram of Job Satisfaction for Work. Make the charts and text big enough so the reader can, well read your chart. It's back to respect the reader and have empathy towards him or her. c. Descriptive stats: Summary Just briefly explain both your types of your descriptive stats (1a, 1b) in a paragraph and a brief summary of your results. What were the measure units, explain what the numbers are measuring, for example are these percents, percentiles or what. How did you conduct the survey, the scope, what, where, when or you collected the data (if the case tells you). Just a summary of the basic results as you will explain them in detail in other sections. 2. On the basis of the entire data set and the three job satisfaction variables, what aspect of the job is most satisfying for the nurses? What appears to be the least satisfying? In what area(s), if any, do you feel improvements should be made? Discuss and provide appropriate descriptive statistics. For each question do include the question itself as I've done above. You answer the questions above by referring to your descriptive stats you have included in part 1. If you are missing a descriptive stat needed to answer part 2 then go back to part 1a or 1b and add the appropriate descriptive stat (graph or numeric). When you answer the question don't be vague or have no empathy toward the reader and just expect him to forge for the data herself...that's your job to make it easy. For example, the wrong way: \"Pay was the aspect of the job that was the most satisfying for the nurses.\" Still wrong: \"\"Pay was the aspect of the job the most satisfying for the nurses at 75.\" Make it a goal in this course that whenever you use a number you state the units such as $, inches, pounds, cubic meters, etc. Here is a better way (clear citing technique) \"As seen in Table 2 and figure 1, pay was the aspect of the job that was the most satisfying for the nurses with a rating score 75 (75 out of 100).\" You would not have to put \"(75 out of 100) if you explain the nature of the data in 1c. You can modify the above as appropriate but don't make the reader try to guess or work to find the data that you have based your conclusions. 3. On the basis of descriptive measures of variability what measures of job satisfaction appears to generate the greatest difference of opinion among the nurses? Explain and illustrate appropriately by citing part 1. As with part 2, answer the question above and bring in descriptive stats from part 1 as appropriate and use clear citing techniques as discussed previously. 4. What can be learned about the types of hospitals? Does any particular type of hospital seem to have better levels of job satisfaction that the other types? Do your results suggest any recommendations for learning about and/or improving job satisfaction? Discuss and provide appropriate descriptive statistics from part1. As with parts 2 and 3, answer the question above and bring in descriptive stats from part 1 as appropriate and use clear citing techniques as discussed previously