Premium Essay

Test 1

In:

Submitted By tsangchunpong
Words 414
Pages 2
Question 1 (13 marks total)

Open the Excel worksheet top-10-mobile-phones-in-use.xlsx

The spreadsheet contains details of the top 10 countries of the world in terms of the number of ‘mobile phones in use’ as at 31/12/2012.

a) Graph the ‘mobile phones in use’ data appropriately, for the Top 10 countries. (2 marks) b) Graph the ‘proportion’ data appropriately (in a different way from question ‘a’) for the Top 10 countries. (3 marks) c) Use the data to create one graph that allows a simple comparison of ‘mobile phones in use’ and ‘population’ for the Top 10 countries. (4 marks) d) Your boss has produced a graph of the proportion data below.
State 4 weaknesses of his Pie Chart. (4 marks)

Question 2 (24 marks total)

Open the Excel worksheet nz-earthquakes-sept-2013.xlsx

The spreadsheet contains details of all the earthquakes in New Zealand in September 2013.

a) Create a Histogram for the Earthquake data.
(Hint : A group width of 0.5 would work well) (10 marks) b) What shape is the histogram? (1 mark) c) Calculate the Mean, Range and Mode for the Earthquake data. (3 marks) d) Identify 1 way in which your histogram could be improved. (2 marks)

e) Using the data and your answers above (2a, 2b, 2c) state 4 distinct features of New Zealand’s earthquakes in September 2013; support each statement with a statistic. (8 marks)

Question 3 (20 marks total)

Open the Excel worksheet new-zealand-regions.xlsx

The spreadsheet contains details of New Zealand’s 16 regions.

a) Name the 5 variables and their data types. (5 marks) b) Draw an appropriate graph to show the population of the 16 regions. (2 marks) c) Calculate the Mean and the Median of the regional population. (2 marks) d) Why is the Mean regional population significantly higher than the Median?

If the mean is

Similar Documents

Premium Essay

Part 1 the Binomial Test

...PART 1 The binomial Test Click Link Below To Buy: http://hwcampus.com/shop/part-1-the-binomial-test/ 1- Insurance companies charge young drivers more for automobile insurance because they tend to have more accidents than older drivers. To make this point an insurance representative first determines that only 16% of licensed drivers are age 20 or younger. Because this age group makes up only 16% of the drivers it is reasonable to predict that they should be involved in only 16% of the accidents. In a random sample of 100 accident reports however the representative finds 31 accidents that involved drivers who were 20 or younger. Is this sample sufficient to show that younger drivers have significantly more accidents then would be expected from the percentage of young drivers? Use a two-tailed test with a significance of .05 2- A researcher would like to determine whether people can really tell the difference between bottled water and tap water. Participants are asked to tasted two unlabeled glasses of water, one bottle and one tap, and identify the one they thought tasted better. Out of 40 people in the sample, 28 picked the bottled water. Was the bottled water selected significantly more often than would be expected by chance? Use a two tailed test with a=.05 A researcher is investigating the relationship between personality and birth order position. A sample of college students is classified into four birth order categories (1st, 2nd, 3rd,4th, or later)...

Words: 473 - Pages: 2

Premium Essay

How to Test for Type 1 Diabetes

...| How To Test For Type 1 Diabetes | | | Karen Griffin | HS 200-02 | Unit 6 Capstone Project- Type 1 Diabetes Kaplan University 4/8/2013 | The testing for type 1 diabetes can be problematic even for the most experienced physician. There usually is not a reason to test for it unless there is some sort of family history, when testing is necessary there are normally 3 different tests that will be used to determine if it truly is type 1 diabetes. One of the first tests administered is the Fasting Blood Glucose (FBG) with this test a blood sample is drawn after the patient has fasted for at least 8 hours, meaning no food or drinks except water. If the test results show a glucose reading of 126 mg/dl or higher the patient has diabetes a normal reading is between 70-110 mg/dl. Random Blood Glucose (RBG) is another form and fasting is not required it is used especially in an emergency situation when they need to determine sugar levels for the patient (most often children) as quickly as possible so if needed they can administer insulin so the patient does not go into a diabetic coma. Oral Glucose Tolerance Test(OGTT) is another diagnostic test it differs from the other two because you have to drink a sugary beverage to measure how your pancreas can manage the glucose you take in...

Words: 714 - Pages: 3

Premium Essay

Case Study #1 Turner Test Prep Co.

...With an undergrad degree in business, a master's degree in accounting, and previous experience as a teacher for a test prep company under her belt, Jessica Turner decided to start Turner Test Prep Co., a California based company specializing in Certified Public Accountant (CPA) exam preparation. After three years of operation, Turner Test Prep Co. possessed about 10 percent of the small market and was facing fierce competition from its rival company, National Testing Services (NTC). By Spring of 2003, Turner was pleased that the number of customers was rising each session, but was concerned that she had not tapped enough of the market and was not growing in the right direction. Furthermore, a lack of student attendance in live lectures caused her to wonder if there was opportunity in formatting the course differently. Finally, Turner realized that she neglected to calculate her break-even point. In short, Turner was questioning the effectiveness of several aspects of her business plan such as her differentiation, marketing, and advertising strategies. At the beginning of this case study Turner starts off making some good choices such as using the effectuation process to come up with her idea to develop a CPA testing prep company. This process leads her to choose a career path and business that makes use of her knowledge, experience, and resources. Another great choice Turner makes is to do research to find a prime location for her business. In addition, it is wise of her to...

Words: 1231 - Pages: 5

Premium Essay

Test 1

...Galen University – BKFN 315 – Intermediate Macroeconomics – Test # 1 Friday April 4, 2014. This test contributes 15% towards your semester grade. 1. Macroeconomic statistics include GDP, the inflation rate, the unemployment rate, retail sales, and the trade deficit. TRUE 2. Macroeconomic statistics tell us about a particular household, firm, or market. FALSE 3. Macroeconomics is the study of the economy as a whole. TRUE 4. The goal of macroeconomics is to explain the economic changes that affect many households, firms, and markets simultaneously. TRUE 5. Microeconomics and macroeconomics are closely linked. TRUE 6. The basic tools of supply and demand are as central to macroeconomic analysis as they are to microeconomic analysis. TRUE 7. GDP is the most closely watched economic statistic because it is thought to be the best single measure of a society’s economic well-being. TRUE 8. GDP can measure either the total income of everyone in the economy or the total expenditure on the economy’s output of goods and services, but GDP cannot measure both at the same time. FALSE 9. For an economy as a whole, income must exceed expenditure. FALSE 10. An economy’s income is the same as its expenditure because every transaction has a buyer and a seller. TRUE 11. If exports are $500, GDP is $8000, government purchases are $1200, imports are $700, and investment is $800, then consumption is $6200. TRUE 12. If consumption is $1800, GDP is $4300, government purchases are $1000,...

Words: 1256 - Pages: 6

Free Essay

Test 1

...Sesame Chicken 3 whole boneless chicken breasts Marinade 2 tablespoons light soy sauce 1 tablespoon cooking wine or 1 tablespoon dry sherry 3 drops sesame oil 2 tablespoons flour 2 tablespoons cornstarch 2 tablespoons water 1/4 teaspoon baking powder 1/4 teaspoon baking soda 1 teaspoon vegetable oil Sauce 1/2 cup water 1 cup chicken broth 1/8-1/4 cup white vinegar (depending on how sweet you want the sauce) or 1/8-1/4 cup rice wine vinegar (depending on how sweet you want the sauce) 1/4 cup cornstarch 1 cup sugar (we use 1/2 cup sugar but the orginal recipe called for 1 cup) 2 tablespoons dark soy sauce 2 tablespoons sesame oil 1 teaspoon chili paste (or more) 1 garlic clove (minced) Frying peanut oil (3 1/2-4 cups) Serving 2 tablespoons toasted sesame seeds Directions: 1 Cut the chicken into 1-inch cubes. Mix the marinade ingredients (the first 9 ingredients listed) and marinate the chicken for 20 minutes. 2 To prepare the sauce:. 3 Mix together all of the sauce ingredients. Pour them into a small pot and bring to a boil, stirring continuously. Turn the heat down to low and keep warm while you are deep-frying the chicken. 4 To deep-fry the chicken:. 5 Add the marinated chicken pieces a few at a time, and deep-fry until golden brown. Drain on paper towels and then place chicken in warm oven (130 degrees) while you continue frying. Repeat with the remainder of the chicken. Just before you are finished deep-frying, bring...

Words: 296 - Pages: 2

Premium Essay

Test 1

...Project Risk Management Plan Department: Product or Process: Document Owner: Project or Organization Role: Version | Date | Author | Change Description | | | | | | | | | | | | | * Project Risk Management Plan Purpose A Project Risk Management Plan is a controlling document that incorporates the goals, strategies, and methods for performing risk management on a project. The Project Risk Management Plan describes all aspects of the risk identification, estimation, evaluation, and control processes. The purpose of developing such a plan is to determine the approach for cost-effectively performing risk management on the project. * Stakeholder Roles and Responsibilities Role | Risk Management Responsibility | Assignment | | [The Project Manager is responsible for the Project Risk Management Plan being implemented and for reporting to the Project Sponsor and Management Group.] | | | | | | | | * Risk Management Process and Activities Risk Management Activity | Risk Management Task Description | Ownership (Participants) | [Risk Identification] | [Identify the techniques that are used to identify risk factors at the beginning of the project and on an ongoing basis. This may involve a formal risk assessment workshop, a brainstorming session, and interviews at the beginning of each major milestone phase.] | [Identify project team members and key stakeholders to be involved.] | | | | | | | ...

Words: 253 - Pages: 2

Premium Essay

Test 1

...Assignment #3 file folder in the Assignments folder in Blackboard. This work represents 5% of your course grade. Question #1: WACC & Capital Budget Analysis – 60% Based on the inputs below prepare a capital budget analysis for this Base Case using the Net Present Value, Internal Rate of Return, Profitability Index and Payback in years methods, determining whether the project is feasible. Please show your spreadsheet calculations and your final determinations of “go” or “no go” on the project. Use your Investment Return Analysis as an example for this capital budget analysis. Project Inputs: WACC – Debt is 75% and Equity is 25% of this firm’s capital structure. Interest rate on the debt is 7.5%, firm’s tax rate is 30%. Firm’s beta is 1.25, Risk Free Rate is 2.0%, Market Return Rate is 11.0%. Project Investment Outlay, Year 0 - $1,000,000 Project Investment Life – 10 years Project Depreciation - $100,000 / year Project Salvage Value - $30,000 Working Capital Base of Annual Sales – 10% Expected inflation rate per year – 3.0% Project Tax Rate – 30% Units sold per year – 40,000 Selling Price per Unit, Year 1 - $40.00 Fixed operating costs per year excluding depreciation - $175,000 Manufacturing (Variable) costs per unit, Year 1 - $30.00 Question #2: (Twenty Points) Multiple Choice Questions – select the best answer: Chapter 12 - (1). If you were willing to bet that the overall stock market was heading up on a sustained basis, it would be logical to...

Words: 471 - Pages: 2

Free Essay

Test 1

...the study of government in the United States at the national, state, and local levels. This particular survey of the American system of government includes a study of the fundamental principles of political science, the study of the national and state constitutions, methods of participation, and analyzes contemporary policies. This course is fully transferable to all Texas State colleges and universities. Required Texts: O’Connor, Karen, Larry J. Sabato, Alixandra. 2011. American Government: Roots and Reform, Texas Edition. Pearson Education. Paperback Edition/ISBN-13: 978-1-256-28850-3; ISBN-10:1-256-28850-0 Recommended: Study Guides are available on-line to accompany the required texts. Students are also encouraged to follow current political events by reading newspapers and following media news reports. Please refer to instructor’s Learning Web page. Student Notification Statements: 1.  Advising and Counseling Services Advising can be accomplished by contacting the Student Associate at 713-718-6879, selection 2, and on-site advising at other HCC locations upon request. Confidential sessions with education counselors will help students understand admissions, registration, entrance testing requirements, degree planning, transfer issues, and career counseling. Houston Community College counselors also maintain a local referral base in order to provide appropriate referrals to students with personal or family issues that may require long-term solutions. 2.  Disability...

Words: 1634 - Pages: 7

Free Essay

Test 1

...Brandy Jones September 16, 2014 Assignment 3 Tech Has Talent Volunteers Volunteers are critical to any event being planned. If you do not have volunteers, you do not have an event, unless you have the money to pay for every service you are offering. For the Tech Has Talent event, we expect to have over 500 attendees and we have 6 weeks to plan, recruit, train, execute, and appreciate our volunteers. At 6 weeks from the event, I have a Volunteer Coordinator/Supervisor on my committee, which is comprised of Greenville Tech students and staff. I expect my volunteer coordinator to be organized, have this event executed efficiently, make sure volunteers are recognized, and have problems dealt with swiftly, but delicately. The following is our volunteer plan closer to the event. Since we are 6 weeks out, we have the GTC Computer Science department volunteering to take care of signs, graphics and logos. GTC’s Culinary Institute of the Carolinas is handling food and beverages the day of the event. The Automotive Technology department is supplying golf cart drivers to transport guests with disabilities to and from the parking area. Each department participating will have an event T-shirt with their respective departments acknowledged and students showcasing their talents have been reviewed and approved for their station. We have established a sign-up area for students to volunteer in the library, student center, McAlister Square, computer labs across campus, department...

Words: 837 - Pages: 4

Premium Essay

Testing a Winning Strategy: 1) Goodness of Fit Test: How Well Does Strategy Fit the Firm’s Situation? 2) Competitive Advantage Test: Does Strategy Lead to Sustainable Competitive Advantage? 3) Performance Test: Does Strategy Boost Firm Performance?

...Testing a winning strategy: 1) Goodness of fit test: How well does strategy fit the firm’s situation? 2) Competitive advantage test: does strategy lead to sustainable competitive advantage? 3) Performance test: does strategy boost firm performance?Testing a winning strategy: 1) Goodness of fit test: How well does strategy fit the firm’s situation? 2) Competitive advantage test: does strategy lead to sustainable competitive advantage? 3) Performance test: does strategy boost firm performance?Testing a winning strategy: 1) Goodness of fit test: How well does strategy fit the firm’s situation? 2) Competitive advantage test: does strategy lead to sustainable competitive advantage? 3) Performance test: does strategy boost firm performance?Testing a winning strategy: 1) Goodness of fit test: How well does strategy fit the firm’s situation? 2) Competitive advantage test: does strategy lead to sustainable competitive advantage? 3) Performance test: does strategy boost firm performance?Testing a winning strategy: 1) Goodness of fit test: How well does strategy fit the firm’s situation? 2) Competitive advantage test: does strategy lead to sustainable competitive advantage? 3) Performance test: does strategy boost firm performance?Testing a winning strategy: 1) Goodness of fit test: How well does strategy fit the firm’s situation? 2) Competitive advantage test: does strategy lead to sustainable competitive advantage? 3) Performance test: does strategy boost firm performance...

Words: 685 - Pages: 3

Free Essay

Ihy Jhssdkl Kldvhsdv

...Resources |Listening |Reading |Class Reading |Writing |Final test 1 |Final test 2 | |Ex 1-2 Barrons |Test 1: |RP1 T1T3 (cam5) |task1 |Camb 6 test 1 |From old handbook | |numbers/letters |Cambr 7 test 1 |RP2 T1T2 (cam5) |macmillan (macarter) |Reading: | | |Ex.3 Camb 7 Section 1 |Test 2: |RP3 T4T1 (cam5) |task 2 |Camb 7 test 2 | | |Ex 4. Emotions Barrons |Cambr 7 test 4 |RP4 Mozart (macmillan) |Kaplan (celeb) |Writing | | |Ex. 4 |Test 3 |RP5 T4T3 (cam5) |simon |Chicken consumption | | |-camb 7 test 4 sect3 |Plus 2 (old) |RP6 T2T1 (cam6) |dcielts |(camb 7 test 2) | | |-sect 3 from previous |Test 4: | |Sample essays |Media essay | | |final test1 |Plus 2 (old) | |1 celebrities |(vocabulary for | | |Ex “time” “frequency” |Test 5: | |2 TV |ielts unit 19) | | |from barrons |Plus 2 (old) ...

Words: 4223 - Pages: 17

Free Essay

Coding Questions

...nursery school and is just learning how to add. The sum of multiple numbers needs to be calculated and the numbers can be either 1, 2 or 3 to make the calculation easier. Bart Simpson however, can calculate the sum only if the numbers to be added are in a non-decreasing order. For example Bart can calculate 1+1+2+2+3+3 but not 2+1+2+3+1+3. You have to help Bart to rearrange the numbers such that it is easy for him to calculate them. Input Format First line contains an integer 't' denoting total test cases. Next 't' lines contain non-empty string s - the sum Bart needs to calculate. String doesn’t contain spaces and contains only digits and the '+' character. Length of string s <=100. t<=100. Output Format For each test case, the new order displayed in the format such that Bart can count followed by a new line. Sample Input 4 1 2+2 3+2+1 2+2+1+1+3 Sample Output 1 2+2 1+2+3 1+1+2+2+3 Explanation For the above cases, output is displayed in the format such that Bart can calculate it. Play Auditions Problem Statement There are a total of ‘a’ men and ‘b’ women who would be coming to a play audition. In order to select participants for the play we need to follow the given constraints. While choosing the group, there should be exactly ‘x’ people in total and should contain more than 3 men and at least 1 woman. You are required to find total number of ways in which the group can be formed. The groups are considered distinct only if...

Words: 1471 - Pages: 6

Free Essay

Hartley's Test Table

...Table Critical values for the Hartley test (right-sided) Level of significance = 0.01 k n-1 2 3 4 5 6 7 8 2 199 448 729 1036 1362 1705 2069 3 47.5 85 120 151 184 216* 249* 4 23.2 37 49 59 69 79 89 5 14.9 22 28 33 38 42 46 6 11.1 15.5 19.1 22 25 27 30 7 8.89 12.1 14.5 16.5 18.4 20 22 8 7.50 9.9 11.7 13.2 14.5 15.8 16.9 9 6.54 8.5 9.9 11.1 12.1 13.1 13.9 10 5.85 7.4 8.6 9.6 10.4 11.1 11.8 12 4.91 6.1 6.9 7.6 8.2 8.7 9.1 15 4.07 4.9 5.5 6.0 6.4 6.7 7.1 20 3.32 3.8 4.3 4.6 4.9 5.1 5.3 30 2.63 3.0 3.3 3.4 3.6 3.7 3.8 60 1.96 2.2 2.3 2.4 2.4 2.5 2.5 1.00 1.0 1.0 1.0 1.0 1.0 1.0 *The third-digit figures for n - 1 = 3 are uncertain. Level of significance = 0.05 k 5 6 7 8 202 266 333 403 50.7 62.0 72.9 83.5 25.2 29.5 33.6 37.5 16.3 18.7 20.8 22.9 12.1 13.7 15.0 16.3 9.70 10.8 11.8 12.7 8.12 9.03 9.78 10.5 7.11 7.80 8.41 8.95 6.34 6.92 7.42 7.87 5.30 5.72 6.09 6.42 4.37 4.68 4.95 5.19 3.54 3.76 3.94 4.10 2.78 2.91 3.02 3.12 2.04 2.11 2.17 2.22 1.00 1.00 1.00 1.00 9 2432 281* 97 50 32 23 17.9 14.7 12.4 9.5 7.3 5.5 3.9 2.6 1.0 10 2813 310* 106 54 34 24 18.9 15.3 12.9 9.9 7.5 5.6 4.0 2.6 1.0 11 3204 337* 113 57 36 26 19.8 16.0 13.4 10.2 7.8 5.8 4.1 2.7 1.0 12 3605 361* 120 60 37 27 21 16.6 13.9 10.6 8.0 5.9 4.2 2.7 1.0 n-1 2 3 4 5 6 7 8 9 10 12 15 20 30 60 2 39.0 15.4 9.6 7.15 5.82 4.99 4.43 4.03 3.72 3.28 2.86 2.46 2.07 1.67 1.00 3 87.5 27.8 15.5 10.8 8.38 6.94 6.00 5.34 4.85 4.16 3.54 2.95 2.40 1.85 1.00 4 142 39.2 20.6 13.7 10.4 8.44 7.18 6.31 5.67 4.79 4.01 3.29...

Words: 689 - Pages: 3

Free Essay

Impact of Broken Family to a Student

...This number has are eight tens in addition to the four hundred thousands, nine ten thousands, five thousands and seven hundreds.  The last or right digit is the ones' place which is four in this example.  Therefore there are four sets of one hundred thousand, nine sets of ten thousand, five sets of one thousand, seven sets of one hundred, eight sets of ten, and four ones in the number 495,784 A. Place Value Extended Forms There are 4 sets of one hundred thousand, 9 sets of ten thousand, 5 sets of one thousand, 7 sets of one hundred, 8 sets of ten, and 6 ones in the number 495,786. Expanded form shows the number expanded into an addition statement. The expanded form of 495,786 is 400,000 + 90,000 + 5,000 + 700 + 80 + 6. Pre- test Name _____________________________ | | | Date ___________________ | Place Value Write each number in standard form....

Words: 1800 - Pages: 8

Free Essay

Is535

...Chapter 1 - Questions and Exercises Matching Part 1. 1. 2. Q 3. F 4. N 5. H 6. T 7. S 8. U 9. B 10. M 11. C 12. G 13. I 14. A 15. J 16. P 17. V 18. R 19. K 20. E 21. D 22. L 23. O 24. W Matching Part 2. 1. 1. B 2. C 3. E 4. F 5. A 6. G 7. D 8. H 9. I 10. J 11. K Matching Part 3. 1. 1. D 2. L 3. R 4. V 5. X 6. B 7. N 8. J 9. Y 10. K 11. S 12. Q 13. F 14. P 15. E 16. O 17. U 18. W 19. A 20. G 21. T 22. C 23. H 24. M 25. I Matching Part 4. 26. 1. J 2. B 3. D 4. I 5. M 6. N 7. O 8. K 9. H 10. A 11. E 12. G 13. F 14. L 15. C 16. True/False. 1. False. As a result of computers, fewer jobs are currently available in manufacturing than in service industries. 2. True. 3. False. Manual data processing does not use a computer. 4. False. Data consists of raw facts, while information consists of data that have been processed. 5. False. The smallest data unit that the computer can use is the bit. 6. True. 7. False. 1000.27 is an example of a numeric field. 8. True. 9. True. 10. True. 11. False. CPU refers to central processing unit. 12. False. Examples of input/output devices...

Words: 1532 - Pages: 7