Question

                             

An​ avant-garde clothing manufacturer runs a series of​ high-profile, risque ads on a billboard on Highway 101 and regularly collects protest calls from people who are offended by them. The company has no idea how many people in total see the​ ad, but it has been collecting statistics on the number of phone calls from irate​ viewers:

                                                                                 

Type	Description	Number of Complaints
R	Offensive​ racially/ethnically	12
M	Demeaning to men	5
W	Demeaning to women	11
I	Ad is Incomprehensible	9
O	Other	19

how to do a

Pareto chart below.

Answer 1

Type	Description	Number of Complaints	Cumulative
O	Other	19	19
R	Offensive​ racially/ethnically	12	31
W	Demeaning to women	11	42
I	Ad is Incomprehensible	9	51
M	Demeaning to men	5	56

Formula

Type	Description	Number of Complaints	Cumulative
O	Other	19	=D3
R	Offensive​ racially/ethnically	12	=E3+D4
W	Demeaning to women	11	=E4+D5
I	Ad is Incomprehensible	9	=E5+D6
M	Demeaning to men	5	=E6+D7