Question
Can you please assist with the following questions? Thanks! Answer the following questions using Excel Analysis Tool Pack. Any graphs in Excel should be cut
Can you please assist with the following questions? Thanks!
Answer the following questions using Excel Analysis Tool Pack.Any graphs in Excel should be cut and paste on this Word document. You will turn in a single Word document, not an Excel file.
Remember to title all your graphs, label the axes and use a reasonable scale.
Part1: Building Histograms - 10 points
Download the Excel file named as Week2-DATA for Application Assignment from your course page in Week2 Application Assignment object. That file contains 2 spreadsheets of data. Use the spreadsheet with the Light Bulb Data for this part. This spreadsheet contains the life (in hours) of a sample of 40 100-watt light bulbs produced by a manufacturer.
- Construct a frequency distribution and a relative frequency distribution for the light bulb data with a class width of 20, starting at 800. Copy and paste your distribution tables here.
[Hint: When making distribution tables in Excel, bins should have the upper class limit of each class]
- Construct a histogram based on this frequency distribution table for the light bulb data. Copy and paste your histogram here. Describe the shape of the histogram. (Is it unimodal, bimodal, skewed, etc.?)
- Now, construct a frequency distribution table and a relative frequency distribution table for the light bulb data with a class width of 100, starting at 800. Copy and paste your distribution tables here.
- Construct a histogram based on this frequency distribution table for the data. Copy and paste your histogram here. Describe the shape of the histogram. (Is it unimodal, bimodal, skewed, etc.?)
- Compare the histograms in questions 2 and 4. Describe how changing the class sizes affected the shape of the distribution. What unique information does each histogram tell you about the light bulb distribution?
Part 2: Other Graphical Summaries - 6 points
Now, use the same Excel file from above, but this time click on the spreadsheet tab that has the table with the percentage of children who lived in poverty in several Colorado counties in 2008 and 2013.
- Using Excel, construct a side-by-side bar graph for this data. Copy and paste your graph here.
- Using Excel, construct a pie chart for the 2008 data. Make sure the percentages show on each slice. Copy and paste your graph here.
Using Excel, construct a Pareto graph for the 2013 data. Copy and paste your graph here.
. .. Q AutoSave @ OFF ? Tell me Share Comments Home Insert Draw Page Layout Formulas Data Review View Developer ab v Conditional Formatting Insert v = Calibri (Body) 11 AA = General Format as Table v x Delete v Editing Analyze Paste BI UV VA $ ~ % " Cell Styles v Format Data E25 X V fx N P Q R S T B C D E F G H I J K L M A Light Bulb life (hrs) 819 836 888 897 903 907 912 918 10 942 11 943 12 952 13 959 14 962 15 986 16 992 17 994 18 1004 19 1005 20 1007 21 1015 22 1016 23 1018 24 1020 25 102 26 1034 27 1038 28 1072 29 1077 30 1077 31 1087 32 1096 Light Bulb Data Percent of Children in Poverty + + 100% ReadyAutoSave @ OFF . .. Q Home Insert Draw Page Layout Formulas Data Review View Developer ? Tell me Share Comments Insert v Calibri (Body) 11 AA = = ab v General Conditional Formatting Format as Table v x Delete v Paste BIUV $ ~ % " Editing Analyze Cell Styles v Format Data E25 x v fx A B C D E F G H 1 J K L M N P Q R S T 33 1100 34 1113 35 1113 36 1116 37 1153 38 1154 39 1174 40 1188 41 1230 42 43 44 45 46 47 48 49 50 56 59 60 61 62 63 64 Light Bulb Data Percent of Children in Poverty + Ready + 100%AutoSave @ OFF . .. Q Home Insert Draw Page Layout Formulas Data Review View Developer ? Tell me Share Comments Calibri (Body) 11 AA = = General Conditional Formatting Insert v Format as Table v x Delete v Paste BIUV $ ~ % " Editing Analyze Cell Styles v Format Data C12 X V fx A B C D E F G H 1 J K L M N P Q R County Percent in 2008 Percent in 2013 Adams 19.2 23.1 Arapahoe 13.7 16.4 Boulder 8.9 13.4 5 Denver 27.3 26.2 6 El Paso 15.7 18.0 Jefferson 11.9 12.4 Source: Colorado Children's Campaign 10 11 12 13 14 15 16 17 18 19 20 25 26 27 28 29 30 31 32 Light Bulb Data Percent of Children in Poverty + Ready + 100%Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started