EBK ELEMENTARY STATISTICS USING EXCEL
7th Edition
ISBN: 9780136937531
Author: Triola
Publisher: VST
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
Chapter 1.4, Problem 9BSC
To determine
To print: The Excel worksheet of the data set “Cola Weights and Volumes”.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Enter the data in SPSS or EXCEL
Merge the two data sets
Once you have entered all the data, create a table to display the information
Use any graphical method to present the data
Comment on the findings
Country
May
June
July
August
Sept
October
Uganda
947
57
63
117
37
90
Kenya
411
42
55
100
85
49
Tanzania
521
72
02
116
52
46
Rwanda
753
55
15
89
4
14
Burundi
964
52
1
122
70
33
Ethiopia
327
6
26
135
17
24
Congo
967
6
7
113
90
53
Somalia
670
21
5
24
28
75
Eritrea
379
28
3
16
39
85
Country
May
June
July
August
Sept.
Oct.
Sudan
39
5
38
11
82
86
Chad
44
10
93
11
101
187
Mali
25
30
67
21
132
82
Benin
47
37
44
10
44
21
Togo
49
31
116
11
31
18
Niger
23
40
37
13
88
18
Gambia
39
49
90
21
130
139…
How to construct Scatterplot?
5 project topic ideas for final year statistics/ actuarial science student
Chapter 1 Solutions
EBK ELEMENTARY STATISTICS USING EXCEL
Ch. 1.1 - Prob. 1BSCCh. 1.1 - 2. Reported Versus Measured In a survey of 1046...Ch. 1.1 - 3. Statistical Significance Versus Practical...Ch. 1.1 - Prob. 4BSCCh. 1.1 - Prob. 5BSCCh. 1.1 - Prob. 6BSCCh. 1.1 - Consider the Source. In Exercises 5–8, determine...Ch. 1.1 - Consider the Source. In Exercises 5–8, determine...Ch. 1.1 - Sampling Method. In Exercises 9–12, determine...Ch. 1.1 - Sampling Method. In Exercises 9–12, determine...
Ch. 1.1 - Prob. 11BSCCh. 1.1 - Prob. 12BSCCh. 1.1 - Prob. 13BSCCh. 1.1 - Prob. 14BSCCh. 1.1 - Prob. 15BSCCh. 1.1 - Statistical Significance and Practical...Ch. 1.1 - Prob. 17BSCCh. 1.1 - Prob. 18BSCCh. 1.1 - Prob. 19BSCCh. 1.1 - Prob. 20BSCCh. 1.1 - Prob. 21BSCCh. 1.1 - Prob. 22BSCCh. 1.1 - Prob. 23BSCCh. 1.1 - Prob. 24BSCCh. 1.1 - Prob. 25BSCCh. 1.1 - Prob. 26BSCCh. 1.1 - Prob. 27BSCCh. 1.1 - Prob. 28BSCCh. 1.1 - Prob. 29BSCCh. 1.1 - What’s Wrong? In Exercises 25–28, identify what is...Ch. 1.1 - What’s Wrong? In Exercises 25–28, identify what is...Ch. 1.1 - Prob. 32BSCCh. 1.1 - Prob. 33BSCCh. 1.1 - Prob. 34BSCCh. 1.1 - Prob. 35BSCCh. 1.1 - Prob. 36BSCCh. 1.1 - Prob. 37BSCCh. 1.1 - 30. Checking Job Applicants In a study conducted...Ch. 1.1 - Prob. 39BSCCh. 1.1 - Prob. 40BSCCh. 1.1 - Prob. 41BSCCh. 1.1 - Prob. 42BSCCh. 1.1 - Prob. 43BSCCh. 1.1 - Prob. 44BSCCh. 1.1 - Prob. 45BBCh. 1.1 - Prob. 46BBCh. 1.1 - Prob. 47BBCh. 1.2 - Prob. 1BSCCh. 1.2 - Prob. 2BSCCh. 1.2 - Prob. 3BSCCh. 1.2 - Prob. 4BSCCh. 1.2 - Prob. 5BSCCh. 1.2 - Prob. 6BSCCh. 1.2 - Prob. 7BSCCh. 1.2 - Prob. 8BSCCh. 1.2 - Prob. 9BSCCh. 1.2 - Prob. 10BSCCh. 1.2 - Prob. 11BSCCh. 1.2 - Prob. 12BSCCh. 1.2 - Prob. 13BSCCh. 1.2 - Prob. 14BSCCh. 1.2 - Prob. 15BSCCh. 1.2 - Prob. 16BSCCh. 1.2 - Prob. 17BSCCh. 1.2 - In Exercises 13–20, determine whether the data are...Ch. 1.2 - Prob. 19BSCCh. 1.2 - In Exercises 13–20, determine whether the data are...Ch. 1.2 - Prob. 21BSCCh. 1.2 - Prob. 22BSCCh. 1.2 - In Exercises 21–28, determine which of the four...Ch. 1.2 - Prob. 24BSCCh. 1.2 - In Exercises 21–28, determine which of the four...Ch. 1.2 - Prob. 26BSCCh. 1.2 - Prob. 27BSCCh. 1.2 - In Exercises 21–28, determine which of the four...Ch. 1.2 - Prob. 29BSCCh. 1.2 - Prob. 30BSCCh. 1.2 - Prob. 31BSCCh. 1.2 - Prob. 32BSCCh. 1.2 - Prob. 33BBCh. 1.2 - Prob. 34BBCh. 1.3 - Prob. 1BSCCh. 1.3 - Prob. 2BSCCh. 1.3 - Prob. 3BSCCh. 1.3 - Prob. 4BSCCh. 1.3 - Prob. 5BSCCh. 1.3 - Prob. 6BSCCh. 1.3 - Prob. 7BSCCh. 1.3 - Prob. 8BSCCh. 1.3 - Prob. 9BSCCh. 1.3 - In Exercises 9–20, identify which of these types...Ch. 1.3 - In Exercises 9–20, identify which of these types...Ch. 1.3 - Prob. 12BSCCh. 1.3 - Prob. 13BSCCh. 1.3 - In Exercises 9–20, identify which of these types...Ch. 1.3 - Prob. 15BSCCh. 1.3 - In Exercises 9–20, identify which of these types...Ch. 1.3 - In Exercises 9–20, identify which of these types...Ch. 1.3 - In Exercises 9–20, identify which of these types...Ch. 1.3 - In Exercises 9–20, identify which of these types...Ch. 1.3 - In Exercises 9–20, identify which of these types...Ch. 1.3 - Critical Thinking: What’s Wrong? In Exercises...Ch. 1.3 - Critical Thinking: What’s Wrong? In Exercises...Ch. 1.3 - Critical Thinking: What’s Wrong? In Exercises...Ch. 1.3 - Prob. 24BSCCh. 1.3 - Prob. 25BSCCh. 1.3 - Prob. 26BSCCh. 1.3 - Prob. 27BSCCh. 1.3 - Prob. 28BSCCh. 1.3 - Prob. 29BBCh. 1.3 - Prob. 30BBCh. 1.3 - Prob. 31BBCh. 1.3 - Prob. 32BBCh. 1.3 - Prob. 33BBCh. 1.3 - Prob. 34BBCh. 1.3 - Prob. 35BBCh. 1.3 - Prob. 36BBCh. 1.3 - Prob. 37BBCh. 1.4 - Prob. 1BSCCh. 1.4 - Prob. 2BSCCh. 1.4 - Prob. 3BSCCh. 1.4 - Prob. 4BSCCh. 1.4 - Prob. 5BSCCh. 1.4 - Prob. 6BSCCh. 1.4 - Prob. 7BSCCh. 1.4 - Prob. 8BSCCh. 1.4 - Prob. 9BSCCh. 1.4 - Prob. 10BSCCh. 1.4 - Prob. 11BSCCh. 1.4 - Prob. 12BSCCh. 1.4 - Prob. 13BBCh. 1.4 - Prob. 14BBCh. 1 - Prob. 1CQQCh. 1 - Prob. 2CQQCh. 1 - Prob. 3CQQCh. 1 - Prob. 4CQQCh. 1 - Prob. 5CQQCh. 1 - Prob. 6CQQCh. 1 - Prob. 7CQQCh. 1 - Prob. 8CQQCh. 1 - Prob. 9CQQCh. 1 - Prob. 10CQQCh. 1 - Prob. 1RECh. 1 - Prob. 2RECh. 1 - Prob. 3RECh. 1 - Prob. 4RECh. 1 - Prob. 5RECh. 1 - Prob. 6RECh. 1 - Prob. 7RECh. 1 - Prob. 8RECh. 1 - Prob. 9RECh. 1 - Prob. 10RECh. 1 - Prob. 1CRECh. 1 - Prob. 2CRECh. 1 - Prob. 3CRECh. 1 - Prob. 4CRECh. 1 - Prob. 5CRECh. 1 - Prob. 6CRECh. 1 - Prob. 7CRECh. 1 - Prob. 8CRECh. 1 - Prob. 9CRECh. 1 - Prob. 10CRECh. 1 - Prob. 11CRECh. 1 - Prob. 12CRECh. 1 - Prob. 1EPCh. 1 - Prob. 2EPCh. 1 - Prob. 1FDDCh. 1 - Prob. 2FDDCh. 1 - Prob. 3FDDCh. 1 - Prob. 4FDD
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- You may need to use the appropriate appendix table or technology to answer this question. Suppose that a recent issue of a magazine reported that the average weekly earnings for workers who have not received a high school diploma is $494. Suppose you would like to determine if the average weekly for workers who have received a high school diploma is significantly greater than average weekly earnings for workers who have not received a high school diploma. Data providing the weekly pay for a sample of 50 workers are available in the file named WeeklyHSGradPay. These data are consistent with the findings reported in the article. Weekly Pay 687.73 543.15 789.45 442.26 684.85 661.43 478.3 629.62 486.95 786.47 652.15 652.82 669.81 641.13 577.24 845.68 541.59 553.36 743.25 468.61 821.71 757.82 657.34 506.95 744.93 553.2 827.92 663.85 685.9 637.25 530.54 515.85 588.77 506.62 720.84 503.01 583.18 7,980.24 465.55 593.12 605.33 701.56 491.86 763.4 711.19 631.73 605.89 828.37 477.81…arrow_forwardWrite an analysis about the data gathered.arrow_forwardCalculate the five number summary of the given data. Use the approximation method 15,9,19,7,18,23,5,22,17,3,4,2,9,18,14arrow_forward
- x Feedback Studio E Sex, Gender and IdentityGoog dochub.com/tamyawilliams822/ok2BPdERP1a6LkYKAxpLrN/adding-subtracting-mi tracting Mixed Numbers Worksheet.pdf Sign- You previousl 3-35arrow_forwardWhat should the APA Results section look like?arrow_forwardile C:/Users/anl 8. As was discussed in the Analytics in Action from Chapter 2, the U.S. Census Bureau is a leading source of quantitative data related to the people and economy of the United States. The crosstabulation below represents the number of households (1,000s) and the household income by the highest level of education for the head of household (U.S. Census Bureau web site, 2013). Use this crosstabulation to answer the following questions. Household Income $25,000 to $50,000 to $100,000 $99,999 Highest Level of Education Under Total and Over $49,999 $25,000 32,773 9,441 3,482 9,880 9,970 High school graduate Bachelor's degree Master's degree Doctoral degree 7,817 22,131 4,164 7,666 2,484 4,094 9,003 3,019 685 1,205 422 1,076 1,737 79 160 15,499 20,548 13,128 16,469 65,644 Total a. Develop a joint probability table. b. What is the probability the head of one of these households has a master's degree or higher education? c. What is the probability a household is headed by…arrow_forward
- Find the five-number summary of the given data set. 107, 92, 111, 119, 99, 100, §9, 94, 125, 93,125arrow_forwardYour electronic files, including both excel and word files, must be submitted. Please use a separate worksheet in excel for each question and label them respectively. Please type the section number of your class, name and ID of the team members on the file. 1. Researchers wanted to understand college students' usage of time. A formal survey of 3,000 students was taken and the results are summarized as follows: Activity Attending class Sleeping Socializing & recreation Studying Working, volunteering, student clubs Percentage (%) a) Construct a bar chart, a pie chart, and a Pareto chart. b) What conclusions can you reach concerning what college students do with their time? ii. iii. iv. 9 24 51 7 9 2. Examine the data in the file "Class survey data.xls" posted in the week 5 of course portal. a) Create a descriptive statistics summary table using Data Analysis Toolpak (Add in for Excel) for survey questions 2 through 10 inclusive. b) Identify the data types of each of the 9 variables as…arrow_forwardThe accompanying table represents the average new home size, in square feet, in a country over various years. Construct a display that best represents these data.arrow_forward
- Using the data classification scheme presented in this chapter, identify and classify the information contained in your personal computer or smartphone. Based on the potential for misuse or embarrassment, what information is confidential, sensitive but unclassified, or suitable for public release?arrow_forwardHow to write a follow proper reporting of statistics in APA format without any tables or graphs. Give step-by-step guidance or example.arrow_forwardThe domestic airfare for business travel for the current year and the previous year was reported. A sample of 12 flights with their domestic airfares shown for both years is contained in the Excel Online file below. Construct a spreadsheet to answer the following questions. Due to a recent change by Microsoft you will need to open the XLMiner Analysis ToolPak add-in manually from the home ribbon. Screenshot of ToolPak Open spreadsheet a. Formulate the hypotheses and test for a significant increase in the mean domestic airfare for business travel for the one-year period. Ho: 1-2 ↑ 0 H₂ : 1 - 2 ↑ What are the t-value, degrees of freedom, and p-value t-value Degrees of freedom p-value We (to 4 decimals) Using a .05 level of significance, what is your conclusion? (to 4 decimals) Current Year: $ Previous Year: $ that there has been a significance increase in business travel airfares over the one-year period. b. What is the sample mean domestic airfare for business travel for each year? (to…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
The Shape of Data: Distributions: Crash Course Statistics #7; Author: CrashCourse;https://www.youtube.com/watch?v=bPFNxD3Yg6U;License: Standard YouTube License, CC-BY
Shape, Center, and Spread - Module 20.2 (Part 1); Author: Mrmathblog;https://www.youtube.com/watch?v=COaid7O_Gag;License: Standard YouTube License, CC-BY
Shape, Center and Spread; Author: Emily Murdock;https://www.youtube.com/watch?v=_YyW0DSCzpM;License: Standard Youtube License