Question: 1 = Vodacom 2 = Cell C 3 = MTN 4 = Telkom Enter the following numbers into an excel file. Note that I

1 = Vodacom 2 = Cell C 3 = MTN 4 = 

1 = Vodacom 2 = Cell C 3 = MTN 4 = Telkom Enter the following numbers into an excel file. Note that I have put then numbers in columns to save space. In your file, the numbers should all be in a single column. Network providers used by student sample: 1 2 3 3 44 The results of the survey of 150 students as to which cell phone network they used are presented in the table below. The numbers refer to: 3 1 3 2 4233 1 1.1. 1.2. 1.3. 1 3 1 4 3 2 1 3 3 3 4 1 1 1 4 2 1 1 13423 MM~433 2 1 3 4 1 3 1 3 1 3 1 1 1 3 3 1 3 1 3 1 1 2 4 2 34 1 3 4 4 4 1 3 3 3 1 1 3 1 1 3 3 3 2 1 Construct a frequency table for this data. 1 3 3 3 3 1 4 2 1 4 3 3 3 3 3 3 2 3 1 1 1 3 4 4 4 2 1 3 1 1 1 2 1 2 1 1 1 3 1 4 3 1 4 Using Excel, construct a bar chart and pie chart from this frequency table. 1 4 1 1 3 NW 2 1 1 1 1 2 1 1 23 (15) (4) What do these tables and graphs tell you about network usage by our sample of students? (6)

Step by Step Solution

3.40 Rating (156 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!