Create a histogram for the variable wait time in Excel:? Review this video to learn how to create a Histogram in ExcelLinks to an external site..? Extra Resource: Create

questions

each question has to be a different file

 

1.Create a histogram for the variable wait time in Excel: 

  • Review this video to learn how to create a Histogram in ExcelLinks to an external site.. 
  • Extra Resource: Create a histogramLinks to an external site.
  • Use the strategies in the video to create a frequency table of the wait time using the categories (or classes) of 0-20,  21-41, 42-62, 63 – 83, 84 or more minutes.
    • Tip: It may be helpful to sort the data based on the wait time variable first.
    • Don’t forget that you should have a column for “classes” and a column for “frequencies.”
  • Fill in the frequencies of each class.
  • After the frequency table is complete, highlight the frequency table, and select Insert, then Recommended Charts, and choose the column chart shown and select OK.
  • Right-click on one of the bars and select Format Data Series. In the pop-up box, change the Gap Width to 0.
  • Add an appropriate title and axis label.
  • Save the file to your computer again and upload the file by selecting the "Choose a File" button below

2.  Explain why a histogram would be used to represent the variable wait time versus a bar graph.  

3.  

Create a pie chart for the variable insurance in excel: 

Example Table

Here is an example of what your table should look like:  

ABInsuranceFrequencyBlue Cross Blue Shield{Type the number of those that have this insurance} Health Select{Type the number of those that have this insurance} 

NOTE: This is only an example of what your table should “look” like and how it should be organized. You should have many more insurance companies and the frequencies should be based on what you count (for each insurance company) from the main database.

  • Once completed, highlight all of the cells of your completed frequency table, by selecting and dragging your pointer through all of the cells. 
  • Select on Insert, and then Recommended Charts. 
  • Select to select the Pie Chart. 
  • Select on the pie slices, right-click Add Data Labels, and select Add Data Callouts. Add an appropriate title.
    • Make sure to highlight percentages on each sector.
    • For some of you, the options to add titles and format your pie chart are located in your toolbar(s); so, explore your own version of Excel
  • Save the worksheet to your computer and upload your file by selecting the "Choose a File" button below. 

4.  What is the most utilized insurance company among those that are surveyed in this database? Include the percentage to support your statement.  

5.  Create a bar graph for the variable satisfaction in excel: 

  • Review this video to learn how to create a bar graph in excel.Links to an external site.  
  • Use the strategies in the video to create a frequency table of the satisfaction levels using the categories: Completely Dissatisfied, Dissatisfied, Average, Satisfied, and Completely Satisfied.
    • Tip: It may be helpful to sort the data based on the satisfaction variable first.
    • Don’t forget that you should have a column for “Satisfaction Levels” and a column for “frequencies”.   
  • Fill in the frequencies of each category. 
  • After the frequency table is complete, highlight the frequency table, and select Insert, then Recommended Charts, and choose the column chart shown and select OK. 
  • Add an appropriate title and axis label. 
  • Save the file to your computer again and upload the file by selecting the "Choose a File" button below. 

6.  Make a statement based on the bar graph created. Research ideas on how satisfaction levels can be improved. Make sure to cite at least one source.  

7.  Looking at “Out of Pocket Pay”, what would be the best way to display this data? Why? What key points would you expect the viewer to extract from the graph?View keyboard shortcutsEditViewInsertFormatToolsTable12ptParagraph
 Looking at “Out of Pocket Pay”, what would be the best way to display this data? Why? What key points would you expect the viewer to extract from the graph?View keyboard shortcutsEditViewInsertFormatToolsTable12ptParagraph
 

Criteria

Ratings

Create a Histogram Using software (Excel, Numbers, Google Sheets, etc.)

7 Points

Proficient

Student created the Histogram correctly with the appropriate number of bars and class width.

5 Points

Above Average

Student created a Histogram with the correct number of bars, but the frequencies are incorrect due to an incorrect class width.

3 Points

Average

Student created a Histogram with the wrong number of bars, but it is based on the correct data.

2 Points Needs Improvement

The student created a Bar Graph (Did not fix gap width) or some other major mistakes were found such as drawing a graph on paper.

0 Points

No Effort

The student did not attach work for review OR the Histogram was made with the wrong data set.

Histogram Analysis

10 Points

Proficient

Student discusses key characteristics of why a Histogram is used versus a Bar Graph highlighting characteristics of both graphs.

7 Points

Above Average

Student discusses key characteristics of why a Histogram is used versus a Bar Graph but only highlights characteristics of a Histogram.

4 Points Needs Improvement

Student does not discuss key components of why a Histogram would be used versus a Bar Graph.

0 Points No Effort

The student does not have an answer for review.

Create a Pie Chart Using software (Excel, Numbers, Google Sheets, etc.)

7 Points

Proficient

Student created the Pie Chart correctly with the appropriate number of sectors, appropriate title, and percentage callouts.

5 Points

Above Average

Student created a Pie Chart with the correct number of sectors but is missing appropriate tile and/or percentage callouts. The pie chart is made

3 Points

Average

Student created a Pie Chart with the wrong number of sectors, but it is based on the correct data.

2 Points Needs Improvement

The student created use a different type of graph or some other major mistakes were found such as drawing a graph on paper.

0 Points

No Effort

The student did not attach work for review OR the pie chart was made with the wrong data set.

Pie Chart Analysis

10 Points Proficient

The student chooses the correct answer and highlights the percentage to support their answer.

7 Points Above Average

The student chooses the correct answer but does NOT highlight the percentage to support their answer.

5 Points

Average

The student chooses the incorrect answer but the pie chart was constructed correctly.

3 Points Needs Improvement

The student chooses the correct answer based on pie chart that was constructed incorrectly (based on the correct data).

0 Points No Effort

The student does not have an answer for review.

Create a Bar Graph Using software (Excel, Numbers, Google Sheets, etc.)

7 Points

Proficient

Student created the Bar Graph correctly with the appropriate number of bars, appropriate title and axis labels.

5 Points

Above Average

Student created a Bar Graph with the correct number of bars, but it is missing a tile or axis labels.

OR

The student changed the order of the bars which could make the graph Misleading.

3 Points

Average

Student created a Bar Graph with the wrong number of bars, but it is based on the correct data

OR

The graph is correct but it is missing both the title and axis labels.

2 Points Needs Improvement

The student submitted a graph that was not a bar graph or some other major mistakes were found such as drawing a graph on paper.

0 Points

No Effort

The student did not attach work for review OR the Bar Graph

was made with the wrong data set.

Bar Graph Analysis

12 Points

Proficient

The student makes an inference based on the graph

AND

The student provides research of how patient satisfaction can be improved in the ER

AND

The student cites at least one source.

8 Points

Above Average

The student makes an inference based on the graph

AND

The student provides research of how patient satisfaction can be improved in the ER but does not provide at least one source.

7 Points

Average

The student makes an inference based on the graph

OR

The student provides research of how patient satisfaction can be improved in the ER

AND

The student cites at least one source.

4 Points

Needs Improvement

The student makes an inference based on the graph

OR

The student provides research of how patient satisfaction can be improved in the ER but the student does not cite at least one source.

0 Points No Effort

The student does not have an answer for review.

Determining an appropriate graph.

12 Points

Proficient

The student chooses the correct type of graph to display the assigned data

AND

The student provides proficient reasoning to why the graph selected should be constructed

AND

The student discusses key points that a viewer of the graph would extract if the graph was constructed.

8 Points

Above Average

The student chooses the correct type of graph to display the assigned data

AND

The student provides basic reasoning to why the graph selected should be constructed

AND

The student discusses key points that a viewer of the graph would extract if the graph was constructed.

7 Points

Average

The student does not choose the correct type of graph to display the assigned data

AND

The student provides reasoning to why the graph selected should be constructed

AND

The student discusses key points that a viewer of the graph would extract if the graph was constructed.

4 Points

Needs Improvement

The student does not choose the correct type of graph to display the assigned data

AND

The student provides reasoning to why the graph selected should be constructed

OR

The student discusses key points that a viewer of the graph would extract if the graph was

0 Points No Effort

The student does not have an answer for review.

,

Sheet1

Wait Time Age Weight Height Temp Insurance Out of Pocket Pay Income Satisfaction
35 40 165 69 99 Stone 25 180000 5
75 27 118 64 98 No Insurance 120 65500 2
43 23 135 66 98.9 Blue Cross 20 60000 5
78 39 180 69 101 PPPlan 30 50000 1
81 35 208 71 99 Stone 20 70000 4
25 21 125 68 102 Shield 20 85000 2
15 56 275 69 99.9 No Insurance 200 60000 3
10 21 115 54 100.1 Shield 30 40000 2
88 25 189 68 98 Stone 30 85000 4
90 77 190 67 103 PPPlan 25 67000 1
35 19 158 73 102 Stone 40 45000 4
45 72 154 68 102 PPPlan 50 50000 2
28 30 220 67 101.5 Stone 15 55000 3
20 20 134 60 99 PPPlan 20 108000 5
75 24 145 61 103 Blue Cross 25 95000 2
60 50 176 69 98.7 Shield 25 88000 3
80 22 230 73 98.7 No Insurance 300 95000 3
44 19 215 68 101 No Insurance 100 60000 2
46 49 208 72 102 Stone 25 90000 1
48 59 156 71 97.6 Shield 25 85000 4
41 41 155 66 98 Stone 25 75000 1
54 28 135 69 96.8 Stone 40 108000 3
23 30 188 65 97 Stone 20 90000 1
15 56 134 65 99.9 Shield 25 65000 5
29 45 175 69 98.2 Stone 30 80000 4
31 24 123 60 98 Stone 20 50000 3
77 21 200 72 99 Shield 50 50000 2
31 40 135 59 103.1 Stone 50 70000 4
80 23 130 58 102 PPPlan 20 85000 2
9 42 190 67 98 No Insurance 125 60000 4

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.

Related Posts

All Rights Reserved Terms and Conditions
College pals.com Privacy Policy 2010-2018