1 = Vodacom 2 = Cell C 3 = MTN 4 = Telkom Enter the following...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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) 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)
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these mathematics questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Create a Mircrosoft Word document named A05.docx. Include all diagrams, screen shots, code, and answers to questions within the following sections: Understand Data Structure and Data Customer Name...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-6. On December 12, Irene purchased the building where her store is located. She paid...
-
tell us about a product or service that has been a hit by changing the product's target or the company's position. And why do you think it worked
-
In Prob. 15.13, determine the velocity and acceleration of corner B, assuming that the angular velocity is 75 rad/s and decreases at the rate of 600rad/s2. 120 mm 200 mm, B 90 mm
-
Which distribution do you use when you are testing a population mean and the population standard deviation is known? Assume sample size is large. Assume a normal distribution with n 30.
-
A cash receipts journal is provided in the Working Papers. Your instructor will guide you through the following examples. Betty Jensen and Glen Chau agree to form a partnership on April 1 of the...
-
For decades, people have believed that boys are innately more capable than girls in math. In other words, due to the intrinsic differences in brains, boys are better suited for doing math than girls....
-
A $ 1 0 0 0 Treasury bond with a coupon rate of 5 . 5 % that has a market value of $ 8 5 0 . what is the current yield?
-
10. Classifying Processed Images into Multiple Classes Introduction We have processed images to represent as a vector of 300 attributes. The first 294 are decimal values in the range 0 to 1...
-
2. Put a CC (chemical change) or a PC (physical change) by each picture. (20 marks) Stepping on scale Flammable chemicals Colour spectrum Baking a cake Baking a cake Chopping a log NAST NORSE...
-
How do systemic barriers within hierarchical frameworks impede the agility necessary for adaptive change processes ? Explain
-
The coefficient of kinetic friction of rubber on dry concrete is 0.8 and on wet concrete 0.5. Starting from a certain speed, the minimum time of your car to decelerate to a full stop is 5 seconds...
-
How do organizational change frameworks integrate cognitive psychology principles to optimize employee engagement and foster a culture of continuous improvement ?
-
Roland Company sponsors a defined benefit pension plan for its employees. The company's actuary provided the following information about the plan at the end of 2026. Projected benefit obligation on...
-
In the figure, the particles have charges q1 = -92 = 560 nC and 93 = -94 = 96 nC, and distance a = 3.8 cm. What are the (a) x and (b) y components of the net electrostatic force on particle 3? a (a)...
-
1. Solve for x in the exponential equation 5* 2. Explain how you can rewrite the equation 5 125. 125 in logarithmic form.
-
The domain of the variable in the expression x 3/x + 4 is________.
-
David and Darlene Jasper have one child, Sam, who is 6 years old. The Jaspers reside at 4639 Honeysuckle Lane, Los Angeles, CA 90248. David's Social Security number is 577-11-3311, Darlene's is...
-
Ray and Maria Gomez have been married 3 years. They live at 1610 Quince Ave., McAllen, TX 78701. Ray works for Palm Oil Corporation and Maria works for the City of McAllen. Maria's Social Security...
-
Larry Gaines, age 42, sells his personal residence on November 12, 2012, for $144,000. He lived in the house for 7 years. The expenses of the sale are $10,500, and he has made capital improvements of...
-
Branden Company, a midsize manufacturer of specialized machinery, follows these purchasing procedures: Materials purchase requisitions are approved by manufacturing supervisors and then forwarded to...
-
Lecimore Company has a centralized purchasing department managed by Tawanda Mason. Tawanda has established policies and procedures to guide the cleri cal staff and purchasing agents in daily...
-
The systems flowchart presented in Figure 11-12 and the following description summarize ConSport Corporations cash disbursements system: a. The accounts payable department approves all invoices for...
Study smarter with the SolutionInn App