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
-
Explain why a column of mercury in a thermometer first descends slightly and then rises when the thermometer is placed into hot water?
-
This is a more general version of Problem C.1. Let Y 1 , Y 2 ,c, Y n be n pairwise uncorrelated random variables with common mean m and common variance s2. Let Y denote the sample average. (i) Define...
-
Should organizations be allowed to promote offensive, violent, sexual, or unhealthy products that can be legally sold and purchased? Support your answer.
-
Your parents are considering investing in Apple Inc. common stock. They ask you, as an accounting expert, to make an analysis of the company for them. Apples financial statements are presented in...
-
3-21. Determi GD. GA of the truss State if the members are is y compression. 4 kN 4 kN 2 m 4 kN 2 m G 2 m 3 m Prob. 3-21 D C
-
Shauna Coleman is single. She is employed as an architectural designer for Streamline Design (SD). Shauna wanted to determine her taxable income. She correctly calculated her AGI. However, she wasnt...
-
Mel sells land that had been used in his business for $300,000. The land has an adjusted basis of $150,000. The buyer gives Mel a note for $150,000 and cash of $150,000. Mel receives no payment on...
-
Municipal market. The city of Valle Escondido has a market that is insufficient, which has caused the proliferation of commerce on public roads. Given this situation, it has been proposed to the...
-
Discuss how cyber disruptions may impact the performance of essentials functions and identify solutions to address vulnerabilities in existing continuity plans.
-
How do Banks handle data breaches in cyber security?
-
The biggest frustration the AG encounters is the inability to audit some contracts because municipalities fail to provide documents and evidence to support procurement processes. Discuss the...
-
Smart Beta Fund has run the following Fama-French multi-factor regression on the excess return of its portfolio A. Based on the following excel regression outputs, determine portfolio A's expected...
-
Problem 24-15 In connection with the audit of the company's financial statements for the year ended December 31, 2004 the Camille Corporation prevented to their records. This is the first time the...
-
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...
-
The chapter says that a measurement system can affect a business in several ways. As an example, consider a worldwide company with headquarters in New York City and divisions in many different...
-
Under the No Child Left Behind Act, passed in 2001, every public elementary school that receives some federal funding is required to give its students certain tests of reading and math every year....
-
Consider a college transcript as the output of a measurement system. A. Identify the: a. Object being measured b. Attribute of the object being measured c. Rules for measurement d. Standard-setters...
Study smarter with the SolutionInn App