MATH 215 Ashford University Wk 2 Data for Application Assignment Worksheet

User Generated

Rzzljevgre

Mathematics

math 215

ashford university

MATH

Description

Answer the following questions using Excel Analysis Tool Pack. The graph in Excel should be cut and paste on this Word document. You will turn in a single Word document, not an Excel file.

Unformatted Attachment Preview

Franklin University Math215 – Statistical Concepts Name: _______________________ Week2 - Application Assignment 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. 1. 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. 2. 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.?) 3. 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. 4. 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.?) 5. 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? 060219 Franklin University Math215 – Statistical Concepts Name: _______________________ 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. 1. Using Excel, construct a side-by-side bar graph for this data. Copy and paste your graph here. 2. Using Excel, construct a pie chart for the 2008 data. Make sure the percentages show on each slice. Copy and paste your graph here. 3. Using Excel, construct a Pareto graph for the 2013 data. Copy and paste your graph here. 060219
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hello, please find the attached assignment. Please let me know if you have any question.Thanks and Goodbye 😎

Franklin University
Math215 – Statistical Concepts

Name: _______________________

Week2 - Application Assignment
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 produc...


Anonymous
Great content here. Definitely a returning customer.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags