Reference no: EM133135844

Question - A large national retailer of electronics conducted a survey to determine consumer preferences for various brands of point and shoot digital cameras. The table summarizes responses by brand and gender.

	Female	Male	Total
Cannon Power Shot	73	59	132
Nikon Cool Pix	49	47	96
Sony Cyber Shot	58	33	91
Panasonic Lumix	35	30	65
Fujifilm Finepix	45	28	73
Olympus S/V	37	41	78
Other Brands	86	67	153
Total	383	305	688

Required -

a) Prepare bar chart in excel and paste it in word file.

b) Find each of the following percentages.

i) What percent of the responses were males who prefer Nikon?

ii) What percent of the male responses prefer Olympus?