NEED EXCEL SPECIALIST
SkylerreybrasilLab 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.
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 |
|
|
|
|
|
|
|