Excel Week 2 Summative Assessment Alieda Delgado 012224

xlsx

School

University of Phoenix *

*We aren’t endorsed by this school

Course

330

Subject

Statistics

Date

Feb 20, 2024

Type

xlsx

Pages

Uploaded by GeneralInternetBee31

2012 Presidential Run GOP Candidate Percent of Support Palin 23% Huckabee 40% Romney 37% Total 100%

Delgado, A (2023). Week 2 summative assessment 102823 Alieda Delgado DCS 330 [Unpublished paper]. Student,

(Delgado, 2023) Palin 23% Huckabee 40% Romney 37% '2012 Presidential Election GOP Candidate Support' Palin Huckabee Romney In example 1, the information in this graph represents a failed calculation based on the type of visual tool the presenter chose to use. When using a pie chart, the total makeup of that chart should add up to 100 percent. When I look at this pie chart, I immediately see that the total of this pie chart exceeds 100 percent. This is an example of what can happen when you choose the wrong visual tool to reflect what you're trying to convey (Delgado, 2023). In this pie chart, the presenter is trying to convey how much support each GOP presidential candidate for the 2012 presidential election had from the GOP constituency however, this chart does not reflect that. Instead, this chart shows that 70% of the of the GOP constituency backed Palin, 60% of the constituency backed Mitt Romney and 63% of the constituency backed Huckabee. When you add those altogether, you get 193%, which is beyond what a pie chart is supposed to measure. What I did to correct this was, since I could not find any data supporting the measurements in the pie chart, I estimate based on the color coding used in this pie chart (Delgado, 2023). Based on what I see, I estimated that Sarah Palin received roughly 23% of the support from all GOP constituents, Mike Huckabee received 40% of the support from all GOP constituents and Mitt Romney received 37% of the support from all GOP constituents. This is what is reflected in my pie chart example. In this case I decluttered by removing media visuals as they do not add to the information, and I removed misinformation that was presented in the original chart (Delgado, 2023).

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

University of Phoenix.

Time of Birth, by Day of Week of Birth Monday Tuesday WednesdaThursday Friday Saturday Sunday WEEKDAY WEEKEND Time of delivery Mon Tue Wed Thur Fri Sat Sun 12AM-5:59AM 14.3% 16.0% 16.6% 16.6% 17.2% 23.2% 22.3% 6AM-11:59AM 29.8% 29.4% 29.1% 28.8% 29.9% 26.9% 27.1% 12PM-5:59PM 32.4% 31.8% 31.5% 31.7% 31.0% 27.2% 27.2% 6PM-11:59PM 23.6% 22.8% 22.8% 23.0% 22.0% 22.7% 23.4% TOTAL 100.1% 100.0% 100.0% 100.1% 100.1% 100.0% 100.0% original chart (Delgado, 2023) Delgado, A (2023). Week 2 summative assessment 102823 Alieda Delgado DCS 330 [Unpublished paper]. Stu Monday Tues day Wednesday Thursday Fr i d ay Saturday Sunday 0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1 0.236 0.228 0.228 0.23 0.22 0.227 0.234 0.324 0.318 0.315 0.317 0.31 0.272 0.272 0.298 0.294 0.291 0.288 0.299 0.269 0.271 0.143 0.16 0.166 0.166 0.172 0.232 0.223 Time of birth by day of week 6PM-11:59PM 12PM-5:59PM 6AM-11:59AM 12AM-5:59AM % In example 2, we are measuring the time of birth by the day of the week (Delgado, 2023). In this graph we a background grid lines that contribute to clutter, the stacked bars are very thin, and the data displayed over background gridlines. The percentages are displayed along the axis and it's unnecessary to display the perc stacked bars; it's redundant data and unnecessary, again contributing to the clutter of this graph. The title i use of contrast in this graph. It does not look neat, and it takes a while to search for the information (Delga see that in my example I used consistent lettering across the board for the title and labels of this visual. I've audience knows immediately what color correlates to what information. I removed the grid lines and decid the stacked bars because the contrast is more visually appealing also, I removed the percentage measurem information twice. I also widened the bars so that the data displayed on the stacked bars, so it is not spilling display on my graph uses the Gestalt’s principles of visualization making it concise, clear, and easily interpre

(Delgado, 2023) (Delgado, 2023) udent, University of Phoenix. Mo n d ay Tu esd ay W ed n esd ay Th u r sd ay F r i d ay Sa t u r d ay Su n d ay 0.236 0.228 0.228 0.23 0.22 0.227 0.234 0.324 0.318 0.315 0.317 0.31 0.272 0.272 0.298 0.294 0.291 0.288 0.299 0.269 0.271 0.143 0.16 0.166 0.166 0.172 0.232 0.223 Time of birth by day of week 6PM-11:59PM 12PM-5:59PM 6AM-11:59AM 12AM-5:59AM % are using a stacked bar visual. In the original graph there are the stacked bars is very dark and kind of blends in with the centages along the axis if you have the data displayed along the is underlined and bold and uses inconsistent font. It is a poor ado, 2023). The information is not very visually appealing. You'll e moved the legend to the top of the visual so that the ded to use white font in displaying the percentages of each of ments on the axis because it's not necessary to display that g over the edges and blending into the white background. The eted by my audience (Delgado, 2023).

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Month Men Women Before September Before September 9.30% 15.80% September September 5.30% 8.20% October October 19.50% 21.00% November November 43.30% 39.90% First 2 Weeks December: first 2 weeks 18.40% 12.70% Last 2 Weeks December: last 2 weeks 4.20% 2.40% Total 100.00% 100.00% (Delgado, 2023) Original

Delgado, A (2023). Week 2 summative assessment 102823 Alieda Delgado DCS 330 [Unpublished paper]. Student,

Decluttered B efo r e S ep t em b er S ep t em b er Oc t o b er N o v em b er D ec em b fi r st 2 9.30% 5.30% 19.50% 43.30% 18.40% 15.80% 8.20% 21.00% 39.90% Shoppers Begin Holiday Shopp Men Women Month In example 3, we are displaying data on the shopping habits of men and women durin (Delgado, 2023). The first thing I noticed in this graph is there is a poor use of white sp completely disregarded in this graph (Delgado, 2023). The color choice of blue and pin display gender within the graph because the labels are clearly there displaying men an coloring is enough to display this data. The cylinders used, instead of the simple bar gr unnecessary visualization because it does not contribute to the data information being 2023). The grid lines are visible in the background and necessary and also the measure displaying percentages is also unnecessary, as the data labels are present on each bar. in the graph is unnecessary. It looks clunky and elementary and violates the white spa as does the black shading bordering the cylinders used to display the data. In my exam consistent font throughout. I made it very simplified. A simple orange and blue to indi The legend is displayed at the top clearly indicating what color correlates to what infor use the percentage of measurements as each bar displays the percentage data labels c (Delgado, 2023).

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

University of Phoenix.

(Delgado, 2023) b er : w eek s D ec em b er : l ast 2 w eek s 4.20% 12.70% 2.40% ping ng the holidays pace contrast was nk is unnecessary to nd women. Basic raph use, is g provided (Delgado, ements on the axis . Lastly, the font used ace within the graph mple I used icate men or women. rmation. I did not clearly in my visual

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Excel Week 2 Summative Assessment Alieda Delgado 012224

Related Documents