Unit 10 copy

docx

School

American InterContinental University *

*We aren’t endorsed by this school

Course

125-1803B

Subject

Statistics

Date

Feb 20, 2024

Type

docx

Pages

Uploaded by CorporalIronMoose35

NAME: MATH125: Unit 10 Submission Assignment Answer Form Data Modeling ALL questions below must be answered. Show ALL step-by-step calculations . Upload this modified Answer Form to the intellipath Unit 10 Submission lesson. Make sure that you submit your work in a modified MS Word document; handwritten work will not be accepted . If you need assistance, please contact your course instructor. Graphs and charts allow consumers of information to quickly read, interpret, and analyze data through visual representations. In this assignment, you will interpret, analyze, and create different types of graphs to accurately represent data. 1. Describe the purposes of three different types of data visualizations (graphs and charts). Provide an example of a realistic data set that would be displayed well with each type of graph or chart. (Do not include the graphs or charts). Purpose of Bar Graphs and Data Example (5 points) Bar graphs are ideal for comparing two or more values over time. Number of people who like bananas, apples, or pears. Purpose of Pie Charts and Data Example (5 points) Pie charts are generally used to show percentage or proportional data. Percent of people who play each of the four major sports. Purpose of Line Graphs and Data Example (5 points) Line graphs are generally used to shoe change over a period of time. Temperature vs rainfall of each month.

2. The members of a family of four (two parents and two children) are trying to be more conscious of their water usage. To find opportunities where they might make the most impact, they researched the average household water consumption for various uses. They already have a new house with efficient appliances, which will decrease water usage for the dishwasher and clothes washer. Help them determine where they can make the most impact with their water usage. Type of Use U.S. Average Consumption of Water Parent 1 Daily (Gallons) Parent 2 Daily (Gallons) Child 1 Daily (Gallons) Child 2 Daily (Gallons) Daily Total (Gallons) Weekly Total (Gallons) Bath 36 gallons per bath 0 0 36 36 72 504 Shower 5 gallons per minute 15 25 0 0 40 280 Teeth Brushing 0.5 gallon per minute 2 2 1 1 6 42 Handwashing 1 gallon per minute 4 7 4 5 20 140 Dish Washer** 6 gallons per load 0 6 0 0 6 42 Clothes Washer** 25 gallons per load 50 0 0 0 50 350 Toilet Flush 1.6 gallons per flush 5 5 5 5 20 140 Drinking Water 8 ounces per glass 1 1 0.5 0.5 3 21 Outdoor Watering 2 gallons per minute 40 0 0 0 40 280 Grand Total 117 46 46.5 47.5 257 1,799 **EnergyStar a. Analyze the family’s water consumption based on the data that you have collected. What type of chart or graph would you use to compare individual family members’ daily water usage? Why? (5 points) I would use a bar graph as they are used to compare different things side to side. Use MS Excel to create the chart or graph that was selected above. Use appropriate labeling. (Copy and paste the graph here.) (5 points)

Rank the family members in order of their daily water usage. Who can impact the family’s water consumption the most? (5 points) Most to least Parent 1-Child 2-Child 1- Parent 2 Parent 1 can impact the families water consumption the most. 1 2 3 4 0 20 40 60 80 100 120 140 117 46 46.5 47.5 Daily water usage Series1 Gallons People

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

What type of chart or graph would you use to compare the different types of water consumption to the total weekly usage for the top two family members? Why? (5 points) A pie chart because you are trying to compare parts of a whole. Use MS Excel to create the chart or graph that was selected above. Use appropriate labeling. (Copy and paste the graph here.) (5 points) Based on the graph that you just created above, The family uses a lot of water 504 280 42 140 42 350 140 21 280 1151.5 Water usage 1 2 3 4 5 6 7 8 9 10

summarize what you can determine about the types of water usage for the top two family members. (5 points) taking baths. What recommendation can you make to decrease the overall water consumption? (5 points) The family could use less water while taking baths.

3. Use the table of monthly expenses below for the following questions: January February March April May June 6-Month Total Rent $750 $750 $750 $750 $750 $750 $4,500 Car $299 $299 $299 $299 $299 $299 $1,794 Water $45 $65 $68 $72 $78 $80 $408 Electricity $135 $70 $85 $65 $80 $90 $525 Groceries $205 $150 $200 $210 $435 $150 $1,350 Gas $67 $75 $150 $45 $65 $60 $462 Insurance $189 $189 $189 $189 $189 $189 $1,134 Total $1,690 $1,598 $1,741 $1,630 $1,896 $1,618 $10,173 What type of chart or graph would you use to visualize a comparison of each expense in relation to the 6-month total? Why? (5 points) A line graph because it’s used to compare things over time. Use MS Excel to create the chart or graph that was selected above. Use appropriate labeling. (Copy and paste the graph here.) (5 points)

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

Summarize what you can determine about the monthly expenses based on the graph that you created. (5 points) The monthly expenses are almost identical through 6 months Some of the expenses remain constant, whereas other expenses vary each month. What type of chart or graph would you use if you A line graph because it varies over time. Rent Car Water Electricity Groceries Gas Insurance Total $0 $2,000 $4,000 $6,000 $8,000 $10,000 $12,000 Chart Title January February March April May June 6-Month Total Axis Title

wanted to visualize the monthly trends for the expenses that change each month? Why? (5 points) Use MS Excel to create the type of chart or graph that was selected above for one of the expenses that vary: water, electricity, groceries, or gas. Use appropriate labeling. (Copy and paste the graph here.) (5 points) Based on the graph that you just created above, The month that had an outlier in the water expense was January. 1 2 3 4 5 6 $0 $10 $20 $30 $40 $50 $60 $70 $80 $90 Water expense Series1 Months Cost

which month had an outlier? What is a logical reason why this month’s expenses could have been outside of the normal range? (5 points) A logical reason that this month may have been an outlier is that there were less people in the home at the time or, bottle water was being bought more, or less showers were being taken. 4. Graphs and charts can help others interpret and understand data. However, data are sometimes displayed in ways that can manipulate the meaning or emotions behind the data. Describe one possible way that this could happen. (10 points) On a line graph you can manipulate the y axis however you want. For example if you’re trying to make it seem that something has changed only a little bit over time you can scale up the y axis to make it seem that way. Also you can use different graphs that don’t show the detail in the difference in items.

Your preview ends here

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