A pivot table shows statistics like averages and sums with various fields that summarize data. I came across a youtube video that explains what a pivot table is, what it contains, and how to make one. The first screenshot, it shows a pivot table and some of the fields the person decided was the best fir for their data.
Author: vazque34
Our Energy System
Pie Charts
I believe one of the easiest ways to show how a pie chart should be used is to use “people’s favorites” of any topic. I provided a made-up survey of students and their favorite colors (out of 20 students). I plugged in the survey into excel, highlighted it, then inserted a pie chart with that information.
The website I provided explains what a pie chart is, the way to make a pie chart, how to get the percentages for each section of the data for the pie chart, and more.
https://www.mathsisfun.com/data/pie-charts.html
Lollipop Chart
This week we all created lollipop charts. While looking online for different explanations on how to make a lollipop chart, I came across a really easy one. It did not explain the steps clearly towards the end but I figured it out with the textbook for the last few steps. Compared to the textbook this website: excelk.com went straight to the end product in a few steps.
A lollipop chart is just like a bar graph, but easier to follow when you need to display a large number of values and when those values are high. This type of chart is also more appealing to look at.
For my data set, I was looking through the CDC website and came across Depression in the US Household Population. They had graphs displaying the percentage of symptoms persons of ages 12+ with depression. I picked to use race and ethnicity as my x-axis vs gender, and ages. But also the PDF form which included the data set.
I will say this lollipop graph was pretty easy to make thanks to the website I used. The only problem I came across is trying to change the colors on each of the x-axes ( I wanted no symptom, mild, moderate, and severe on the graph to have their own color to better distinguish the severities.) I also wanted to add data labels, but I could not figure out how to.
Benchmarks
When looking for data visualizations with benchmarks I expected various graphs that had to do with scores. There is a score that you are expected to achieve, and they mark it either on a scale or display it on charts/graphs.
I am going to be showing examples of insightful data visualizations that compare numbers.
- The first one is from a website named datapine.
In this line graph, the number of how many sales were made by various payment methods is being shown, different months and years, and how they changed over time. The lowest was abut 20k being used by bank transfers. The highest was about 90k being used for credit card payments. For credit cards, September seems to go very low. With these numbers and information being presented we can take many guessed on why people only use certain payments a certain amount of times at a certain time in point.
2. The second example is from a website named venngage.
This website provided this infographic as an example of how companies highlight features and pursued buyers to buy certain products. They use the phone they want you to buy and compare it to one that has fewer features or different features than the newer one. Most of the info involves numbers, from screen size, cost of the phone to GB’s, and the weight of the phone.
3. Lastly, from the same website venngage.
This is an example of an infographic comparing and contrasting the number of grams of protein certain foods have. They bolded those numbers because they were most important for people to see. This is an easy infographic to follow. You just look at the food item, then it tells you the number of calories (they vary) it contains and gives you the protein it contains in grams.
Vizhealth
Vizhealth is a website created to help view/explain/visualize health risks and overall help us make decisions over our health. While looking through the website it takes you through steps to get to the visualization that best fits your needs. It shows you various styles of visualization according to questions they ask you (primary goal – awareness, classify risk, differences in risk between groups, degree of risk, and lastly whether the type of visualization basic idea or exact risk number). They also provide a fun comic, risk calculator, and a generator to help view population risks with icons.
Course Hero is a website that provides students various study resources like study guides and textbooks, and their solutions. The one I am specifically going to talk about it their literature infographics. This resource helps students learn about a story’s characters, plot, themes, and more in a visual way. (I will insert an example they provide of a play named “Othello”). Depending on the type of story, the infographics have various information it will provide the reader with. They create colorful infographics with the theme of the story and draw out characters, shapes, and more to grab the reader’s attention. The website also goes into detail with what happens in the chapters, they describe the characters and how they change over time if you click “view study guide for this book”. I would recommend this resource for people who are struggling with understanding a book they are reading.