Week 3 Frequency Distribution and Relative Frequency Data Analysis Excel Sheet Please submit the final excel sheet Week3Lab.xlsx from the lab after complet

Week 3 Frequency Distribution and Relative Frequency Data Analysis Excel Sheet Please submit the final excel sheet Week3Lab.xlsx from the lab after completing all the steps explained in the “Week 3 lab.pdf” Frequency Distribution p. 19 and Relative Frequency p. 20
Hair Color
Brown
Dark
Blonde
Red
Frequency Relative Frequency
49
51,6%
27
28,4%
15
15,8%
4
4,2%
1. Create a column chart
2. Create a copy the chart
3. Change to Pie Chart
Relative Cumulative Frequency p. 25
# Lesions
1 stent
2 stents
3 stents
4 stents
5 stents
6 stents
7 stents
Frequency
1805
553
168
53
13
5
1
Cumulative
1805
2358
2526
2579
2592
2597
2598
% Cumulative
69,48%
90,76%
97,23%
99,27%
99,77%
99,96%
100,00%
Create a Cumulative Frequency Polygon
1. Select A12:A19, then CTRL C12:C19
2. Insert Chart, All Charts
3. Select X-Y Scatter with Smooth Lines & Markers
4. Modify axes if necessary
Exercise 2.12, p. 28
Figure 2.16, page 29
Birthweight (g)
Smoked while
Pregnant

Purchase answer to see full
attachment