QMB stat

Lab Assignment #2

Part 1:

Resources that will help:

Pie, Column, Bar, Line and X-Y Scatter: https://www.youtube.com/watch?v=-btUxQi76qI

Pareto Chart: http://www.excel-easy.com/examples/pareto-chart.html

Suppose that you are working for a manufacturing company and want to visualize the types of defects that are occurring along with how many times each defect occurs. See the data below.

Defect	Number of Defects
Misplaced transistors	601
Wrong component	212
Defective board dimension	146
Components not adhering	143
Circuitry problems on final test	90
Excess adhesive	71
Mounting holes improperly positioned	12

1. In Excel, create a pie chart with an appropriate vertical axis, horizontal axis, and title. Copy and paste the chart into this document below. Below is an example of what your final chart should look like, although your titles and numbers will be different. Remove my example and insert your own.

2. In Excel, create a bar chart with an appropriate vertical axis, horizontal axis, and title. Copy and paste the chart into this document below. Below is an example of what your final chart should look like, although your titles and numbers will be different. Remove my example and insert your own.

Part 2:

Resources that will help: http://www.youtube.com/watch?v=DTMxjANGvcU

Complete the following tables and upload with answers included.

You will find the Excel file titled “Retirement Funds”. Inside this file is a listing of types of fund and their returns over a specific number of years. There are four types of funds presented, including a) Large Growth, b) Large Value, c) Mid-Cap Growth, d) Mid-Cap Value, e) Small Growth, and f) Small Value. Please answer the following questions.

Please describe the data for each fund at the 3 year return

Fund Type	Average	Standard Deviation	Minimum	Maximum	Quartile 1	Quartile 3	Skewness
Large Growth
Large Value
Mid-Cap Growth
Mid-Cap Value
Small Growth
Small Value