Question

An​ on-line retailer identified the web browser being used by a sample of 50 shoppers to its online site. The accompanying data table identifies the browser being used by a shopper. Previously in​ 2010, 64​% of shoppers used Browser​ A, 24​% Browser​ B, 6​% Browser​ C, 3​% Browser​ D, and 3​% Browser E.
Required:
a. Using software, tabulate the frequency of the choice of browser used by these shoppers.
b. Present a bar chart and a pie chart of these frequencies. Which is more useful to compare the distribution of these to those observed in 2010?
c. Do you see any changes in the distribution of the choice of browser?

Answer 1

Answer:

See Explanation

This question is answered using Microsoft Office Excel 2013

Step-by-step explanation:

Given

Browser A - 64%

Browser B - 24%

Browser C - 6%

Browser D - 3%

Browser E - 3%

Total Frequency = 50

a.

To tabulate the frequency of the choice of browser, the total frequency is multiplied by each individual percentage as follows;

Browser A - 64% * 50 = 32

Browser B - 24% * 50 = 12

Browser C - 6% * 50 = 3

Browser D - 3%* 50 = 1.5

Browser E - 3% * 50 = 1.5

See Attachment for frequency table (using software)

b. See Attachment for pie chart and bar chart.

Both charts are useful for data presentation but in this case, the pie chart is a better option to use because it shows how the distribution of each browser and how they make up as a whole.

The main circle of the pie chart shows how individual browser are distributed through segments; This is not so for the bars of the bar chart which.

c. Yes, there are changes in the choice of browser.

Aside from Browser D and E that has the same frequency, other browsers (A-C) have different frequency.

Also, the distribution shows that more users make use of browser A than other browsers and the least frequent used browser are browser D and E.

Download xlsx